Google Research

Interesting to see someone talking about all the research Google is spending money on, which aren’t directly related to their...

Re-blog – March 16 – March 22

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

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...

Trim Functions in SSIS

In T-SQL there are many functions there to help do a variety of different things.  SSIS is no different.  In...

Change your Windows path

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

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...

How do you secure the SQL Server instance after enabling xp_cmdshell ?

OR
How do you allow non-administrator to use xp_cmdshell ?

From the day I started working with SQL server, I have heard
about...

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...

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...

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....