Daily Coping 27 Aug 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-08-27
22 reads
The sysname datatype defaults to not NULL.
The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for ... Continue reading
2021-09-10 (first published: 2021-08-26)
198 reads
Single-cloud versus Multi-cloud
A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three...
2021-08-26
14 reads
Single-cloud versus Multi-cloud
A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three...
2021-09-13 (first published: 2021-08-26)
352 reads
Daily Coping 26 Aug 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-08-26
24 reads
AWS BYOC – Bring your own SQL Server cluster with AWS EC2 and SIOS
Originally posted on DataSteve: Introduction They are multiple options to implement HADR solution for SQL Server in AWS public cloud. The easiest way to do that is to use...
2021-09-10 (first published: 2021-08-25)
168 reads
Think twice about storing JSON in your SQL Server database
During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10...
2021-08-25
66 reads
Daily Coping 25 Aug 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-08-25
25 reads
Timeseries Analytics Capabilities, and Azure Data Explorer (ADX)
I've had a few recent conversations where customers/partners were encountering scale concerns in existing timeseries database applications hosted outside of Azure, and wished to explore the native services in...
2021-08-24
29 reads
Timeseries Analytics Capabilities, and Azure Data Explorer (ADX)
I've had a few recent conversations where customers/partners were encountering scale concerns in existing timeseries database applications hosted outside of Azure, and wished to explore the native services in...
2021-09-08 (first published: 2021-08-24)
239 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers