Category Archives: SQLServerPedia Syndication

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

    Leave a comment

    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

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

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

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

  5. Updated query to view data in the error log


    May 31, 2018 by Kenneth Fisher

    This is one of my favorite scripts. It pulls all of the data from the error log and dumps it …
    Continue reading

  6. An interview with Brent Ozar


    May 30, 2018 by Kenneth Fisher

    I was talking about interviews (although not the job kind) with a friend and it reminded me of the time …
    Continue reading

  7. Interview questions: What’s the first thing you would do if a user reports slowness.


    May 28, 2018 by Kenneth Fisher

    We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do …
    Continue reading

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

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

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

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

Join 2,424 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013