If you are not happy with the results below please do another search
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 […]
Do you need help with a database project but don’t want to commit to ongoing support? We’ve got you covered. Procure SQL’s Project DBA Services allow you access to our senior-level SQL Server database administrators without a monthly engagement. Some of our most popular professional services offerings include performance tuning, data warehousing, SQL Server upgrades, […]
We understand that choosing a trusted Remote DBA Services or Data Architect Services provider is critical, whether you’re just getting started with SQL Server, have a very specific urgent need, or are looking for a project DBA or data architect. For the last 10-PLUS years, we’ve learned that your needs typically fall into one of […]
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 […]
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 […]
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some of my favorite places to find free SQL Server training videos. I hope this helps make your data fast, secure and highly available in 2020 and […]
Automatic Tuning: Scalar Functions with SQL Server 2019 Learn how SQL Server 2019 automatically makes your scalar functions run faster by converting row by row processing to set based processing without any code changes. The Silent Performance Killer: Scalar Functions vs Table Value Functions Learn how scalar functions cause row by row processing which causes […]
SQL Server Azure walk-through and basics Cloud migrations can be tough. The last thing you want to do is overspend and negatively impact your users. First, If you would like some help or to talk with us to bounce some ideas we would love to chat with you. Below are several resources our clients find […]