Certification Rumors and Tips
Should you get certified? How should you do it? Brandie Tarvin brings us some tips on what might work and dispels some of the myths and rumors about certification.
SQL Server 2000 SP3a Support is Ending
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
Debugging Stored Procedures in Visual Studio 2005
This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.
Maintain DTS packages in SQL Server 2005
Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.
Monitoring Changes to your Database Schema
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
Optimize disk configuration in SQL Server
Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance.
The SQLServerCentral.com 3000
Congratulations to two new members of the SQLServerCentral.com 3000 club: Jeff Moden and Noeld.
Data is at the Heart of Enterprise-Wide BI and DW
At the core of an enterprise BI/DW program is the data that is being made available to the business users who are looking to make better decisions using this information. Properly managing this information is the most critical activity of the enterprise BI team.
Dynamic Data Warehousing - The Virtual Brand Reaches Take-Off Speed
The interest in dynamic data warehousing (DDW) is growing significantly. A sure sign that the virtual brand has reached take-off speed is claims by bloggers that they did not get enough credit for coining the concept, viral brand or idea. For example, Dan Linstedt recently went on what he described as a "rant" about "dynamic data warehousing."
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers