Category Archives: Microsoft SQL Server

  1. Installing SQLCMD

    Leave a comment

    October 19, 2016 by Kenneth Fisher

    For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says …
    Continue reading

  2. Using Snippets

    Leave a comment

    October 17, 2016 by Kenneth Fisher

    A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
    Continue reading

  3. Too many indexes!

    Leave a comment

    October 13, 2016 by Kenneth Fisher

    Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work …
    Continue reading

  4. If backups are taken in silence can a recovery still take place?


    October 11, 2016 by Kenneth Fisher

    My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a …
    Continue reading

  5. Floor, Round, and Ceiling

    Leave a comment

    October 5, 2016 by Kenneth Fisher

    I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that …
    Continue reading

  6. Becoming a Microsoft MVP


    October 3, 2016 by Kenneth Fisher

    I was awarded the Microsoft MVP (data platform) award on Saturday. On the four days a year (one per quarter) …
    Continue reading

  7. Pinned Tabs


    September 27, 2016 by Kenneth Fisher

    It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) …
    Continue reading

  8. A quick fix for a full identity column.


    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

  9. Using an ORDER BY in a view


    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

  10. Emojis in SQL Server


    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

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

Join 1,580 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013