Browse by Tags

SQL Table stored as a Heap - the dangers within
30 April 10 11:55 AM | MikeD | 6 comment(s)

Nearly all of the time I create a table, I include a primary key, and often that PK is implemented as a clustered index. Those two don't always have to go together, but in my world they almost always do. On a recent project, I was working on a data warehouse...

Filed under: SQL Server, Merge, Heap

SSIS Bulk Insert task that bit me in the butt...
02 October 09 12:22 PM | MikeD

I've been working on SSIS packages that extract data from production databases and put them into data warehouses, and recently I hit an issue using the Bulk Insert task that bit me real good. When you create a Bulk Insert task in the control flow of your...

Filed under: SQL Server, SSIS, Integration Services

SQL Database diagramming and VSTS Data Dude
28 July 09 07:14 PM | MikeD

At Imaginet, we use Visual Studio Team Edition for Database Professionals (Data Dude) on our projects to manage database schemas, keep them in source control, unit testing, and lots of other nice features. But it doesn't do database models well. Or at...

Filed under: Visual Studio, SQL Server, Data Dude, Imaginet

MS BI Conference: Monday Keynote
06 October 08 08:31 PM | MikeD

Here are my notes on the Monday morning keynote: About 3000 attendees at the conference, over 60 countries represented. There is BI in Halo3: whenever you look at competitor stats or weapon effectiveness, this is implemented using BI tech Madison - MS...

Filed under: .NET, SQL Server

Swivel
14 December 06 12:58 PM | MikeD | 1 comment(s)

Swivel has been called "YouTube for Data". Very cool. Who will be the first to post their Team System productivity data? How about some kind of SQL Server connector to Swivels?

Filed under: Team System, SQL Server