Daily Coping 5 Oct 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-10-05
7 reads
Blog Posts
2020-10-04
23 reads
Azure SQL Database Compatibility with SQL Server
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
2,059 reads
Daily Coping 2 Oct 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-10-02
13 reads
Missing SQL Bits
This week is SQL Bits week, which is taking place virtually over in the UK. Things are planned for UK time, and speakers are accommodating them. I had a...
2020-10-02
21 reads
VMworld 2020 – Top 10 Database Sessions (Part 2)
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member of IT managing SQL Servers in a virtualized environment, you should already be registered for...
2020-10-02 (first published: 2020-09-25)
360 reads
VMworld 2020 SQL Server Session Open Q&A – Oct 15
If you were fortunate enough to catch our VMworld 2020 conference session on architecting SQL Server performance for hybrid cloud architectures, you’ll notice that there were no opportunities for...
2020-10-02
18 reads
Daily Coping 1 Oct 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-10-01
13 reads
PASS Virtual Summit 2020 Conference Sessions
Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be attending this year’s PASS Summit 2020 conference, held virtually from November 10 to 13th online....
2020-10-01
107 reads
Review: Stellar Repair for SQL Server
I was contacted by Stellar Info quite a while ago. They asked me to try out their software. I said yes, but I was really bad about getting it...
2020-10-01 (first published: 2020-09-23)
290 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers