1. Fun with sp_rename

    Leave a comment

    January 11, 2018 by Kenneth Fisher

    Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in …
    Continue reading

  2. A Solution for Squirrely SQL Server Security: TSQL Tuesday #98

    Leave a comment

    January 9, 2018 by Kenneth Fisher

    It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
    Continue reading

  3. SQL Homework – January 2017 – Inspect an Execution Plan

    6

    January 3, 2018 by Kenneth Fisher

    It’s a new year and yet education never ends. So this month let’s take a look at an important part …
    Continue reading

  4. What is impersonation for?

    2

    December 27, 2017 by Kenneth Fisher

    I was doing some research on impersonation the other day, and among other things, I ran across a forum question …
    Continue reading

  5. Making music with Powershell

    3

    December 20, 2017 by Kenneth Fisher

    Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing …
    Continue reading

  6. When do usernames and passwords belong in connection strings

    Leave a comment

    December 18, 2017 by Kenneth Fisher

    tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your …
    Continue reading

  7. How to: Create an Azure VM with SQL Server using a default template

    1

    December 14, 2017 by Kenneth Fisher

    One of the really cool things about the cloud is how quickly you can spin up a new machine to …
    Continue reading

  8. T-SQL Tuesday #97 – Setting learning goals for 2018

    3

    December 12, 2017 by Kenneth Fisher

    T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic …
    Continue reading

  9. Restrict the usage of a SQL Server Authenticated Application Id

    1

    December 6, 2017 by Kenneth Fisher

    SQL Server login ids may not be the most secure thing in the world but they are likely to be …
    Continue reading

  10. SQL Homework – December 2017 – View the log

    1

    December 4, 2017 by Kenneth Fisher

    Last homework of the year. Last month was to create a view. This month it’s time to take a look …
    Continue reading

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

Join 2,163 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013