Daily Coping 9 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-09
13 reads
Blog Posts
Data Mesh: Centralized ownership vs decentralized ownership
I have done a ton of research lately on Data Mesh (see the excellent Building a successful Data Mesh – More than just a technology initiative for more details),...
2021-08-09 (first published: 2021-07-23)
368 reads
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
810 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
91 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
4 reads
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define...
2021-08-06 (first published: 2021-07-25)
1,025 reads
Daily Coping 6 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-06
17 reads
Using Aggregates in Calculations with Other Columns Functions–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In the last post on Window functions, I...
2021-08-06 (first published: 2021-07-21)
929 reads
Daily Coping 5 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-05
17 reads
Accessibility is not just about slides
Although I don’t write about it much on this website, I am on the autism spectrum, and I have ADHD. I need to sit at the front of a...
2021-08-04
19 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
ActualExecute
IT's OK I've create a stored procedure ActualExecute which is the TSQL script equivalet...
BCA KCU RAWAMANGUN Tlpn:CS.0853•5504•2311
BCA KCU RAWAMANGUN Tlpn:CS.0853•5504•2311 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
PT Central Santosa Finance. Tlp/wa:08218168235
Komplek Ruko Grand Mall, Jl. Sudirman (Kompeks Ruko Grand Mal, Jl. Jend. Sudirman Kompeks...
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