Category Archives: Documentation
-
Cloud Security
1August 22, 2016 by Kenneth Fisher
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those …
Continue reading -
What permissions do I need?
Leave a commentMarch 16, 2016 by Kenneth Fisher
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
Continue reading -
SSMS Connection Information
Leave a commentSeptember 28, 2015 by Kenneth Fisher
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it …
Continue reading -
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
8May 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
6March 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
