Before you even begin building a SQL Server 2005 cluster, you must ensure that your network infrastructure is in place. Here's a checklist of everything that is required before you begin installing a SQL Server 2005 cluster.
2007-03-02
2,443 reads
If your organization is like many organizations, it may have some older version SQL Server clusters in production. If so, at some point you will have to make a choice about how to upgrade them to SQL Server 2005.
2007-03-01
1,739 reads
The depths of the storage engine must be some interesting places and we dive a little into them with our look at Santeri Voutilainen, one of the very talented SQL Server engineers who worked on the lock manager.
2007-02-28
2,508 reads
If you are near Rhode Island, there's a new user group available with SQL Server Guru Grant Fritchey presenting.
2007-02-28
1,149 reads
In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.
2007-02-28
3,723 reads
This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.
2007-02-27
5,180 reads
In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed.
2007-02-26
2,178 reads
All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.
2007-02-23
3,672 reads
While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable
with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.
2007-02-22
7,377 reads
XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.
2007-02-22
4,779 reads
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I am a bit stuck on how to write this query. Below...
Comments posted to this topic are about the item Powershell script to generate SQL...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers