Daily Coping 16 Sep 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-09-16
30 reads
Blog Posts
If not me, then who?
[Content Warning: this post contains references to subjects that may trigger a trauma response. Read with caution.] This is not a technical post. I was going to write about...
2020-09-16
49 reads
Resizing Tempdb (When TEMPDB Wont Shrink)
Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...
2020-09-16 (first published: 2020-09-09)
880 reads
Automate Credit Card Audits
In this article, I have shown how to use the power of automation to help identify the risk of having card data stored in the database. Identifying this risk...
2020-09-15 (first published: 2020-09-08)
266 reads
Automation Ideas for T-SQL Tuesday #130
This month we have another great T-SQL Tuesday topic, and again, a host that I pressured into writing the invitation. Elizabeth Noble (@SQLZelda) and I were talking DevOps last...
2020-09-15 (first published: 2020-09-08)
658 reads
Azure DevOps at the Data Platform Summit 2020
I was lucky enough to go to the Data Platform Summit in 2017. I still have one of my favorite speaking pictures from the event: I took my whole...
2020-09-15
21 reads
Daily Coping 15 Aug 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-09-15
2 reads
Daily Coping 14 Sep 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-09-14
15 reads
Reflections on Being a New Gopher With A Dotnet Background
Disclaimer
Newbie Gopher.
Much of what I observe is likely to be half right.
I’ll probably look back at the end of the year and shake my head, but gotta start the...
2020-09-14 (first published: 2020-09-07)
275 reads
T-SQL Tuesday #130 – Automate Permissions Audits
This month’s T-SQL Tuesday is being hosted by Elizabeth Noble. The subject chosen “what have you automated to make your life easier?” For me the topic is near and...
2020-09-14 (first published: 2020-09-08)
437 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