Responsible Log Growth with dbatools
I love dbatools, and I’ve been trying to explore the various cmdlets over time, both to practice my PoSh and...
2017-09-08 (first published: 2017-08-25)
1,769 reads
Blog Posts
“Invalid class [0x80041010]” error when trying to access SQLServer’s WMI classes
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have...
2017-09-07
1,413 reads
'Invalid class [0x80041010]' error when trying to access SQLServer's WMI classes
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm...
2017-09-07
40 reads
Q&A Session with SQL Server on VMware Experts at VMworld EMEA
Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask...
2017-09-07
369 reads
Q&A Session with SQL Server on VMware Experts at VMworld EMEA
Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask...
2017-09-07
161 reads
SQL Saturday Minnesota Preconference Training Session
This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the...
2017-09-07
404 reads
SQL Saturday Minnesota Preconference Training Session
This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the...
2017-09-07
156 reads
The Transient Database Snapshot Has Been Marked Suspect
Yet another tale from the ticket queue...
The DBCC CheckDB was failing on INSTANCE99 and after some investigation it looked like...
2017-09-07 (first published: 2017-08-24)
4,350 reads
There EXISTS a place where SELECT 1/0 doesn’t return an error.
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical...
2017-09-07
661 reads
VLFs the Forgotten Foe
How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
Working as a consultant now,...
2017-09-07 (first published: 2017-08-23)
2,045 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