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
- SQL Server 2025: Is the Upgrade Worth the Money?
- Azure Managed Instance Changing DNS prefix
- Benchmark SQL Server Disk Latency
- Building a Data Warehouse with SQL Server
- Building Your First Data Warehouse with SQL Server
- 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
Categories
Search Results for: performance
WVPASS – Performance Tuning for Pirates!
If you are in the Pittsburgh, PA area take a trip down to Wheeling, WV this Thursday to catch me at the WVPASS SQL Server User Group. Registration is free and there are a few free seats available. I will be breaking out … Continue reading
SQL Server 2025: Is the Upgrade Worth the Money?
SQL Server 2025 was released in November of 2025. The issue I’ve found is that reviews of SQL Server 2025 that showcase the business impact of the upgrade are hard to find and don’t focus solely on its technical aspects. … Continue reading
Posted in C-Level, Data Architecture, SQLServerPedia Syndication
Tagged ROI, SQL Server 2025
SQL Server 2025 Standard Developer Edition
With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading
Austin, Texas Best Microsoft Technical Training Oppertunity
If you’re looking to master SQL Server, Power BI, or Microsoft Fabric, attending the SQL Saturday event in Austin, Texas, is one of the smartest moves you can make for your career. Note: Austin, Texas, is hosting their event on … Continue reading
Weekly Content – Nov 4 2024
The following is content I created, links, videos, and other things I found interesting and wanted to share this week. My Content Microsoft Fabric Mirroring is Change the Game for Data Analytics – In this quick write-up, you will learn … Continue reading
SQL Saturday Jacksonville – May 14th, 2022
Hi Everyone, This is your Austin SQL Server Consultant and I will be speaking at SQL Saturday Jacksonville. I am happy to get back out and, on the road, again. I know COVID has impacted everyone in multiple different ways. … Continue reading
2021 PASS Member Summit Session Review
This past month I was honored to build and deliver a session that would help anyone get started with performance tuning. If you signed up for free to attend you can catch the session on-demand for free for six months. … Continue reading
Posted in Performance Tuning
Persist Sample Percent in SQL Server IS Fixed!
Hi Everyone, this is John Sterrett. I am a SQL Server Consultant in Austin, TX. Last year I blogged about a feature called Persist Sample Percent. It had a nasty bug that could negatively impact performance. I have great news … Continue reading
Replay your Workload in the Cloud
Want to save money, validate performance, and make sure you do not have errors while migrating to the cloud? You need to learn about the DEA today. Once you’ve added the DEA to your toolkit, you’ll look like the rockstar … Continue reading
Posted in Uncategorized
Workload Replay for Azure SQL Database and Amazon RDS
Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how to use the Data … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged aws, azure, Migration, performance tuning, replay