Category Archives: SQLServerPedia Syndication
-
Default reports in SSMS
2July 13, 2017 by Kenneth Fisher
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are …
Continue reading -
Save and save often
2July 11, 2017 by Kenneth Fisher
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday! …
Continue reading -
What is the system_health extended events session?
5July 5, 2017 by Kenneth Fisher
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about …
Continue reading -
SQL Homework – July 2017
11July 3, 2017 by Kenneth Fisher
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a …
Continue reading -
SQL Crossword : T-SQL Keywords : June 2017
4June 28, 2017 by Kenneth Fisher
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked …
Continue reading -
Temp table quiz
10June 26, 2017 by Kenneth Fisher
Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll …
Continue reading -
Dynamically generate the command line DMA statement for each database
1June 21, 2017 by Kenneth Fisher
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run …
Continue reading -
Adding Identity to an existing column
2June 19, 2017 by Kenneth Fisher
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
Continue reading -
Turning ANSI_PADDING off, and why you shouldn’t
4June 15, 2017 by Kenneth Fisher
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
Continue reading -
Buzzword Bingo
Leave a commentJune 13, 2017 by Kenneth Fisher
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS. …
Continue reading
SQL Studies 