1. DB_NAME() vs ORIGINAL_DB_NAME()

    1

    March 15, 2018 by Kenneth Fisher

    I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
    Continue reading

  2. A look back from the future. – TSQL Tuesday #100

    3

    March 13, 2018 by Kenneth Fisher

    The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact …
    Continue reading

  3. Simply Debugging

    3

    March 7, 2018 by Kenneth Fisher

    Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
    Continue reading

  4. SQL Homework – March 2018 – Recovery Objectives

    Leave a comment

    March 5, 2018 by Kenneth Fisher

    My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
    Continue reading

  5. A day in the life of a Sr DBA/Dev

    Leave a comment

    February 28, 2018 by Kenneth Fisher

    If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points …
    Continue reading

  6. Double hop error when using SQLCMD

    2

    February 26, 2018 by Kenneth Fisher

    tl;dr; SQLCMD v2014 and up has special requirements for Kerberos. One of the problems with linked servers (no rude noises …
    Continue reading

  7. Windowing without a partition by or an order by

    2

    February 21, 2018 by Kenneth Fisher

    If you’ve never worked with windowing functions they look something like this: The other day someone mentioned that you could …
    Continue reading

  8. The default filegroup, and why you should care.

    2

    February 19, 2018 by Kenneth Fisher

    You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
    Continue reading

  9. Synonyms, how and why.

    6

    February 15, 2018 by Kenneth Fisher

    Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
    Continue reading

  10. Hobbies, stress relief, and meeting management: T-SQL Tuesday #99

    2

    February 13, 2018 by Kenneth Fisher

    It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that …
    Continue reading

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

Join 2,176 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013