Here is a Sneak Peek Preview of SQL Server 2016 and Cortana Intelligence by Tim Ford at SQL Server Magazine.The biggest features in the new edition of SQL Server are Always Encrypted, Stretch Database, integrated R language support in SQL Server, Cortana Intelligence, and the SandDance data visualization tool.
Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005. This will be extremely important to all the Performance Tuners out there to really understand what is slowing your SQL code down. I can’t believe…
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…
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.
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…
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 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…
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…
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 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…