Quickly Moving Databases
This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.
Deployments and Tests in an iSCSI SAN
This paper describes the deployment and testing results of SQL Server 2005 using the Microsoft iSCSI Initiator with an EqualLogic iSCSI SAN. It helps you understand best practices and the benefits of using an iSCSI SAN with SQL Server 2005.
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
Learn performance impacts of the XML data type and VARCHAR (MAX) data type in SQL Server 2005. Here are storage, I/O and CPU results of XML in SQL Server.
A Review of PDF-eXPLODE
Reporting is a huge part of any DBA's job with constant changes and new requests for data that non-technical people can use. And more
and more often the format of choice is PDF, which ensures the end result looks the same on many different platforms. Kathi Kellenberger takes a look at a product that can allow end-users to generate PDFs from a database and easily send them to other people.
Init From Backup
Replication can be confusing to many new SQL Server DBAs and some of the optmizations are not well described in Books Online. SQL Server replication expert and trainer Andy Warren brings us a technique for initializing replication without a snapshot.
Building Custom Reporting Services Reports for SQL Server Management Studio
Learn how to build Custom Reports, without installing Reporting Services, using a new feature found in Microsoft Service Pack 2 (SP2) for SQL Server 2005.
The Burden of Proof - iPod
Steve Jones asks about the disclosure of source code in legal proceedings.
The Burden of Proof - MP3
Steve Jones asks about the disclosure of source code in legal proceedings.
The Burden of Proof - WMV
Steve Jones asks about the disclosure of source code in legal proceedings.
Blogs
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
SQL Database Administration: Not For Everyone (But Maybe It’s for You)
Let's get one thing straight: database administration isn't the most glamorous tech job out...
Forums
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Create Copy of DB in same server.
Hi I want to create a copy of a DB on the same server....
Question of the Day
Restoring the Resource Database
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers