Monthly Archives: December 2015

  1. Do you check for TRUSTWORTHY databases as part of your security audits?


    December 30, 2015 by Kenneth Fisher

    I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
    Continue reading

  2. What does that N in nvarchar really mean?


    December 28, 2015 by Kenneth Fisher

    In any study of Data Types in SQL Server you are going to have to look at the various string …
    Continue reading

  3. ‘Twas 4:45 Friday

    Leave a comment

    December 23, 2015 by Kenneth Fisher

    I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents …
    Continue reading

  4. What is the current database context?


    December 21, 2015 by Kenneth Fisher

    Every now and again it can be very helpful to know what the current database context is when you are …
    Continue reading

  5. Scripting out multiple scripts from the Object Explorer Details window.


    December 16, 2015 by Kenneth Fisher

    A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what …
    Continue reading

  6. Can we get a license for DDL Triggers?


    December 14, 2015 by Kenneth Fisher

    There are several types of triggers. Logon triggers – Fired when someone tries to connect to the instance. DML triggers …
    Continue reading

  7. Using unique constraints


    December 10, 2015 by Kenneth Fisher

    I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was …
    Continue reading

  8. Apathy – A quick path to the naughty list.

    Leave a comment

    December 8, 2015 by Kenneth Fisher

    It’s the Christmas season! And it’s T-SQL Tuesday! And Bradley Ball (b/t), SQL’s very own superhero (one of many really …
    Continue reading

  9. DBA Myths: Database file extentions


    December 2, 2015 by Kenneth Fisher

    Every now and again I hear or read that the only file extensions for a SQL Server database are mdf, …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013