SQL Server with Mr. Denny:

Extended Stored Procedure

1

November 17, 2012  2:00 PM

Backup Databases on Creation



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, CREATE TRIGGER, Data Loss, Database, Database Administration, DDL Trigger, Recovery, SQL Server, SQL Server 2008 R2, SQL Server 2012, T/SQL, Transactions, Trigger, xp_create_subdir

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs.  As all the new databases are...

September 11, 2009  7:43 AM

South Bay .NET User Group, thanks for having me over.



Posted by: Denny Cherry
Extended Stored Procedure, In Person Events, Indexing, South Bay .NET User Group, Stored Procedures

Tonight I spoke at the South Bay .NET User Group.  I had a blast talking with them.  They are a great group of programmers. Continued »


March 29, 2009  12:05 AM

Viewing the domain groups that are used to get into SQL



Posted by: Denny Cherry
Extended Stored Procedure, Linchi Shea, T/SQL, xp_logininfo

Last week Linchi Shea wrote a posted a blog entry entitled "How does that AD user...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 25, 2008  11:00 AM

How to setup a server to read log files nightly.



Posted by: Denny Cherry
Backup & recovery, KILL, Log Shipping, Recovery, RESTORE LOG, SQL Server 2005, xp_delete_file, xp_dirtree

So you've been tasked with setting up a quick and dirty reporting server.  The goal is to restore the log files from the production server to the reporting server nightly.  The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine.  But...


April 28, 2008  9:00 AM

Checking free disk space from T/SQL



Posted by: Denny Cherry
SQL, T/SQL, xp_fixeddrives

I've seen some very creative ways to see how much free disk space SQL Servers have.  Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way.  Microsoft has included the system extended stored procedure xp_fixeddrives.  It returns the...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: