SQL Server Archive and Data Retention Considerations
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
Hiring for Culture
Steve Jones discusses the decision to hire someone that fits in with your culture at work, and what that means.
Stairway to SQL Server Security Level 10: Row-Level Security
Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level security. This stairway level explores why you might want to use such a low-level granularity of data access security and how you can implement row-level security.
Demystifying Oracle's Clustering Factor
One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.
Visualizing in Space
An amazing visualization of basketball players has Steve Jones encouraging you to find your own pet project and showcase some skills.
The Importance of Maintenance on MSDB
MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.
Learning Backup to Azure
References and links to get you started in backing up your database to the Azure blob storage.
No Downtime Deployments
Can you deploy your database changes without any downtime? Steve Jones has a few notes.
What We Want and What We'll Pay For
The challenges of getting enough resources for our projects aren't always apparent.
Can Code Review Be Automated?
Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.
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 Dewi Sartika Tlpn/wa:085373737551
Jl. Dewi Sartika No.15, Sayang, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43213
BCA Finance Bekasi Layanan Mobil Telpon/WA:085188120691
BCA Finance Bekasi Layanan Mobil Telpon/WA:085188120691 KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard...
BCA KCP Ketapang Telpon/WA:08137887595
BCA KCP Ketapang Telpon/WA:08137887595.Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, Krukut, Kec. Taman...
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