SSIS 2008 Data Profiling Task

Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task. The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say “statistics” I mean things like column value and length distribution, column null ratio, column patterns, and functional dependencies. You can learn more in …
Continue reading SSIS 2008 Data Profiling Task

Microsoft Announces SQL Server Data Services (SSDS)!

Cool things are coming out of Mix08! There’s even something there for we database people: SQL Server Data Services. From Neil Hutson’s blog: SSDS you can think of as a structured data store in the cloud(building block service), which is accessed using Internet protocols using a basic data manipulation language. SSDS is for developers and …
Continue reading Microsoft Announces SQL Server Data Services (SSDS)!

Microsoft and Open Source: This Changes Things

There was a pretty big announcement from Microsoft yesterday: Microsoft Makes Strategic Changes in Technology and Business Practices to Expand Interoperability. To quote Steve Ballmer: Number one, we’re committing to ensure open connections for our high volume products. Number two, we’re committing to promote data portability for our high volume products. Number three, we’re committing …
Continue reading Microsoft and Open Source: This Changes Things

DreamSpark: Free Software for Students

This is cool! Microsoft is giving away software – including SQL Server 2005 Developer Edition, Windows 2003 Standard Edition, and Visual Studio 2005 and 2008 Professional Editions – to college students. It’s called DreamSpark and it puts professional software tools in the hands of students interested in learning more about designing and developing solutions. From the …
Continue reading DreamSpark: Free Software for Students

Power Tools for Visual Studio Team System 2008 Database Edition

Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition! Cool new stuff includes a couple new test conditions, file- and XML-based data generators, and (my favorite) SQL Static Code Analysis integrated into MSBuild / Team Build! Download page:http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en Installer download:http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/VSTSDB2008PT.msi Documentation download:http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/Power Tools 2008.doc Great work Team! …
Continue reading Power Tools for Visual Studio Team System 2008 Database Edition