1. The public role

    1

    May 23, 2018 by Kenneth Fisher

    A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. …
    Continue reading

  2. What are the system databases?

    4

    May 21, 2018 by Kenneth Fisher

    I get to help with technical interviews every now and again, and one of the questions we always ask is …
    Continue reading

  3. The trials and tribulations of REVERTing from impersonation

    1

    May 16, 2018 by Kenneth Fisher

    Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure …
    Continue reading

  4. Blogging and when to keep your big mouth shut

    1

    May 14, 2018 by Kenneth Fisher

    I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few …
    Continue reading

  5. Each session should be able to have its own temp table, but there can be problems.

    1

    May 10, 2018 by Kenneth Fisher

    You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things …
    Continue reading

  6. Why I blog: TSQL Tuesday #102

    2

    May 8, 2018 by Kenneth Fisher

    It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given …
    Continue reading

  7. SQL Homework – May 2018 – Create a database

    1

    May 2, 2018 by Kenneth Fisher

    I’ve really got to make a plan here at some point. So far I’ve been just putting down things as …
    Continue reading

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

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

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

    1

    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

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

Join 2,182 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013