Daily Coping 21 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-21
18 reads
Blog Posts
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite a bit in my day to day work recently and I’ve started to realise that...
2021-05-21 (first published: 2021-05-17)
454 reads
SQL Server Collations: What does “CP1” mean in “SQL_Latin1_General_CP1_CI_AS”?
(last updated: 2021-05-31 @ 19:00 EST / 2021-05-31 @ 23:00 UTC ) Many of us that work with Microsoft SQL Server, especially those of us working on systems with...
2021-05-21
198 reads
Daily Coping 20 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-20
13 reads
Testing for Specific Versions of TLS Protocols Using curl
Ever need to set your web server a specific protocol version of TLS for web servers and need a quick way to test that out to confirm? Let’s check...
2021-05-20
211 reads
Daily Coping 19 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-19
16 reads
Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)
This past week I had a great Client ask an even greater question, and it got me thinking. The question is straightforward (albeit nerdy, which I love). “We’ve enabled...
2021-05-19 (first published: 2021-05-10)
907 reads
GroupBy is Back – Spring 2021 Edition
GroupBy Conference is coming back May 25-26 for it’s Spring 2021 Edition. There will be 20+ FREE data sessions spread across the two days. Sessions for Americas’ time zones...
2021-05-19
22 reads
GroupBy is Back – Spring 2021 Edition
GroupBy Conference is coming back May 25-26 for it’s Spring 2021 Edition. There will be 20+ FREE data sessions spread across the two days. Sessions for Americas’ time zones...
2021-05-19
128 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-19 (first published: 2021-05-10)
541 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers