Feeds:
Posts
Comments

Archive for the ‘SQL’ Category

SQL BI at Hadoop Summit = Awesomesauce!

Posted in Analysis Services, BigData, SQL, tagged , , on May 30, 2012 | Leave a Comment »

For the 2012 Hadoop Summit, I will have the honor to co-present with Dave Mariani (@dmariani) from Klout in our session How Klout is changing the landscape of social media with Hadoop and BI. Our session is currently scheduled for June 13th at 3:35pm but it is subject to change.  Check out our session and [...]

Read Full Post »

Moving data to compute or compute to data? That is the Big Data question

Posted in BigData, SQL, tagged , , on January 31, 2012 | 2 Comments »

Dorky attempts at geek Shakespere aside; as the volume, complexity, and variability of your data systems increase in … entropy …, this becomes a fundamental question in whether one scales up or scale out their data problem. Apologies for the nerdy chemistry references in advance – which starts with this picture of Dr. Arthur Grosser [...]

Read Full Post »

Scale Up or Scale Out your Data Problems? A Space Analogy

Posted in BigData, SQL, tagged , , on January 24, 2012 | 7 Comments »

As I am writing more about Big Data, I’m been asked whether we need to have traditional relational or cube systems now that we have Big Data / NoSQL / Hadoop.  My responses are to note that these are different systems that serve different purposes even though both are used to better understand data. But [...]

Read Full Post »

Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud

Posted in BigData, Cloud, PowerPivot, SQL, tagged , , on January 21, 2012 | 12 Comments »

. “I caught a fish thiiiiis biiig” – On stage with Ted Kummert during the PASS 2011 Keynote on Big Data (thanks to Karen Lopez @datachick for the pic) . . During the PASS 2011 Keynote (back in October 2011), I had the honor to demo Hadoop on Windows / Azure.   One of the key [...]

Read Full Post »

Revelations – rolling the hard six to SQL BI and Hadoop

Posted in BigData, SQL, tagged , on October 12, 2011 | 5 Comments »

  Sometimes, you have to roll a hard six. – Commander Adama in Battlestar Galactica “Revelations”     In May of this year, I had noted that I was At a Crossroads … from SSAS to Big Data!.  After I had written this post, many people ping me wondering if I had left the world [...]

Read Full Post »

SQL Server/PDW Hadoop Connectors

Posted in BigData, SQL, tagged on August 9, 2011 | 2 Comments »

Stargate-SG1 Quote from SG-1 episode Bad Guys: (Vala is attempting to power the stargate with a Goa’uld bomb.) Vala: There’s a 70% chance that if we dial manually we’ll be able to establish a connection, and a 50% chance the bomb will just go off. Lt. Col. Mitchell: That a 120%. Vala: Well there’s some [...]

Read Full Post »

Procedure used for applying Database Compression

Posted in SQL, tagged on December 12, 2009 | Leave a Comment »

A very handy SQL Server 2008 data compression procedure was posted by my collegue Juergen Thomas with his extensive background in SAP.  He propped up an excellent blog post about data compression at: Procedure used for applying Database Compression to Microsoft SAP ERP system. What is interesting here is that he had created a procedure [...]

Read Full Post »

SQL Server 2008 Data Warehousing Channel 9 Videos

Posted in Data Warehousing, SQL, tagged on July 2, 2009 | Leave a Comment »

Eric Hanson has created a series of SQL Server 2008 data warehousing videos posted on Channel 9.  They cover data compression, backup compression, star join enhancements, parallel query enhancements, change data capture, grouping sets, and partition-aligned indexed views.   Quick and informative videos to get you up to speed on SQL Server Data Warehousing.  For these [...]

Read Full Post »

SQL Server 2008 Data Warehousing Channel 9 Videos

Posted in SQL on July 1, 2009 | 84 Comments »

Eric Hanson has created a series of SQL Server 2008 data warehousing videos posted on Channel 9.  They cover data compression, backup compression, star join enhancements, parallel query enhancements, change data capture, grouping sets, and partition-aligned indexed views.   Quick and informative videos to get you up to speed on SQL Server Data Warehousing.  For these [...]

Read Full Post »

Disk Partition Alignment Best Practices for SQL Server

Posted in SQL, tagged , , on May 12, 2009 | Leave a Comment »

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers