Monthly Archives: April 2018

  1. SQL and Azure Maze

    Leave a comment

    April 30, 2018 by Kenneth Fisher

    Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found …
    Continue reading

  2. What is a DBA?

    Leave a comment

    April 25, 2018 by Kenneth Fisher

    If you’ve worked in the data industry for more than few minutes then you’ve probably heard the phrase The DBA …
    Continue reading

  3. Command shell steps in SQL Agent jobs only process a single command.


    April 23, 2018 by Kenneth Fisher

    I was working on a SQL Agent job recently that required a series of command shell commands. And it would …
    Continue reading

  4. Exploring system tables, views, SPs etc

    Leave a comment

    April 18, 2018 by Kenneth Fisher

    I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have …
    Continue reading

  5. I’ve gotten a transaction log full error but when I look it’s not full??


    April 16, 2018 by Kenneth Fisher

    Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
    Continue reading

  6. Deleting a lot of data


    April 12, 2018 by Kenneth Fisher

    I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
    Continue reading

  7. Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101


    April 10, 2018 by Kenneth Fisher

    Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
    Continue reading

  8. SSMS’s Dark Theme


    April 4, 2018 by Kenneth Fisher

    There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
    Continue reading

  9. SQL Homework – April 2018 – Indexes

    Leave a comment

    April 2, 2018 by Kenneth Fisher

    This month we are going to look at a topic near and dear to both database developers and database administrators …
    Continue reading

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

Join 2,484 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013