Tag Archives: Microsoft SQL Server

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

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

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

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

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

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

  7. Hugo’s SQL Server Execution Plan Reference

    Leave a comment

    March 18, 2019 by Kenneth Fisher

    I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and …
    Continue reading

  8. Querying temp tables across a linked server.

    2

    March 14, 2019 by Kenneth Fisher

    And if you are still reading you probably fit into one of the following categories. Not a DBA A relatively …
    Continue reading

  9. Disabling and enabling triggers

    1

    March 6, 2019 by Kenneth Fisher

    I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now …
    Continue reading

  10. SQL Homework – March 2019 – Reconfigure tempdb

    Leave a comment

    March 4, 2019 by Kenneth Fisher

    You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor …
    Continue reading

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

Join 2,503 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013