Subscribe to our Newsletter!
If you like our blog posts make sure you subscribe to our newsletter . We will share all kinds of great stuff for FREE!Top Posts & Pages
- Adding a VLDB database to an SQL Server Availability Group
- Azure Managed Instance Changing DNS prefix
- SQL Server 2025: Is the Upgrade Worth the Money?
- 24 Hours of FREE SQL Server Training
- May Adventures!
- Wheeling, WV and Pittsburgh Joint AITP Meeting
- Evaluate your daily checklist against 100+ instances with PBM and CMS
- Community
- 24 Hours of PASS - Get your free downloads!
- My SQL Saturday Houston Story..
Categories
Search Results for: performance
Free SQL Data Compare
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 … Continue reading
Query Store for Workload Replays
UPDATE: 3/16/2020The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below. This month’s T-SQL Tuesday is hosted by Tracy Boggiano. Tracy invites us all to … Continue reading
Posted in Performance Tuning, SQLServerPedia Syndication, syndication
Tagged Query Store, replay, tsql2day
Import Databases to Azure SQL Database
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 … Continue reading
Posted in Azure, backup/restore, SQLServerPedia Syndication, syndication
Tagged Azure SQL Database, dbatools, migrate, powershell
Free SQL Server Training Videos
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. … Continue reading
Posted in SQL Server, SQLServerPedia Syndication, syndication
Tagged free training, videos
Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely if you are following along you have heard of Big Data Clusters, Spark, Performance Tuning, and security features. I am … Continue reading
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster. Microsoft’s marketing team even jumped on to help coin the … Continue reading
SQL Saturday Chicago
Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends. My talk was on Automating the Pain Away with Query Store and … Continue reading
Posted in Performance Tuning, syndication
Tagged automatic tuning, chicago, SQL Saturday
Why is My SQL Server Execution Plan Changing and How do I fix It!
Have, you noticed an important query suddenly takes longer to run? Have you noticed the execution plan looks completely different than what you normally expect for your query? Today, I talked at the Performance Virtual Chapter going over how to … Continue reading
Posted in Performance Tuning
Benchmark Azure SQL Database Wait Stats
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past, I blogged about how you should benchmark wait stats with the box product. This process will give you misleading data in … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged Azure SQL Database, DMV, performance tuning
Calculating DTU in Azure SQL Database
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL? No one answered, so this … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged Azure SQL Database, DTU, performance tuning, Query Store