Robert Vallee has announced that he will release the source code to SQL Insider early to September 15th. On that date, members will be able to download the source code and make modifications to the program.
Give this test to your boss...only if he has a sense of humor!
Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here's an overview of what a DBA does. Reader feedback will be used to update this article over time.
Are you thinking of becoming a master DBA? If so, find out how you can in this article.
Want to learn more about some of your favorite authors. Check out this interview with Louis Davidson, author of Professional SQL Server 2000 Database Design.
This article examines some of the common issues that may occur when installing SQL Server 7.0
A great deal of data in any RDBMS is hierarchial. This article presents a technique for aggregating this data.
Lumigent has updated their transaction log analysis tool to include a number of features that every DBA will find handy. Read this review of a great new product.
Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.
We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers