Category Archives: SQLServerPedia Syndication
-
What is the CONTROL permission?
Leave a commentJanuary 19, 2021 by Kenneth Fisher
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
Continue reading -
Sometimes a change is as good as a break : T-SQL Tuesday #134
Leave a commentJanuary 12, 2021 by Kenneth Fisher
James McGillivray (blog|twitter) wants us to give him a break. Well. Actually I guess he wants to know how we …
Continue reading -
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
Leave a commentJanuary 5, 2021 by Kenneth Fisher
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true …
Continue reading -
Hope!
2December 31, 2020 by Kenneth Fisher
2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s …
Continue reading -
SQL Homework – December 2020 – Participate in the Advent of Code.
Leave a commentDecember 3, 2020 by Kenneth Fisher
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect …
Continue reading -
A quick and dirty scan of a list of instances using a dynamic linked server.
5November 12, 2020 by Kenneth Fisher
Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently …
Continue reading -
I get by with a little help from my friends : T-SQL Tuesday #132
Leave a commentNovember 10, 2020 by Kenneth Fisher
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our …
Continue reading -
Adding a user to an Azure SQL DB
1November 5, 2020 by Kenneth Fisher
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
Continue reading -
SQL Homework – November 2020 – Help!
Leave a commentNovember 3, 2020 by Kenneth Fisher
If you ask any senior IT person What is the most important tool you have? there is a decent chance that …
Continue reading -
How do I test if a linked server works using T-SQL?
4October 27, 2020 by Kenneth Fisher
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
Continue reading
