Category Archives: Documentation
-
What SQL Server components are installed on this machine?
2September 14, 2015 by Kenneth Fisher
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has …
Continue reading -
Where you should start when managing an enterprise
Leave a commentSeptember 8, 2015 by Kenneth Fisher
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us …
Continue reading -
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
11March 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.
4October 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
23September 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
