SQL Server Team articles

Avatar photo
SQL Server Team
Published 
3 min read

“Modernizing” Your Data Warehouse with Microsoft 

Data warehousing technology began as a framework to better manage, understand, and capitalize on data generated by the business, and it worked extremely well for many years. This is a space that Microsoft knows well with warehousing capabilities since 1995 with SQL Server. However, there are several forces working to stretch the traditional data warehouse. Data volume is expanding tenfold every five years.
Published 
16 min read

The New and Improved Cardinality Estimator in SQL Server 2014 

One area where a lot of development work went into SQL Server 2014 is the area of query optimization where a crucial component got re-written in order to improve query access and predictability. To get a better idea about the significance of the change and the way how one should deal with it, let’s first check what the component of cardinality estimation is responsible for.
Published 
2 min read

Microsoft Brings Innovations From SQL Server To Hadoop With Stinger 

Over the last two years, Microsoft has been sharing our progress in Big Data by working to bring Hadoop to the masses through the simplicity and manageability of Windows and Azure. In 2012, Microsoft communicated our expanded partnership with Hortonworks by making Hortonworks Data Platform the core of our Hadoop solution on-premise and in the cloud.
Published 
2 min read

Top 3 Features I’m Excited About in SQL Server 2014 

Guest blog post by:  SQL Server MVP Adam Jorgensen – PASS Executive Vice President, Finance & Governance, and President of Pragmatic Works – has been leading innovative SQL Server and Business Intelligence organizations for over a decade. His passion is finding new and creative avenues for clients and the community to embrace innovation and lower barriers to implementation. You can read his blog at AjBigData.
Published 
5 min read

Data Visualizations 

A couple of weeks back was a really exciting time for us. Less than a year after we released Office 365 for Businesses, we announced the general availability of Power BI for Office 365. You may have read previous blog articles by Quentin Clark on “Making Big Data Work for Everyone” and Kamal Hathi on “Simplifying Business Intelligence through Power BI for Office 365”.