Daily Coping 18 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-18
17 reads
Blog Posts
Finding Failed Job Steps
Kendra’s query was a good starting point, and I used most of it in the first CTE shown below. This query basically looks at msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity, joining them...
2021-08-18
380 reads
Scaling down in the cloud
I may be completely off base here, but I’ve noticed a correlation between folks who use Amazon Web Services and their understanding that once you scale up a service...
2021-08-18
98 reads
SQL Homework – August 2021 – Security Standards
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you ... Continue reading
2021-08-18 (first published: 2021-08-03)
313 reads
Updating SQL Server container memory limits on the fly
When running multiple SQL Server containers on a Docker host we should always be setting CPU and Memory limits for each container (see the flags for memory and cpus...
2021-08-18 (first published: 2021-08-06)
325 reads
For #JohnsDad
Last week, on Wednesday August 11, 2021 at approximately 3:45PM Eastern, my Father left this world. Much too early. Covid took my Father from me, my family, and his...
2021-08-17
17 reads
Pure Storage Links
SQL Server Pure Storage SQL Server Platform Guides Pure Storage SQL Server Best Practices Pure Storage SQL Server Scripts on GitHub Pure Storage ActiveCluster with SQL Server Azure...
2021-08-17
33 reads
Become a Beginner at Data Science with the WIT
I’m a beginner in data science. I know a lot of general things about the field, but I’m really a beginner in most ways. This Friday, 20 Aug 2021,...
2021-08-16
26 reads
Daily Coping 16 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-16
17 reads
Data Modeling at your fingertips
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema is better than a database model communicated by a multitude of data scripting text objects.
Someone...
2021-08-16 (first published: 2021-07-31)
965 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 Sahid J-Walk No.Telp:087757645171
Whatsapp:087757645171 Jl. Babarsari No.2, Janti, Caturtunggal, Kec. Depok, Kabupaten Sleman, Daerah Istimewa Yogyakarta 55285
BCA KCP Kramat Jati Tlp (+62 821°3111°179
Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah Khusus...
BCA KCP Bantul Telp:cs.08218171955
Whatsapp:08218171955 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
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