Working with SQL Server Data Files
Most people connect to a database, create tables, run update statements, tune queries, add indexes, and never once think about the underlying data and log files that support all...
2019-09-04
1 reads
Blog Posts
Working with SQL Server Data Files
Most people connect to a database, create tables, run update statements, tune queries, add indexes, and never once think about the underlying data and log files that support all...
2019-09-04
Working with SQL Server Data Files
Most people connect to a database, create tables, run update statements, tune queries, add indexes, and never once think about the underlying data and log files that support all...
2019-09-04
3 reads
Docker Image Tags are Case Sensitive
A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going...
2019-09-03
276 reads
Docker Image Tags are Case Sensitive
A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going...
2019-09-03
105 reads
New Centralized View of SQL Resources in Azure
Yesterday, some new views were made available in the Azure portal that will be helpful to those of us who create or manage Azure SQL resources. First, a new...
2019-09-03 (first published: 2019-08-22)
304 reads
Q&A: Dealing with Thousands of Databases
This is part one of a three-part series. I’ve mentioned in various places, including in blog posts on occasion, that my production SQL Server instance hosts several thousand (nearly...
2019-09-03
307 reads
Q&A: Dealing with Thousands of Databases
This is part one of a three-part series.
I’ve mentioned in various places, including in blog posts on occasion, that my production SQL Server instance hosts several thousand (nearly 9000...
2019-09-03
2 reads
Speaker at Music City Tech 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
16 reads
Techorama Netherlands 2019
You only have a few more weeks to sign up for one of my favorite events, Techorama. This year is the second time the event will be held in...
2019-09-03
6 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