Tag Archives: Microsoft SQL Server

  1. Shrinking a large database with limited outage windows

    6

    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

    Category: DBCC, Microsoft SQL Server, SQLServerPedia Syndication | Tags: ,

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

    Category: Microsoft SQL Server, Problem Resolution, Security, SQL Agent Jobs, SQLServerPedia Syndication | Tags: , ,

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

    Category: Impersonation, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: , ,

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

    Category: DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL Tuesday | Tags: , ,

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

    Category: Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , ,

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

    Category: Connection Strings, Microsoft SQL Server, SQLServerPedia Syndication, SSMS | Tags: , ,

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

    Category: Microsoft SQL Server, Settings, SQLServerPedia Syndication, SSMS, T-SQL | Tags: , , , ,

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

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , ,

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

    Category: Documentation, Microsoft SQL Server, Query Plans, SQLServerPedia Syndication | Tags: ,

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

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

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

Join 2,493 other followers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013