Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production?
Category: Development
SQL Server 2019 CU5 is out
Earlier this week Microsoft released the latest cumulative update for SQL Server 2019 and as you can expect there are quite a few items addressed including a fix for UDF inlining that I had posted on recently. You can find the update and a complete list of fixes here:
https://support.microsoft.com/en-us/help/4552255/cumulative-update-5-for-sql-server-2019
SQL 2019 UDF (User defined function) inlining
SQL Server 2019 brings a lot of great new features. Many are introduced by the IQP (Intelligent Query Processing) features and greatly improve query performance.
Which Azure Data Platform service should I choose?
So you’ve decided to use Azure for your existing or new data project? This blog series is focused on choosing the right technology for your project. It’s tough right? So many options and so many variables. This post will focus more on the cost of choices.
SSMS Quick Tip: Never lose your script from overwrite again!
Twenty something years ago when I started my SQL Server career there was an amazing tool called Query Analyzer. Honestly I’d say if Microsoft did nothing more than bring this tool back and call it Azure Data Studio I would have been excited and beyond happy.
May the forced be with you?
Today is May the fourth and I’ll start by saying: Happy Star Wars day to all. Since it is May the fourth I figured a Star Wars themed post would be nice.
Azure Data Factory trigger tip
This tip comes from my DBA days working with SQL Agent Job schedules. If you’ve ever worked on a server where many people created job schedules you’ll know exactly what I mean when I say the schedule names can be really annoying.
Azure Data Studio extension – help wanted
I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice.
Why is the XLOCK table hint broken?
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses. This can be very dangerous because an exclusive lock on a table or partition could cause significant performance concerns.
Free SQL tuning tool: How’s My Database?
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.
SQL TECH BLOG 