Wednesday, December 31, 2008

DM Companion – Data mining in cloud city

If you would like a better understanding of the Data Mining Experience from the web, DM Companion looks like a good learning tool.

Of course, there’s always this tool too:
http://sqlserverdatamining.com/cloud

DM Companion

Monday, December 29, 2008

DataPort Web | Sql bulk insert and paramaters

 

Sometimes transferring data quickly and safely can be a major task. In the following example I’ll show you how you can do a parameterized insert and how to use the sql transaction. This will speed up your insert tremendously.

DataPort Web | Sql bulk insert and paramaters

Data Dude - VSTS Database GDR VPC

 

You can download the VPC from the following location:

Data Dude

Sunday, December 21, 2008

Metadata Toolkit - Windows Live

The BI Metadata Toolkit

Overview

This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.

http://www.microsoft.com/downloads/details.aspx?FamilyID=182bd330-0189-450c-a2fe-df5c132d9da9&displaylang=en

Metadata Toolkit - Windows Live

Saturday, December 20, 2008

Download details: SQL Server 2005 SP3

 

Microsoft SQL Server 2005 Service Pack 3

Brief Description

Download Service Pack 3 for Microsoft SQL Server 2005.

Download details: SQL Server 2005 SP3

Tuesday, December 09, 2008

Andrew Fryer's Blog – creating a “time of day” dimension

Highlighting some of the pluses of SQL 2008

Following on from my previous post, in some data warehouses there is a separate dimension for time of day, so that demand through a day can be modelled. Storing time in SQL server 2005 was a bit of a cludge typically involving picking an arbitrary date (like 1/1/1900) and then tacking the time on to the end of that.  Now there’s a separate time data type so it’s easy to store the right data and create the time dimension using a script like this:

declare @time time = '00:00'
declare @timekey int = 0
declare @timegrain int =15

if not exists
    (select  * from sys.tables where name = 'dimTimeofday')
create table dimTimeofday( timekey int, TimeofDay time)
while @timekey < 1440 begin   
    insert into dimTimeofday(timekey,Timeofday) values (@timekey, @time)
    set @time = dateadd(minute,@timegrain,@time)
    set @timekey += @timegrain
end

For more on the new time data type check books on line here.

Andrew Fryer's Blog

Monday, December 08, 2008

SQL Server Matrix Workbench

Excel inside SQL Server?  It’s possible…

/*In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in SQL. They maintain that 'One just needs a clear head and think in terms of set-based operations' */

SQL Server Matrix Workbench

Thursday, December 04, 2008