SQL Server

Data Platform Evolution

Register now for 24 Hours of PASS: Evolution of the Data Platform!  From May 25-26, 2016 starting at 8am EST 24 one-hour webinars will be presented live back-to-back for you to enjoy from the comfort of your home or office! This edition will showcase cutting-edge technologies presented by a diverse mix of…


SQL Saturday Pre-conferences

What an exciting line up of speakers and topics we have for this years’ SQL Saturday pre-conferences on Friday, August 12, 2016. If you are in the Indianapolis area, you definitely don’t want to miss these sessions.


Seven Steps to R

Learning R can be tricky, especially if you have no programming experience or are more familiar working with point-and-click statistical software versus a real programming language. This learning path is mainly for novice R users that are just getting started but it will also cover some of the latest changes…


50 Important SQL Queries

In this article Pankaj Kumar Choudhary explains some general purpose queries. Every developer should have knowledge of these queries. These queries are not related to any specific topic of SQL. But knowledge of such queries can solve some complex tasks and may be used in many scenarios.


SQL Query Store Overview

SQL Server’s Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be…


Intro to Stretch Databases

Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. This new ability is known as Stretch Database and the feature will be beneficial to those needing to keep transactional data for long periods of time and those looking to save…


Azure Periodic Table

Do you want to learn what all the different pieces of Azure are available. Well, here is a  Clickable version of the Azure Periodic table. This is an excellent resource to get you started in the Azure world.


SQL Server 2016 Public Preview

SQL Server 2016 public preview now available! Three weeks ago at Microsoft Ignite the next major release of Microsoft’s flagship database and analytics platform was announced. Today over at the SQL Server Blog they are announcing the first public Community Technology Preview (CTP2) for SQL Server 2016.  This public preview gives…


SQL Server 2016 preview

Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world.  The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Find out more…