1. Constraint names, Say NO to the default

    6

    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

  2. Except and Intersect

    4

    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

  3. 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

  4. 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

  5. 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

  6. 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

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

    4

    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

  8. 2014 in review

    Leave a comment

    December 30, 2014 by Kenneth Fisher

    The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has …
    Continue reading

  9. Finding a common AD group for a set of users.

    7

    December 29, 2014 by Kenneth Fisher

    I work for a large organization that over the last few years has been doing a LOT of reorgs. And …
    Continue reading

  10. Do you want to build an Audit?

    Leave a comment

    December 29, 2014 by Kenneth Fisher

    So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 578 other followers