Category Archives: Microsoft SQL Server

  1. Querying temp tables across a linked server.

    2

    March 14, 2019 by Kenneth Fisher

    And if you are still reading you probably fit into one of the following categories. Not a DBA A relatively …
    Continue reading

  2. Dipping into the Cookie Jar: T-SQL Tuesday #112

    1

    March 12, 2019 by Kenneth Fisher

    This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies. …
    Continue reading

  3. Disabling and enabling triggers

    1

    March 6, 2019 by Kenneth Fisher

    I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now …
    Continue reading

  4. SQL Homework – March 2019 – Reconfigure tempdb

    Leave a comment

    March 4, 2019 by Kenneth Fisher

    You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor …
    Continue reading

  5. Using the Microsoft Authenticator app to log into Azure

    Leave a comment

    February 25, 2019 by Kenneth Fisher

    So I was trying to work on a blog post about the new truncation error this morning and realized I …
    Continue reading

  6. Why do I (they) own that database?

    2

    February 20, 2019 by Kenneth Fisher

    Ever looked at the list of databases and wonder why you own one of them? Or why some other user …
    Continue reading

  7. Error in SSMS: Attempted to read or write protected memory.

    2

    February 18, 2019 by Kenneth Fisher

    There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked …
    Continue reading

  8. DBA Myths: Can a differential backup get bigger than the full backup?

    7

    February 14, 2019 by Kenneth Fisher

    The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one …
    Continue reading

  9. What is your why?: T-SQL Tuesday #111

    Leave a comment

    February 12, 2019 by Kenneth Fisher

    This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I …
    Continue reading

  10. SQL Homework – February 2019 – Instance configurations

    4

    February 4, 2019 by Kenneth Fisher

    This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not …
    Continue reading

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

Join 2,493 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013