Category Archives: Microsoft SQL Server
-
DBA Myths: You can’t use an alias in a DELETE statement
3September 24, 2013 by Kenneth Fisher
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course, …
Continue reading -
sp_DBPermissions V2.0
1September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading -
sp_SrvPermissions V2.0
1September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading -
Brad Shultz’s blog on reviewing your database
1September 17, 2013 by Kenneth Fisher
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
Continue reading -
DBA Myths: You can’t use an alias in an UPDATE statement.
4September 16, 2013 by Kenneth Fisher
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an …
Continue reading -
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
SQL Studies 