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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →