Monthly Archives: July 2013

SQL Server 2014: Columnstore Index improvements

In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query performance improvements.  In SQL Server 2014, there have been two major improvements on this feature: Clustered: They have enhanced the columnstore to be a pure … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 2 Comments

Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday, July 31st, at 10pm EST for the 24 hours of PASS, PASS Summit Preview.  Info about the event, and the abstract for my session, is below. … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

TechEd Europe 2013 videos online

Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free!  Some great videos on the latest products and versions.  Check them out here.  There are four videos on SQL Server 2014: Microsoft SQL Server … Continue reading

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

SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton

What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”, code-name: Hekaton.  In short, Hekaton is a SQL Server In-memory OLTP Engine.  Hekaton provides in-memory OLTP capabilities built into core … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 3 Comments

Why You Need a Data Warehouse

Introduction You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one.  I will attempt to help you to fully understand what a data warehouse can do and the reasons to … Continue reading

Posted in Business Intelligence, Data warehouse, SQLServerPedia Syndication | 11 Comments

The benefit of placement firms

Why do companies use placement firms to find IT contractors instead of using internal recruiters? Who better to answer that question that a recruiter who has been in the business for many years and now has his own small placement … Continue reading

Posted in Consulting, SQLServerPedia Syndication | Leave a comment

I’ll take “Products that start with Power”, Alex

FYI: Geoflow (see Geoflow Preview for Excel 2013) is now called Power Map, and Data Explorer (see Microsoft Data Explorer) is now called Power Query. Microsoft Power Query for Excel has reached General Availability and is now available for download. More info: “Data … Continue reading

Posted in Excel, Power Map, Power Query, SQLServerPedia Syndication | Leave a comment

Power BI for Office 365

Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365: Power BI for Office 365 is a cloud-based business intelligence (BI) solution that enables customers to easily gain insights from their data, working within Excel to analyze and visualize … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, SQLServerPedia Syndication | 2 Comments

SQL Server Data Tools (SSDT) – June 2013 update

SQL Server Data Tools (SSDT) has a new update: VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version: 10.3.21101.1, September 2012 version: 10.3.20905.0, initial version: 10.3.20225.0 VS 2012: June 2013 version: 11.1.30618.1, December 2012 version: 11.1.21208.0, November 2012 version: 11.1.21101.1, … Continue reading

Posted in SQLServerPedia Syndication, SSDT/Juneau | 1 Comment