Setting Defaults for New SQL Compare Projects
Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set...
2020-12-23 (first published: 2020-12-14)
181 reads
Blog Posts
Daily Coping 22 Dec 2020
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...
2020-12-22
39 reads
ETL Antipattern: Ignoring the “Why?”
In this final post in my ETL Antipatterns series, I’ll talk about a common big-picture mistake when building ETL processes: ignoring the fundamental question, “why are we doing this?”...
2020-12-22
8 reads
ETL Antipattern: Ignoring the “Why?”
In this final post in my ETL Antipatterns series, I’ll talk about a common big-picture mistake when building ETL processes: ignoring the fundamental question, “why are we doing this?”...
2020-12-22
15 reads
Find columns with NULL values across the table
Recently, I was working on one of the performance tuning assignment with an esteemed client. The size of their databases were growing tremendously. Growth in the database size is...
2020-12-22 (first published: 2020-12-11)
623 reads
Getting Started Reading Execution Plans: Highest Cost Operator
Reading execution plans in SQL Server is just hard. There’s a lot to learn and understand. I previously outlined the basics I use to get started when I’m looking...
2020-12-22 (first published: 2020-12-14)
663 reads
Top 3 Upgrade & Migration Mistakes
This is a guest post by another friend of Dallas DBAs – Brendan Mason (L|T) Upgrading and migrating databases can be a daunting exercise if it’s not something you...
2020-12-22
48 reads
Daily Coping 21 Dec 2020
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...
2020-12-21
41 reads
ETL Antipattern: Ignore the Logging
In my last ETL Antipatterns post, I wrote about the unexciting but very necessary work of documenting ETL processes. The logging of ETL operations is just as (un)captivating as...
2020-12-21
6 reads
ETL Antipattern: Ignore the Logging
In my last ETL Antipatterns post, I wrote about the unexciting but very necessary work of documenting ETL processes. The logging of ETL operations is just as (un)captivating as...
2020-12-21
26 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
Alamat BCA KCU TARAKAN Telp/WA:0817629933
Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan, Kalimantan Utara...
BCA KCU DAAN MOGOT Telpon/WA:087768193341
BCA KCU DAAN MOGOT Telpon/WA:087768193341.Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota...
BCA KCP Kas Limpung. Tlpn/wa:082372744391
Jl. Sawah No.Blok 16, Bedungan, Sempu, Kec. Limpung, Kabupaten Batang, Jawa Tengah 51271
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