Category Archives: Microsoft SQL Server

  1. SQL Connectivity issues: A guided walk through

    Leave a comment

    February 6, 2017 by Kenneth Fisher

    The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues. Announcement Walk Through If …
    Continue reading

  2. Changing what SSMS opens on startup

    Leave a comment

    February 1, 2017 by Kenneth Fisher

    When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and …
    Continue reading

  3. My SQL logins don’t work. Again.

    Leave a comment

    January 25, 2017 by Kenneth Fisher

    My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
    Continue reading

  4. Creating a connect entry.

    4

    January 23, 2017 by Kenneth Fisher

    I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of …
    Continue reading

  5. Lead Blocker

    7

    January 18, 2017 by Kenneth Fisher

    Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
    Continue reading

  6. What is COPY_ONLY?

    2

    January 16, 2017 by Kenneth Fisher

    You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up …
    Continue reading

  7. Why won’t my SQL Logins work?

    10

    January 12, 2017 by Kenneth Fisher

    I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
    Continue reading

  8. Connect suggestion to add included columns to sp_helpindex

    Leave a comment

    January 10, 2017 by Kenneth Fisher

    I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the …
    Continue reading

  9. sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

    Leave a comment

    December 28, 2016 by Kenneth Fisher

    Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
    Continue reading

  10. A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

    Leave a comment

    December 26, 2016 by Kenneth Fisher

    I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery …
    Continue reading

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

Join 1,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013