Archives: July 2013
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 columnar store, so indexing is no longer required.… Read more
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. I hope you can make it!
Mark your calendars… Read more
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:
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 SQL Server database to significantly improve the performance of your… Read more
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 use one so that you will be convinced of the… Read more
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 firm (and explains why using a small placement firm has… Read more
Microsoft Power Query for Excel has reached General Availability and is now available for download.
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 the data in a self-service way. It works… Read more
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, September 2012 version: 11.1.20905.0, version shipped… Read more