Monthly Archives: June 2018

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

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

  3. Strings vs Identifiers


    June 20, 2018 by Kenneth Fisher

    A common mistake, and one I make frequently myself is to use a string in place of an identifier, or …
    Continue reading

  4. Misleading errors: “Server is configured for Windows authentication only.” But it’s not!


    June 18, 2018 by Kenneth Fisher

    In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just …
    Continue reading

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

  6. Moving to Azure: A change in processes – TSQL Tuesday 103


    June 12, 2018 by Kenneth Fisher

    For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database …
    Continue reading

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

  8. SQL Homework – June 2018 – Alter a database

    Leave a comment

    June 4, 2018 by Kenneth Fisher

    Here we are again. The beginning of another month. At the beginning of each month I put out a SQL …
    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