Security Regulations
There have been calls for governmental security regulations for IT. Is that a good thing? Steve Jones comments today.
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
SQL Saturday #41 - Register and Call for Speakers
If you'll be near Atlanta on Apr 24, 2010, come to SQL Saturday #41. If you are at all interested in speaking, submit a session.
Professional Microsoft SQL Server 2008 Programming - Sample Chapter
Professional Microsoft SQL Server 2008 Programming Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical […]
Stop, Don't Panic
Your response in a crisis situation can be critical to how quickly you solve the issue. Steve Jones reminds you to stay calm in today's editorial.
T-SQL: Why “It Depends”
Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.
An overview of Master Data Services - MDS in SQL Server 2008 R2
With Master Data Services, IT organizations can centrally manage critical data assets companywide.
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
Beginning T-SQL 2008 - Book Review
A book review of a new T-SQL book for SQL Server 2008, written by longtime SQLServerCentral author and MVP, Kathi Kellenburger.
Database Documentation: Joining up the Dots
This week, a guest editorial from Phil Factor on how SQL Server database documentation falls woefully short of what is required and expected by most development teams.
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers