SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect ... Continue reading
2020-12-03
86 reads
[Video] Azure SQL Database – Import a Database
Quick Video showing you have to use a BACPAC to “import” a database into Azure (Via Storage container),
2020-12-03
88 reads
Requesting Comments on the SQLOrlando Operations Manual
For the past couple weeks I’ve been trying to capture a lot of ideas about how and what and why we do things in Orlando and put them into...
2020-12-02
55 reads
Ignoring Comments in SQL Compare
Recently I had a client that wanted to know how they could use SQL Compare to catch actual changes in their code, but not have comments show up as...
2020-12-14 (first published: 2020-12-02)
221 reads
PASS SQLSaturday’s I will be speaking at
I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that you can attend virtually: Azure Synapse Analytics: A Data Lakehouse 12/5/20, 1:10pm EST, PASS SQL...
2020-12-02
34 reads
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB...
2020-12-02
28 reads
Daily Coping 2 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-02
20 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
26 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
225 reads
New-DbatoolsQuestion | Invoke-DbatoolsDiscussion -Platform Github
Chrissy LeMaire (blog | twitter) pinged me earlier this week to tell me about Github Discussions. It’s a new feature of Github which is similar to Stack Exchange, but...
2020-12-02
9 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers