Working Around 2005 Maintenance Plans
SQL Server 2005 has dramatically changed the way many maintenance plans are used. New author Aaron Ingold brings us an introductory look at Maintenance Plans in this new version.
SQL Server 2005 DB Snapshot: Imperfect Yet Useful?
SQL Server 2005 offers a new tool, Database Snapshot, which helps protect against user errors. It's a great feature, in some ways. But Ravindra Okade cautions against relying on it as an all-purpose rescue device.
The Detroit Area SQL Server Special Interest Group
The user group in Detroit is back and looking for new members. If you are in the area, check out the announcement for their next meeting.
The SQL Site Map Provider You've Been Waiting For
SqlSiteMapProvider reads site maps from SQL Server databases. And it takes advantage of the ASP.NET 2.0 provider architecture to integrate seamlessly with the site navigation subsystem. Just create the site map database and register SqlSiteMapProvider as the default provider, and then, like magic, everything else just works.
The Pitfalls of Foreign Keys
What is the cost of DRI and is it something that you should implement? SQL Server expert David Poole takes a look at the impact of adding DRI to a CMS system and provides some real world results on which you can base your decision.
Case Study of Building a Data Warehouse with Analysis Services (Part T
In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse.
Printing in .NET
A bit of a break from the SQL Server side with this great new .NET class developed by new author Jereme Guenther. He prints a page character by character to handle control of formatting. Take a look and see if this solves any of your .NET printing problems.
Case Study of Building a Data Warehouse with Analysis Services (Part O
In the first of a two-part series, Baya Pavliashvili, database administration expert, offers solutions to your business problem using a data warehouse.
The Zero to N Parameter Problem
T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.
Indexing Guide: The art and science of SQL Server indexing
You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don'ts, and tricks for working with the Index Tuning Wizard to improve overall system performance for SQL Server 2000 servers. This is particularly useful for servers that need a boost before they are upgraded to SQL Server 2005.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers