Bring Your Own Key to Azure SQL Database TDE
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store...
2018-04-30 (first published: 2018-04-19)
2,112 reads
Power BI Custom Visuals Class (Module 99 – Drill-Down Donut Chart
In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to...
2018-05-01 (first published: 2018-04-19)
3,519 reads
Finding Untrusted Foreign Keys and Constraints
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the...
2018-04-30 (first published: 2018-04-19)
3,163 reads
Script to review replications
This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged for...
2018-04-18
35 reads
Python Jupyter Notebooks in Azure
There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I...
2018-04-27 (first published: 2018-04-18)
3,316 reads
Why Don't I have a Preferred Replica?
The client reported that the log file on their main database was growing unusually large, and when they checked the...
2018-04-27 (first published: 2018-04-18)
4,138 reads
Dates and Times in SQL Server: the science of time redux
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
2018-04-18
491 reads
SSMS: Batch Separator (Day 35)
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
2018-04-18
2,099 reads
Script to review replications
This script is from my library and I use it to review what is going on with my transactional replications,...
2018-04-18
440 reads
An Open Letter to PASS and John Q Martin
Dear Mr. Martin and the PASS Organization,
In the spirit of advocating for change in a public way, I’m writing this...
2018-04-18
1,143 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers