Category Archives: Microsoft SQL Server

  1. Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties

    Leave a comment

    August 20, 2018 by Kenneth Fisher

    Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
    Continue reading

  2. What are my permissions?

    Leave a comment

    August 16, 2018 by Kenneth Fisher

    Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
    Continue reading

  3. Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104

    Leave a comment

    August 14, 2018 by Kenneth Fisher

    Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started …
    Continue reading

  4. Putting Object Explorer etc on the right side of SSMS rather than the left.

    Leave a comment

    August 8, 2018 by Kenneth Fisher

    A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS. …
    Continue reading

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

  6. SQL Homework – August 2018 – Set up database mail

    Leave a comment

    August 1, 2018 by Kenneth Fisher

    This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail. Why database mail? …
    Continue reading

  7. Processes can dramatically improve your work until they don’t.

    Leave a comment

    July 23, 2018 by Kenneth Fisher

    As always with something like this, I like to start with a definition so we are all starting in the …
    Continue reading

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

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

  10. Balancing Security Concerns.

    2

    July 12, 2018 by Kenneth Fisher

    I have a presentation I do every now again on security basics that I’m actually quite proud of. One of …
    Continue reading

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

Join 2,442 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013