1. Shrinking a large database with limited outage windows

    2

    April 22, 2019 by Kenneth Fisher

    Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where …
    Continue reading

  2. It’s all just data.

    2

    April 17, 2019 by Kenneth Fisher

    Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on …
    Continue reading

  3. How do I let someone execute a SQL Agent job they don’t own?

    2

    April 15, 2019 by Kenneth Fisher

    In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
    Continue reading

  4. Can SQL Ids be used on an instance with Windows Authentication only?

    2

    April 11, 2019 by Kenneth Fisher

    tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
    Continue reading

  5. Writing Crossword puzzles with a database: T-SQL Tuesday #113

    2

    April 9, 2019 by Kenneth Fisher

    Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases …
    Continue reading

  6. SQL Homework – April 2019 – Practice dealing with corruption

    Leave a comment

    April 3, 2019 by Kenneth Fisher

    Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of …
    Continue reading

  7. Making a life change

    6

    April 1, 2019 by Kenneth Fisher

    It is with a very heavy heart that I announce I will no longer be working with SQL Server. In …
    Continue reading

  8. A transport-level error has occurred when sending the request to the server.

    4

    March 27, 2019 by Kenneth Fisher

    Brent recently did a post called In Azure SQL DB, what does “The connection is broken and recovery is not …
    Continue reading

  9. What version of SQL is SSMS scripting for?

    Leave a comment

    March 25, 2019 by Kenneth Fisher

    Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
    Continue reading

  10. Mixed feelings over the new truncation error

    2

    March 20, 2019 by Kenneth Fisher

    As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. …
    Continue reading

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

Join 2,492 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013