Getting Warmer - How to Implement Hot Failover in .NET 1.1 with SQL 20
What happens if you try to specify a Failover Partner in .NET 1.1?
Looping Through and Loading Files with SSIS
In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.
Building Automated Backups
Backups are the foundation of any well run database server, or even any computer system. Numerous articles have been written about SQL Server backups and new author Paulo Luis brings us a new twist on building automated backups using devices.
Career Paths for Programmers
The key to maintaining a good employment outlook in IT, it seems, is to move out of programming and up into more business-oriented IT positions such as systems analyst, business analyst, project manager, or systems architect. However, a computer programmer can't just decide to become a systems analyst or project manager overnight.
Clustering SQL Server 2005
With Windows 2003 now clustered, you're ready to begin to clustering SQL Server 2005. In this presentation, you'll see how to cluster SQL Server 2005 and some best practices in how to configure the SQL Server cluster after the fact.
SSIS At Christmas
Due to overwhelming demand, we've opened up another Integration Services class. Start Christmas vacation early in Orlando on Dec 18.
The Report Builder
Andy Warren brings us an introduction the the Report Builder in SQL Server 2005. It's the less often used tool for developing and customizing reports that you can give to end users and lower the number of requests your developers receive.
SQL Server 2005 Integration Services - Performance - Part 30
The superiority of SSIS over DTS goes beyond functionality alone, providing numerous efficiency benefits, which we will present in more detail in this article.
Monitoring Drive and Database Free Space
SQL Server will autogrow your databases as they run out of space. But the process doesn't manage space, nor does it check the free space on the drive. Allowing autogrow to grow unchecked and unmanaged will eventually use up all the free disk space and potentially crash your server. New author Mark Nash brings you his system for monitoring space usage and generating a report that eases this process.
Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert
SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers