A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-09
3,352 reads
A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,022 reads
When is that Restore Going to Finish?
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
848 reads
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
963 reads
How Do I Spot Identity Columns That Are About to Max Out?
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
1,266 reads
Can Deadlocks be Resolved by Adding an Index?
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,376 reads
A Little Help with Azure Please
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
327 reads
What Did that Geek Just Say?
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is...
2010-09-21
325 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
6 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
4 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 Kertajaya No.Telp 083831617937
Whatsapp.083831617937 Jl. Kertajaya No.35, RT.001/RW.10, Manyar Sabrangan, Kec. Mulyorejo, Kota SBY, Jawa Timur Surabaya,...
BCA KCP Kenjeran No.Telp 083831617937
Whatsapp.083831617937 Jalan Kenjeran No.98, Simokerto, Tambakrejo, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Kapas Krampung No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapas Krampung 126-126A-B Surabaya, Jawa Timur, Indonesia 60133
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