I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.
Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.
These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.
Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.
Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema.
This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.
A recap of the world of energy from the previous two months. Steve looks at solar, wind, nuclear, and more.
After completing a project with SQL Server 2005 Integration Services, author G Vijayakumar brings us his technique for an automated scheduling of various source data into a data warehouse with multiple packages.
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Do you know if your SQL Server is really running at its best? To...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers