Tag Archives: microsoft sql server

  1. T-SQL Formatters

    3

    August 6, 2018 by Kenneth Fisher

    The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, …
    Continue reading

  2. RESTORE VERIFYONLY what does WITH LOADHISTORY do?

    2

    July 18, 2018 by Kenneth Fisher

    Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the …
    Continue reading

  3. Counting NULLs

    4

    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

  4. SQL Homework – July 2018 – Create a SQL Agent Job

    Leave a comment

    July 2, 2018 by Kenneth Fisher

    For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used …
    Continue reading

  5. SQL Puzzle – FizzBuzz3d

    18

    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

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

    3

    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

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

    1

    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

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

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

  10. Updated query to view data in the error log

    2

    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

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

Join 2,470 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013