Tag Archives: microsoft sql server

  1. A quick fix for a full identity column.

    Leave a comment

    September 21, 2016 by Kenneth Fisher

    A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following: …
    Continue reading

  2. Using an ORDER BY in a view

    18

    September 19, 2016 by Kenneth Fisher

    For many years it’s been a best practice to never put an ORDER BY in a view. The idea is …
    Continue reading

  3. Emojis in SQL Server

    8

    September 15, 2016 by Kenneth Fisher

    I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures …
    Continue reading

  4. SA Spoof

    14

    September 8, 2016 by Kenneth Fisher

    This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are …
    Continue reading

  5. Accidental DBAs, the Developer Edition

    Leave a comment

    September 6, 2016 by Kenneth Fisher

    I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers …
    Continue reading

  6. The new Data Migration Assistant has been released!

    2

    August 31, 2016 by Kenneth Fisher

    Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released. First things first the …
    Continue reading

  7. Natural vs Artificial Primary Keys

    2

    August 29, 2016 by Kenneth Fisher

    There has been a long standing debate over the use of a natural primary key vs an artificial one. I …
    Continue reading

  8. RBAR vs Batch

    7

    August 17, 2016 by Kenneth Fisher

    Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
    Continue reading

  9. Write-Only permissions

    3

    August 11, 2016 by Kenneth Fisher

    Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other …
    Continue reading

  10. What’s the difference between LEFT and RIGHT OUTER JOINs?

    Leave a comment

    August 3, 2016 by Kenneth Fisher

    A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?” There are several …
    Continue reading

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

Join 1,245 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013