Have slow queries and want to get down to the basics of learning some fundamentals for performance tuning? If so, John Sterrett is giving an talk at the Nashville User Group (Online) tomorrow. Feel free to join us. If you are local to Nashville make sure you sign up for their future meetings. Join us […]
SQL Server 2022 was announced yesterday at Microsoft’s Ignite Conference. Here are some of the items that caught our attention. This includes SQL Server 2022 Announcements and other announcements around the Microsoft Data Platform. SQL Server 2022 First Thoughts The following is a summary of some of my favorite announcements with some initial thoughts. Bi-directional […]
Want to save money, validate performance, and make sure you don’t have errors while migrating to Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how to use the Data Experimentation Assistant to replay and compare your on-premise or cloud SQL Server workloads on-demand. First, […]
Today, I want to focus on a free tool that everyone can use when benchmarking queries or performance tuning their queries. This tool is Plan Explorer by SentryOne (I think I will still always know them as SQLSentry). Most people use Management Studio (SSMS) when they are benchmarking queries and improving the performance of their […]
I am a consultant in Austin who can help make your data go fast, be secure and highly available. When I am engaged in a performance tuning project priority #1 isn’t to make sure your data go faster. Priority #1 is to make sure we get the same result sets while making your data go […]
The following are five tips for working remotely that I learned over the years from working remotely with large companies like DELL, RDX and now even as a leader of a consulting company that focuses on making our customer’s data fast, secure and highly available. Manage Your Schedule Manage your schedule don’t let it manage […]
Query Store for Workload Replays This month’s T-SQL Tuesday is hosted by Tracy Boggiano. Tracy invites us all to write about adopting Query Store. Today, I wanted to share my favorite but a very unique way I use the Query Store for Workload Replays. You can read more about the invite in detail by clicking […]
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do this with DBATools.io. You can use the same code to just export if you need a local copy of an Azure SQL database as well. Import-Module […]
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of how you can create custom Azure Security Roles too. That’s right, we are killing two birds with one stone today. Why Should you create a custom […]
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog about it for everyone. The question of the day is where can I download the previous SQL Server Updates? The History towards Updates Back in the […]