Backup Encryption Performance
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-06-05 (first published: 2023-05-22)
266 reads
Blog Posts
SSAS Tabular: “SortByColumn property set to invalid column ID”
Recently I was doing a cleanup of one model, and I used Best Practice Analyzer (BPA) in Tabular Editor as a helper. Later, I realized I forgot to set...
2023-06-05 (first published: 2023-05-22)
444 reads
A New Word: Jouska
jouska – a hypothetical conversation that you compulsively play out in your head – a crisp analysis, a devastating comeback, a cathartic heart-to-heart – which serves as a kind...
2023-06-02
937 reads
PGSQL Phriday #009: On Rollback
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty simple, database change management. Now, I may have, once or twice, spoken about database change...
2023-06-02
26 reads
Restore One Backup From Many in a Device–#SQLNewBlogger
I wrote recently about finding multiple backups in a file. This post looks at how to restore one of those. The one you choose. Another post for me that...
2023-06-02 (first published: 2023-05-17)
214 reads
Running SQL Server in a container with sqlcmd
One of the options that I completely missed with the new go-sqlcmd CLI tool is the ability to spin up a container running SQL Server. Let’s have a look...
2023-06-02 (first published: 2023-05-19)
502 reads
Summit Launch Pricing Ends June 7
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023. It’s in person only, and if you can come, you should register today. Launch pricing...
2023-06-01
36 reads
Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a bit behind this week. I will do better next week!As you may have heard last...
2023-06-01
53 reads
Using Docker on Windows with Persistent SQL Server Settings and Databases
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases...
2023-05-31 (first published: 2023-05-15)
489 reads
Why you still need DBA resource in the cloud
Why a DBA, rather then being redundant, is even more valuable when your databases run in the cloud.
2023-05-31 (first published: 2023-05-19)
434 reads
Blogs
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...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
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