In a previous blog entry, I talked about the new FILESTREAM data capability in SQL Server 2008 where we can store Binary Large Object (BLOB) data on the file system but have it transactionally part of ...

We have Database Mirroring set up (SQL 2005), but what is the proper way to mirror SQL Agent Jobs? We have quite a few custom jobs. Is it just manually scripting out the jobs from the Principle and ...

Without using any special hardware, it allows you to duplicate (real time mirroring) a production database on another SQL Server at a different location. In addition, if the first server should become ...

Microsoft has released an update to its SQL Server 2005 that adds a handful of new features to the database software. The company on Wednesday said Service Pack 1 for SQL Server 2005 includes new ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...