-
What port is my instance listening on?
8January 8, 2013 by Kenneth Fisher
I just had the interesting task of finding the port number that one of the instances I deal with is …
Continue reading -
How I like to learn a t-sql command
11January 7, 2013 by Kenneth Fisher
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands …
Continue reading -
Red errors in the results pane
3December 19, 2012 by Kenneth Fisher
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed …
Continue reading -
Generating multiple SQL statements from a query
2December 17, 2012 by Kenneth Fisher
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
Continue reading -
Where is my backup?
10December 12, 2012 by Kenneth Fisher
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working …
Continue reading -
Copying Connection Managers in SSIS
Leave a commentDecember 10, 2012 by Kenneth Fisher
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit …
Continue reading -
Creating an empty table from a SELECT statement
12November 26, 2012 by Kenneth Fisher
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W. …
Continue reading -
CTEs beyond SELECT
5November 20, 2012 by Kenneth Fisher
The other day I was writing a query to pull some DMV information and I ended up using several CTEs …
Continue reading -
Looping through multiple servers in SSIS Part 3
29November 15, 2012 by Kenneth Fisher
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 