Tag Archives: microsoft sql server

  1. Padding a string in SQL Server

    1

    July 15, 2021 by Kenneth Fisher

    I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to …
    Continue reading

  2. DDL Trigger to log database level security commands.

    3

    June 24, 2021 by Kenneth Fisher

    In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
    Continue reading

  3. CROSS vs OUTER APPLY

    2

    June 10, 2021 by Kenneth Fisher

    I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
    Continue reading

  4. Use BCP to create a CSV (comma delimited) file from a table.

    1

    June 3, 2021 by Kenneth Fisher

    This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one …
    Continue reading

  5. Creating a configurable SSMS script

    1

    May 18, 2021 by Kenneth Fisher

    Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
    Continue reading

  6. How do I test if a linked server works using T-SQL?

    4

    October 27, 2020 by Kenneth Fisher

    I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
    Continue reading

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

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

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

Join 3,545 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013