Monthly Archives: September 2013

  1. The MERGE statement doesn’t have a WHERE clause.

    5

    September 30, 2013 by Kenneth Fisher

    What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw …
    Continue reading

  2. Detaching a database

    1

    September 26, 2013 by Kenneth Fisher

    In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL …
    Continue reading

  3. DBA Myths: You can’t use an alias in a DELETE statement

    1

    September 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

  4. sp_DBPermissions V2.0

    1

    September 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

  5. sp_SrvPermissions V2.0

    1

    September 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

  6. Brad Shultz’s blog on reviewing your database

    1

    September 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

  7. DBA Myths: You can’t use an alias in an UPDATE statement.

    2

    September 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

  8. Certifications: What are they good for?

    5

    September 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

  9. How do the fixed Database and Server roles map to more specific permissions?

    Leave a comment

    September 9, 2013 by Kenneth Fisher

    I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the …
    Continue reading

  10. A T-SQL query to get current job activity

    20

    September 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,606 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013