What is a good Disaster Recovery Plan?
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
154 reads
Blog Posts
What is the system_health extended events session?
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...
2017-07-19 (first published: 2017-07-05)
2,101 reads
Celebrate! Second Anniversay Giveaway (is now over)
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
331 reads
Here's a Quick Way To Generate a Running Total in SQL Server
Watch this week's video on YouTube
Historically it's been difficult to accomplish certain tasks in SQL Server.
Probably the most annoying problem I had to do regularly before SQL Server 2012...
2017-07-18
27 reads
Off Topic: Dream Car Garage: 6 Cars, $250k
I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I...
2017-07-18
251 reads
Power BI Custom Visuals Class (Module 59 – Drilldown Cartogram)
In this module you will learn how to use the Drilldown Cartogram Custom Visual. The Drilldown Cartogram is a map...
2017-07-18 (first published: 2017-07-11)
2,015 reads
There’s no substitute for mentoring
There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely...
2017-07-18
348 reads
Thoughts on the State of Data Management
I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share...
2017-07-18
299 reads
Using Get-SQLDiagFix to get information from the SQL Server Diagnostic API with PowerShell
The SQL Server Diagnostics Preview was announced just over a week ago It includes an add-on for SQL Server Management...
2017-07-18 (first published: 2017-07-04)
1,499 reads
I Love Entity Framework
I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling...
2017-07-17 (first published: 2017-07-05)
2,777 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