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)
181 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
69 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
26 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
37 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)
247 reads
Tackling security vulnerability at an early stage in SDLC
As a Software Engineer, I will like to detect security vulnerabilities early enough in my codebase before committing my code.
Detecting security vulnerability is very important in SDLC (Software Development Life...
2021-08-24
18 reads
Daily Coping 24 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-24
28 reads
Error: Cannot continue the execution because the session is in the kill state.
This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to ... Continue reading
2021-08-24
180 reads
The Power of User Groups
Fascination has always been with me when thinking of developing local talent. It has helped me immensely in my career both as an attendee, presenter, chapter leader, and more....
2021-08-23
93 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