How Stale Are My Statistics?
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
Retrieving SQL Server Permissions for Disaster Recovery
I'm needing to audit the permissions in my databases, but I want to script them out so I have something to run in case of a recovery situation. I've got the logins, roles, and users handled, but it's the permissions that I want to extract. How can I do this easily?
An Example of Test-Driven Development, Part 2
In this next installment of his series on TDD, MVP Andy Leonard continues the development of his database.
Enterprise Management
This Friday Steve Jones asks the question about how you manage large numbers of SQL Server instances.
Under the ORM Hood: Revealing the SQL
Your application code may look neat and clean, and you are using a sound Object-relational Mapper, but when you put the pedal to the metal, you're not getting the performance. The time has come to lift the hood and see what SQL is being generated by the ORM, and what part of your code is causing the bottlenecks. The effect can be spectacular.
One Time Passwords
Facebook has implemented a new security feature that Steve Jones thinks might work well for SQL Server as well.
Hierarchical Data Structure Virtualization in SQL
Data structure virtualization is the constructing of a data structure utilizing pieces or fragments from other data structures. This article demonstrates how Data structure virtualization can be performed in ANSI SQL utilizing hierarchical processing techniques to produce hierarchically structured virtualized output.
Swarms
Steve Jones talks about the workplace of the future, and a prediction from the Gartner Group that it will include swarms.
Writing Nearly Codeless Apps: Part 5
In this next installment of the series on writing codeless applications, David Ziffer looks at the querying of data from the database.
November Question: What steps do you include in your database maintenance?
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
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 Balai Pustaka Tlpn/wa:085373737551
Jl. Balai Pustaka Timur, Blok J No. 225, C, RT.4/RW.3, Wil, Kec. Pulo Gadung,...
Pt BCAFinance Bontang,Telp/Wa 0821.3111.159
Jl. R. Suprapto No.81, Api-Api, Kec. Bontang Utara, Kota Bontang, Kalimantan Timur 75313
BCA Multifinance,Telp/Wa 0821.3111.159
5X88+8MH, Sampit, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78811
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