SQL Serverdata mining has always been somewhat of an overlooked, niche technology. There are several logical reasons for SQL Server data mining’s slow adoption. First, there are few companies that take the time to consider if they can benefit from the technology (OLAP tends to be the technological “stop point” in modern day).
Read more →
This morning I passed my next exam, 70-455. This exam is the upgrade to SQL Server 2008 for existing MCITP BI professionals on SQL Server 2005. The exam's corresponding study guide can be found here: http://www.
Read more →
With the arrival of SQL Server 2008 we gained access to a new feature called Change Data Capture (CDC). CDC enables you to constantly stream change data to a consuming process, most notably Extract, Transform, and Load (ETL) applications.
Read more →
My friends over at SQL Server Magazine posted this today...SQL Server 2008 RTM!
http://www.sqlmag.com/Article/ArticleID/99953/99953.html
Microsoft continues to up the 'ante' in the Business Intelligence space, cheers.
Update:
Official Press Release:
Read more →
Well, the new SQL Server2008 build Release Candidate 0 (RC0) has been available for a bit now and I have had some time with the new build. The word "build" brings up a good point actually, before we go any further I want to review the last few SQL Server 2008version numbers.
Read more →
Fellow SQL Friends, a colleague of mine notified me today of SQL 2008 (June) RC0's availability at:
SQL Server 2008 RC0: http://www.microsoft.com/downloads/details.aspx?FamilyId=35F53843-03F7-4ED5-8142-24A4C024CA05&displaylang=en
SQL Server 2008 RC0 Feature Pack: http://www.microsoft.com/downloads/details.aspx?FamilyId=089A9DAD-E2DF-43E9-9CD8-C06320520B40&displaylang=en
Cheers
Read more →
With the impending arrival of Microsoft SQL Server 2008 come several new enhancements. These enhancements can be categorized as new capabilities, old constraints removed, and improvements in scalability. In the SQL Server community (including this blog) you can find numerous amounts of information on the new features found in SQL Server 2008…however you seldom see much on deprecated features.
Read more →
Before I get into this new SQL Server 2008 feature I want to briefly review why we have a new command-line in the Windows platform…In the current Windows ‘landscape’ we have a variety of technologies that can be used to programmatically administer various Windows data stores: 1.
Read more →
Finally, we have a Data Profiling Utility w/SQL Server !!!
With SQL Server Integration Services (SSIS) 2008 you will have access to the new Data Profiler task. The SSIS 2008 Data Profiler Task is an easy and effective method to profile your target source systems (tables & views) prior to building ETL solutions consuming their data.
Read more →
Long time no blog!
I authored this month's (May 08') cover story on an interesting topic...Does SQL Server 2008 BI enhancements warrant an upgrade? It is quite the question and to be honest I dont think a 'one size fits all' reply would do the question justice AT ALL!
Read more →
With the upcoming arrival of SQL Server 2008, the topic of CLR Integration (SQLCLR) is coming up alot again. Probably the biggest reason to use SQLCLR is to replace existing Extended Stored Procedures (XPs).
Read more →
Based on CTP6 (Feb 08' build): Drop me a line and let me know your thoughts and experience with the new Data Collector subsystem!
Its nice to get a few minutes to post a blog, things have been busy (which is good) .
Read more →
Hi Guys,
I've pushed two solid posts on DTS to SSIS 2005 or 2008 on Scalability Expert's App Compat blog as of late. We have done some good work in the SQL2008 space and the blog contains some of our results, thoughts, etc.
Read more →
Microsoft SQL Server 2008 introduces several enhancements & changes to how we group and aggregate relational result sets in TSQL. What follows is a simplistic listing and overview of the grouping/aggregate changes we are seeing in Microsoft SQL Server 2008 CTP5: 1.
Read more →
UPDATE #3 Another question I have received in the feedback portion of this blog post could be summarized as follows: "How does SQLCDC handle new columns being added to a source table being monitored/captured by SQLCDC?
Read more →