1. The default instance has a name

    2

    August 31, 2015 by Kenneth Fisher

    The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but …
    Continue reading

  2. The 30 minute rule

    3

    August 26, 2015 by Kenneth Fisher

    In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. …
    Continue reading

  3. The tail of the log

    Leave a comment

    August 24, 2015 by Kenneth Fisher

    The tail of the log A little while back I was feeling overwhelmed by the number of blog posts ideas …
    Continue reading

  4. SSMS’s Clipboard Manager

    10

    August 19, 2015 by Kenneth Fisher

    The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask …
    Continue reading

  5. Pulling data from the error log

    6

    August 17, 2015 by Kenneth Fisher

    The other day I was asked to pull a list of errors from the SQL Server log into a table …
    Continue reading

  6. Getting and storing a high precision datetime

    5

    August 13, 2015 by Kenneth Fisher

    Earlier today I was working on a project where I was recording some time stamps. In order to get as …
    Continue reading

  7. Database Master Keys can have more than one password.

    3

    August 11, 2015 by Kenneth Fisher

    Our subject for this month’s T-SQL Tuesday blog party (#69) is Encryption, hosted by a guy with an awesome first …
    Continue reading

  8. A pattern to match correctly on a value or a NULL

    3

    August 5, 2015 by Kenneth Fisher

    As you may have noticed if you read my blog I learn a lot from trolling various forums. In this …
    Continue reading

  9. SQL Crossword

    Leave a comment

    August 3, 2015 by Kenneth Fisher

    I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF …
    Continue reading

  10. Some of my favorite SSMS Keyboard shortcuts

    11

    July 29, 2015 by Kenneth Fisher

    I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 804 other followers