Tag Archives: microsoft sql server

  1. Counting NULLs


    July 16, 2018 by Kenneth Fisher

    Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As …
    Continue reading

  2. SQL Puzzle – FizzBuzz3d


    June 27, 2018 by Kenneth Fisher

    I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case …
    Continue reading

  3. Be our guest, be our guest, put our database to the test.


    June 25, 2018 by Kenneth Fisher

    When I think of the public role I often think of the guest database principal (user) at the same time. …
    Continue reading

  4. The identity column, the insert and the linked server.


    June 14, 2018 by Kenneth Fisher

    tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
    Continue reading

  5. What queries are getting blocked?

    Leave a comment

    June 6, 2018 by Kenneth Fisher

    Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how …
    Continue reading

  6. The public role


    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

  7. What are the system databases?


    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

  8. The trials and tribulations of REVERTing from impersonation


    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

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


    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

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

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

Join 3,570 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013