Building the Enterprise DW/BI System with SQL Server PDW

Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...

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

Dell Quickstart Data Warehouse Appliance for SQL Server 2012

As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart...

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