Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
374 reads
Blog Posts
Interview with Guy In A Cube’s Adam Saxton and Patrick Leblanc
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...
2017-12-20
357 reads
Making a Difference: Andy Warren
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
346 reads
Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
960 reads
My Second Pester Test
I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I...
2017-12-20 (first published: 2017-12-07)
2,110 reads
Our SQL Server 2017 Administration Inside Out fun author survey
I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by...
2017-12-20
801 reads
UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.
From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...
2017-12-20 (first published: 2017-12-08)
1,477 reads
Westbound and down, roll ’em up and truckin’
A little less than 2 years ago, my wife and I loaded up our cats and dog and moved from...
2017-12-20
417 reads
A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
576 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
397 reads
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers