I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
639 reads
Over the last year, at work and after work, I’ve been teaching myself a lot of brand new technologies. As such, I’m reliant on others to have put together...
2023-01-30
21 reads
In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up...
2023-01-31 (first published: 2023-01-30)
34 reads
Today’s coping tip is to plan something fun and invite others to join you. The fun thing is actually skiing today. My wife and I wanted to get some...
2023-01-30
16 reads
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to make sure we are prepared for the scenario where something goes wrong. For instance, if...
2023-01-30
27 reads
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend and colleague Ben E. Weissman, is now available on Pluralsight here! If you want to...
2023-01-28
28 reads
I am very excited and lucky to be speaking once again at SQLBits along with my DCAC colleagues. SQLBits, the largest Data Platform conference in Europe, held this year...
2023-01-27
73 reads
Today’s coping tip is to try something new to get out of your comfort zone. I did two things here. First, I’ve been participating in a Jan American Cancer...
2023-01-27
17 reads
Monitoring for Problems The encryption of your existing data occurs as a background process referred to as the encryption scan, but it will consume resources while it runs, so...
2023-01-27
197 reads
Today’s coping tip is to focus on what’s good, even if today feels tough. Yesterday was a tough day. I got busy, distracted, had some bad news come up,...
2023-01-26
17 reads
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...