http://www.sqlmag.com/authors/author/author/5738030/rss/5738030en-USFri, 25 May 2012 08:24:09 GMTFri, 25 May 2012 08:24:09 GMThttp://www.sqlmag.com/article/database-administration/intelligent-backups-revisited
By David Paul Giroux
Previously, David Paul Giroux presented a solution for automating transaction log backups. Here are two more tools—a solution for automating differential backups and a script for restoring transaction logs—to add to your toolbox.]]>David Paul GirouxTue, 02 Nov 2010 10:20:00 GMThttp://www.sqlmag.com/article/database-administration/intelligent-backups-revisitedhttp://www.sqlmag.com/article/database-administration/intelligent-transaction-log-backups
By David Paul Giroux
Here’s a transaction log backup solution that uses two SQL Server Agent jobs. Once you set it up, you never have to modify it because it intelligently executes. No matter whether the database is a principal or mirror in Simple or Full Recovery mode, the solution identifies the database’s state and acts accordingly.]]>David Paul GirouxWed, 06 Oct 2010 00:01:00 GMThttp://www.sqlmag.com/article/database-administration/intelligent-transaction-log-backupshttp://www.sqlmag.com/article/tsql3/pusher-and-querypusher-pick-up-where-cms-leaves-off
By David Paul Giroux
With the Pusher and QueryPusher utilities, you can execute queries, create objects, and perform actions against a list of SQL Server machines without the need for SQL Server 2008’s Central Management Server (CMS).]]>David Paul GirouxWed, 25 Aug 2010 15:55:00 GMThttp://www.sqlmag.com/article/tsql3/pusher-and-querypusher-pick-up-where-cms-leaves-offhttp://www.sqlmag.com/article/tsql3/dbcc-checkdb-for-very-large-databases
By David Paul Giroux
Running DBCC can be problematic on VLDBs. Use the author’s Admin/Worker Job approach to ease the process.]]>David Paul GirouxThu, 19 Nov 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/dbcc-checkdb-for-very-large-databaseshttp://www.sqlmag.com/article/tsql3/utilities-assess-data-file-usage-and-provide-commands-so-you-can-do-something-about-it
By David Paul Giroux
Here are two tools you can use to quickly determine the amount of free space in your databases’ data files. Moreover, they provide commands that you can execute to decrease or increase the size of your data files.]]>David Paul GirouxTue, 14 Jul 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/utilities-assess-data-file-usage-and-provide-commands-so-you-can-do-something-about-it