SQL Server RESTORE DIFFERENTIAL BACKUP WITH SIMPLE RECOVERY

First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database...

Coming to Dallas: Something for Everyone

Everybody loves the carnival.  It only comes around every few years, but when it does, it brings in a variety...

Transforming Event Log Data

Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...

March #Meme15 Round-up – Facebook

Are you ready for the round-up of last week’s #meme15 Facebook question?
In total, there were eight participants in this month’s...

Change your Windows path

When you run something from the start menu or in a Windows command prompt, you type the program name to...

RYO Maintenance Plan – History Cleanup

The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step....

Event ID 7026 and i8042prt troubleshooting

Event ID 7026 and i8042prt is a recurring error in the Windows Event Logs. I usually see this error on...

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...

SQL Server 2012 Unattended Installation on Windows Server 8

SQL Server 2012 Unattended Installation on Windows Server 8