Daily Coping 14 Sep 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-09-14
33 reads
Blog Posts
Persist Sample Percent in SQL Server IS Fixed!
Hi Everyone, this is John Sterrett. I am a SQL Server Consultant in Austin, TX. Last year I blogged about a feature called Persist Sample Percent. It had a...
2021-09-14
15 reads
Updated Pluralsight Course – Managing Kubernetes Controllers and Deployments
My updated course “Managing Kubernetes Controllers and Deployments” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2021-09-14
11 reads
Daily Coping 13 Sep 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-09-13
16 reads
Divide the rows of a column in equals batches in grid format
I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...
2021-09-13 (first published: 2021-08-28)
519 reads
Rewriting The Query Tuning Book
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
36 reads
Rewriting The Query Tuning Book
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
4 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)
348 reads
Matillion: strategic to modern at Connect for Health Colorado
As part of its ‘All Cloud’ push that began to take shape in 2019, Connect for Health Colorado (C4) selected Matillion ETL to be its cloud ETL/ELT tool. At...
2021-09-12
7 reads
Setting Trace Flags and Configuring SQL Server Containers
In this blog post, we will walk through a few examples of how to configure SQL Server in Docker Containers. First, we will configure a container at runtime by...
2021-09-12
159 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Sumatera Tlpn/wa:085373737551
Jl. Aiptu K.S. Tubun No.46, Pandau Hulu I, Kec. Medan Kota, Kota Medan, Sumatera...
BCA KCP Pusat Pasar Tlpn/wa:085373737551
Medan Mall, Kompleks No.10, Pusat Ps., Kec. Medan Kota, Kota Medan, Sumatera Utara 20212
BCA KCP Pulau Brayan Tlpn/wa:085373737551
Jl. KL. Yos Sudarso No.223 J, Pulo Brayan Kota, Kec. Medan Bar., Kota Medan,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers