Quickly Determining Azure SQL Database Size
Recently I needed to determine how much storage space each database on a logical server was consuming. I was doing some DR testing and I need to give the...
2021-07-02
100 reads
Daily Coping 2 Jul 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-07-02
28 reads
MVP for Another Year 2021-2022
A few minutes ago, I received an email from Microsoft presenting me with the 2021-2022 Microsoft Most Valuable Professional (MVP) award. This is my 8th award and I am...
2021-07-01
34 reads
I Still Can’t Believe It!
I received my MVP award letter from Microsoft today. This will make the fourth time I’ve been awarded and I still can’t believe it. I just wanted to help...
2021-07-01
32 reads
Daily Coping 1 Jul 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-07-01
28 reads
SQL Homework – July 2021 – Log shipping
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy ... Continue reading
2021-07-01
47 reads
Setup Full-Text using T-SQL–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wrote a previous post on how to...
2021-06-30
133 reads
Using Readable Secondary in Azure SQLDB
When using a Geo Replicated Azure SQL Database Readable Secondary there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed:...
2021-06-30
18 reads
Using Readable Secondary in Azure SQLDB
When using a Geo Replicated Azure SQL Database Readable Secondary there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed:...
2021-07-12 (first published: 2021-06-30)
285 reads
Data Mesh: Centralized vs decentralized data architecture
One of the biggest differences between the Data Mesh and other data platform architectures is a data mesh is a highly decentralized distributed data architecture as opposed to a...
2021-06-30
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