Data Saturday #8–Southwest US
I am very excited to announce that I will be speaking for Data Saturday #8 – Southwest US, coming up on Saturday, May 15, 2021. I will be delivering...
2021-05-08
17 reads
Data Weekender v3.1
I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021. This will be the third time I have been selected to...
2021-05-08
27 reads
Azure SQL database security
In Azure database, security is managed through multiple-layers such as network layer, server layer and database layer. A secure blue print in deploying Azure SQL(more...)
2021-05-08
23 reads
Azure SQL database SKU selection
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
135 reads
Thanks Kathi and Mala
I have to thank Kathi and Mala for putting on the WIT Mental Health and Wellness today today. I was honored to present, but I was more glad that...
2021-05-08
22 reads
Understanding NUMA in SQL Server VMs
Last Updated on January 8, 2022 by John Morehouse What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows...
2021-05-07
352 reads
Goal Progress for April 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-05-07
13 reads
Daily Coping 7 May 2021
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...
2021-05-07
29 reads
A notebook, a guideline, and a workshop
I've come to the conclusion that most of us need to hear this: You cannot do Bullet Journaling wrong; your journal is a tool that's there for you, not...
2021-05-06
22 reads
A notebook, a guideline, and a workshop
I've come to the conclusion that most of us need to hear this: You cannot do Bullet Journaling wrong; your journal is a tool that's there for you, not...
2021-05-06
39 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