Category Archives: SQL Server

Visual Studio 2012 now supports BI!

Posted on March 6, 2013 by

My most popular blog has been Visual Studio 2012 does not support BI.  In short, this means VS 2012 does not support SSAS, SSIS, or SSRS.  Well, not anymore!  Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading →

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2012 | 8 Comments

24 Hours of PASS: Business Analytics Edition videos online

Posted on February 7, 2013 by

On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to deliver a series of one-hour webcasts, digging deep into the world of business analytics over five tracks.  All session recordings … Continue reading →

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

PASS Summit 2012 session videos online

Posted on December 27, 2012 by

If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash drive or view them online.  You can purchase the Regular Summit Sessions as well as the Pre-Conference Sessions.  However, if … Continue reading →

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

24 Hours of PASS videos online

Posted on October 12, 2012 by

All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free.  Check the session schedule for a complete list.  Enjoy!

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

The MERGE statement in SQL Server

Posted on September 5, 2012 by

The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based on data in a source table in one easy statement, replacing lots of messy code.  I use it frequently when … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication | Leave a comment

Visual Studio 2012 does not support BI

Posted on July 25, 2012 by

UPDATE 3/6/13: VS 2012 now supports BI!  Check out Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does … Continue reading →

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2010, Visual Studio 2012 | 30 Comments

TechEd Europe 2012 videos online

Posted on July 23, 2012 by

Microsoft has posted ALL the session videos for TechEd Europe 2012 and they are available for free!  What a great way to learn all about SQL Server 2012.  Check them out here.

Posted in SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

SQL Server table partition switching

Posted on July 5, 2012 by

If you are using partitions in SQL Server, be aware that “partition switching” is a great feature to quickly truncate partitions or to load data in parallel. To truncate a partition: Create a staging table with the schema structure matching the … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication | 1 Comment

TechEd North America 2012 videos online

Posted on June 15, 2012 by

Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free!  What a great way to learn all about SQL Server 2012.  Check them out here.  Also check out the Top 10 Lists for … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

PASS Summit session videos online

Posted on January 20, 2012 by

If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD.  You can purchase the Regular Summit Sessions as well as the Pre-Conference Sessions.  However, if you are interested in the sessions … Continue reading →

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment