Category Archives: Documentation
-
TSQL Tuesday #68: What is my configuration?
2July 14, 2015 by Kenneth Fisher
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just …
Continue reading -
Pass TV
3June 17, 2015 by Kenneth Fisher
Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an …
Continue reading -
Extending your metadata with Extended Properties
9May 18, 2015 by Kenneth Fisher
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
Continue reading -
Using Solutions in SSMS
16March 11, 2015 by Kenneth Fisher
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
Continue reading -
Required reading before upgrading SQL Server.
5October 8, 2014 by Kenneth Fisher
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q …
Continue reading -
What I know about batch files
25September 24, 2014 by Kenneth Fisher
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how …
Continue reading -
Make BOL your friend
2June 30, 2014 by Kenneth Fisher
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work …
Continue reading -
MJ Swart offers free technical editing
1June 9, 2014 by Kenneth Fisher
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me …
Continue reading -
Microsoft’s free virtual labs
1May 26, 2014 by Kenneth Fisher
If you have spent any time looking around my site, you will notice that I love study materials and in …
Continue reading
SQL Studies 