sp_RestoreScript 1.8 Now Released
It looks like there was a bug lurking in sp_RestoreScript that was causing the wrong ALTER DATABASE command to be generated when using @SingleUser and a WITH MOVE parameter....
2020-11-23
46 reads
Blog Posts
Azure SQL Database and Memory
There are many factors to consider when you are thinking about the move to Azure SQL Database (PaaS) – this could be single databases (provisioned compute or serverless) to...
2020-11-22
139 reads
How to fix replication issue cannot truncate table
I have the privilege to work on Saturday and Sunday, holding a pager during my shift hours. I get most of the blog ideas during this stint. Today’s post...
2020-11-21
11 reads
Kubernetes Precon at DPS
Pre-conference Workshop at Data Platform Virtual Summit 2020 I’m proud to announce that I will be be presenting pre-conference workshop at Data Platform Virtual Summit 2020 split into Two...
2020-11-21
33 reads
Kubernetes Precon at DPS
Pre-conference Workshop at Data Platform Virtual Summit 2020
I’m proud to announce that I will be be presenting pre-conference workshop at Data Platform Virtual Summit 2020 split into Two...
2020-11-21
4 reads
Notes on the PASS 2020 Virtual Summit – Conclusions
I waited a week to write this, letting the experience settle some. Looking back, it wasn’t a terrible experience. Content was findable and as far as I could tell...
2020-11-21
19 reads
Consider the Benefits of Powershell for Developer Workflows
Who Am I Talking To
You use bash or python.
PowerShell seems wordy, extra verbose, and annoying.
It’s a windows thing, you say… why would I even look at it.
Pry bash out...
2020-11-20 (first published: 2020-11-04)
433 reads
Daily Coping 20 Nov 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-11-20
14 reads
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
117 reads
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
7 reads
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
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
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