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…
During this 30-minute webinar from January 13, 2016, Jeremy Cioara, Garth Schulte, and Ben Finkel compare and contrast Amazon Web Services, Google Cloud Platform, and Microsoft Azure — three of the leading cloud platforms on the market. You’ll learn what features the three share, what features help them stand out,…
Microsoft is currently offering two new ways to support IT professionals and their companies in a smooth transition to the cloud: Microsoft IT Pro Cloud Essentials and Microsoft IT Pro Career Center. The IT Pro Cloud Essentials and the IT Pro Career Center are the two newest programs to help IT…
Get a head start evaluating Windows Server 2016—guided by the experts. Based on Technical Preview 4, John McCabe and the Windows Server team introduce the new features and capabilities, with practical insights on how Windows Server 2016 can meet the needs of your business. Get the early, high-level overview you…
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.
Bash on Windows 10 was one of the big reveals at Microsoft’s recent Build conference. Since then, there’s been a lot of speculation about what Microsoft did to make this possible. Microsoft is starting to provide more details via blog posts and a new Channel 9 video on what’s going on under…
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…