A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
Business Intelligence in Collaborative Planning, Forecasting and Replenishment
This article describes the use of BI in Collaborative Planning, Forecasting and Replenishment
Top Tips for Effective Database Maintenance
Far too often, people who are not trained database administrators somehow end up responsible for a database. They lack the proper training and knowledge to maintain their database, and problems begin to develop. Here’s a primer for all those involuntary DBAs who need a crash course in database maintenance best practices.
Attaching Databases - SQL School Video
Learn how you can add a new database to your instance if you receive the MDF and LDF files from another source. MVP Brian Knight covers this very useful technique that is used for moving databases to new instances, servers, or even recovering from an disaster.
Building a Security Philosophy
SQL Server trainer and expert DBA, Andy Warren, thinks that everyone should have a philosophy about security. He starts this installment in looking about how to assign administrative privileges.
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
A Strategy to Determine the Size and Cost of Database-Centric Business Information Systems
This paper presents an approach to the definition of function points within database-centric business information systems, the process of counting function points, .
Index Metadata and Statistics Update Date for SQL Server
Statistics update date is stored as metadata on the SQL instance, but after a great deal of research against the system tables and DMVs I realized that this information is not readily exposed to the DBA via any other method than the STATS_DATE() function or the SQL Server Management Studio graphical user interface (GUI).
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers