Importing binary files with SSIS

I have gotten a number of emails over the past few days asking about how I import binary files into...

Importing binary files with SSIS

I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...

New Unlocked CPUs From Intel

AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed...

Permission Issue

I found a post of setting up database access in the following site and I responded there and I wanted...

The Truth about SQLPS and PowerShell V2

With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...

Two Blog Series You Don’t Want to Miss

Blogs are a great way to learn new things about SQL Server, and just in case you have missed them,...

Adding Space to a Home Server

I got new drives for my Windows Home Server the other day and decided to add some space to the...

Becoming a Part of the SQL Server Twitter Community

There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have...

BI Conference Grocery Shopping Demo

Help enter demonstration data for the Microsoft BI Conference.

Go to the shopping
demo web form and enter some transactions.

No...

Challenge 19 – An Explanation of a Query

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...