Monthly Archives: January 2015

  1. A quick email interview of Pass President Thomas LaRock

    2

    January 28, 2015 by Kenneth Fisher

    Back in December I had the thought that it would be fun to do an email interview with someone. As …
    Continue reading

  2. SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

    1

    January 26, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

  3. Constraint names, Say NO to the default

    12

    January 21, 2015 by Kenneth Fisher

    Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it …
    Continue reading

  4. Except and Intersect

    7

    January 19, 2015 by Kenneth Fisher

    EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in …
    Continue reading

  5. Pagination in SQL Server

    5

    January 15, 2015 by Kenneth Fisher

    It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL …
    Continue reading

  6. TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?

    Leave a comment

    January 13, 2015 by Kenneth Fisher

    I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this …
    Continue reading

  7. Discussing Security with Boris Hristov on SQLHangout #29

    Leave a comment

    January 12, 2015 by Kenneth Fisher

    Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I …
    Continue reading

  8. Finding the reason for the error “Subquery returned more than 1 value”

    1

    January 7, 2015 by Kenneth Fisher

    First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
    Continue reading

  9. SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

    5

    January 5, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

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

Join 1,615 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013