Monthly Archives: February 2018

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

  2. Double hop error when using SQLCMD


    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

  3. Windowing without a partition by or an order by


    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

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


    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

  5. Synonyms, how and why.


    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

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


    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

  7. Backups of backups or How long is my backup really available?


    February 7, 2018 by Kenneth Fisher

    I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, …
    Continue reading

  8. SQL Homework – February 2018 – Work with security


    February 5, 2018 by Kenneth Fisher

    This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013