SQL Saturday – Indianapolis is now live. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on August 13, 2016 at Indiana Wesleyan University North, 3777 Priority Way South Drive, Indianapolis, Indiana, 46240, United States
Last year (2015) was a big year for Azure Security. Microsoft released a number of new security capabilities such as Azure Disk Encryption, Azure Key Vault, SQL Transparent Data Encryption (TDE) and Column Level Encryption (CLE), Storage Client-side Encryption, and more. On the product/service side we introduced the public preview…
Use the Microsoft Exchange Server User Monitor to gather real-time data to better understand current client usage patterns, and to plan for future work. Administrators can view details on server resource utilization as reported through server-side tracing. This tool works with Microsoft Exchange Server 2013 and 2016. The tool is provided…
Azure Stack extends the Azure vision by bringing the cloud model of computing to every datacenter. Azure Stack is a new hybrid cloud platform product that enables organizations to deliver Azure services from their own datacenter in a way that is consistent with Azure. To see a short video by Jeffrey…
Wait a minute… How could I have a week of favorite performance tuning resources without including one of my favorites. That’s right we are visiting SQL Skills again for this excellent Beginner’s Guide to Performance Tuning using Wait Statistics written by Jonathan Kehayias and Erin Stellato.
Wrapping up my week of Query Optimization page recommendations and while SQLity.NET does have a lot of information on Query Optimization, it is an older series that they ran on Wednesdays about How SQL Server Stores Data that I am recommending today. This series really digs deep into the world of Data Storage…
When talking about SQL Performance and Optimization, I always like to point to this excellent post by Benjamin Nevarez where he discusses which sources he used to research and write his Query Optimizer book and which research papers he recommend to learn more about query optimization.
A list of favorite blog posts would not be complete without a trip over to SQL Skills and Paul Randal where he asks,”How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?” Well the answer he gives us…
Day two of my favorite posts on SQL Server Query Optimization takes us to Simple Talk and a 2009 blog post from Grant Fritchey and Controlling Execution Plans with Hints. To be honest, while you are there I would check out his book on SQL Server Execution Plans.
Sometimes there are really great posts that explain a topic so well, it is worth sharing. For this next week, I am going to post some of my favorites regarding SQL Server Performance Optimization. Here is a post on Parameter Sniffing where Jes Borland talks about the Elephant and the Mouse problem.