-
Certifications: What are they good for?
5September 11, 2013 by Kenneth Fisher
Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and …
Continue reading -
A T-SQL query to get current job activity
30September 5, 2013 by Kenneth Fisher
I recently had the task of collecting job activity for the purposes of turning it into a report for some …
Continue reading -
When I run “Script as” it isn’t (or is) … How do I fix it?
1September 3, 2013 by Kenneth Fisher
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix …
Continue reading -
The most important skill to practice when preparing for any certification exam!
4August 28, 2013 by Kenneth Fisher
I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an …
Continue reading -
The effect of VLF size on shrinking the log.
3August 26, 2013 by Kenneth Fisher
I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided …
Continue reading -
Lots of ways to UNPIVOT a table
Leave a commentAugust 21, 2013 by Kenneth Fisher
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated …
Continue reading -
sp_SrvPermissions
Leave a commentAugust 19, 2013 by Kenneth Fisher
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
Continue reading -
“My transaction log is too big!”
4August 12, 2013 by Kenneth Fisher
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written, …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 