Brad McGehee On Being a Better DBA!
Brad McGehee discusses the career path of a professional database administrator. Often the DBA role is thrust upon an IT professional or developer without much in the way of specific training. Growing into the role is largely a self-motivated exercise. Brad talks about the habits that successful DBAs have, focused on on-going education and working to protect their organizations data.
Calculate Percentiles with SQL Server 2005
Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.
Incommunicado
Communication is important, and it's a real problem when people can't reach you. Read about an interesting phone accident the some hints for better communication.
TSQL Lab I - Playing around with ROW_NUMBER
Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
Populating Dimension Tables with the SCD Task
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.
Snapshot Reports I: Report Manager Perspective
BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.
Data Breaches
Security is hard, but are we doing a good job? Steve Jones shares a few thoughts on our security development practices
Trigger Trivia
From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.
SQL Server Management Objects: Lessons from the Wild
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers