You can’t use GO in dynamic SQL.
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-10
15 reads
Blog Posts
Batch, Streaming, and Relational Data
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-09 (first published: 2022-02-03)
382 reads
BlitzBlockingChain, Getting Blocking Chains from sp_BlitzWho
I’m going to assume that most people will have at least heard of Brent Ozar’s brilliant First Responder Kit. If you haven’t then you’ve been missing out on some...
2022-02-09
110 reads
Daily Coping 9 Feb 2022
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...
2022-02-09
9 reads
Database Projects 101 in Azure Data Studio (Calgary Data User Group)
On Wednesday February 23rd, 2022, the Calgary Data User Group will be hosting our first user group session of the year, featuring Warwick Rudd. The topic is an introduction...
2022-02-09
21 reads
SQL Server, PostgreSQL and the Future
This is just a quick note to talk about the future, mine, yours and this blog. First, I’m not abandoning SQL Server. I’m actively working on a revision of...
2022-02-09
48 reads
SSAS getting message: “Unable to convert one or multiple M partitions into native source queries.”
The Issue Recently one of our team members faced the following issue: We have SSAS Tabular model deployed in DirectQuery mode taking data from MSSQL server database. Suddenly SSAS...
2022-02-09 (first published: 2022-02-01)
638 reads
Thrilled to #BITS!
2021 was a strange year…mid way through a pandemic, enormously depressing on many fronts to me..and yet, it bought with it some unexpected joys. I never imagined, in the...
2022-02-09
17 reads
Who do you contact before an upgrade? : T-SQL Tuesday #147
I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent ... Continue reading
2022-02-09
7 reads
Boost Your Career with #SQLNewBlogger
A few years ago Ed Leighton-Dick started the #SQLNewBlogger challenge. He asked people to start writing about their career and building their own brand. I thought it was a...
2022-02-08
14 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