Toward Integrity Part 4
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
Creative Ways to Use the TOP Clause
Gregory Larsen discusses how to use the TOP clause to help solve requests where you want to restrict the number of records returned based on a record count.
CTEs and Trees
Some new interresting points about trees and CTE in SQL Server : transforming a tree from auto reference to interval model (nested sets), calculating levels in interval model, creating a view of auto ref from an interval model, hierarchical numbering of items, and more. This article includes more examples based on his previous work.
SQL Stored Procedure to Log Updates, Independent of Database Structure
How many DBAs need a solution to track those changes made for multiple systems? Auditing is becoming more and more prevalent in all systems and having a good solution can really make your DBA job interesting. New author Keren Ramot brings us his technique that works indepedent of the database structure.
The December Energy Update
Steve Jones takes a look at what's happening in the world of alternative energy, including cleaner nuclear power and energy from motion.
Kimball University: Handling Arbitrary Restatements of History
How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.
Optimize T-SQL data types in SQL Server
To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.
Automated Monitoring Database Size Using sp_spaceused
Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that.
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 Klender Tlpn/wa:085373737551
Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota Jakarta...
BCA KCP Santa Telp/Wa:08218200174
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
BCA KCP Pondok Gede Tlpn/wa:085373737551
Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota Jakarta Timur, Daerah...
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