Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production?
Counting cars with Azure’s Computer Vision service
When I was 11 I got my first computer, an 8088 with 4.5 mhz. I didn’t know much about computers at the time but I knew it was cool. It took me a while to figure out that there was a turbo mode to take that puppy up to 8.5 mhz. Dialing up to BBS hosts with 2400 baud… the nostalgia is in full effect. That’s right. The internet we know today wasn’t even a thing yet.
Azure Purview Best Practice: Naming your scans
If you’ve ever been a DBA and seen the mess that you get with SQL Agent Jobs without a clean naming standard for your job schedules and job names then you’ll appreciate this tip.
Using PyApacheAtlas to import SQL Server extended properties to Azure Purview
Azure Purview is a compliance and data governance platform in Microsoft’s Azure cloud. The platform is currently in public preview and has quite a few features; but, does not currently import any of the extended properties that you may have added over the years to your SQL Server objects.
AWS Community Builders #AWSCommunity
I’m excited and happy to announce that I’m part of the AWS Community Builders. Check out more on Twitter with the #AWScommunity tag. To learn more about the program and other cool things that AWS is doing in the cloud, check out this blog from AWS:
https://aws.amazon.com/blogs/aws/announcing-the-new-aws-community-builders-program/
Running SQL Server in Google Cloud Platform
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows Phone of cloud providers” and what I meant by that is they have a great product that little market share when compared to Azure and AWS; but, should you be looking at GCP?
Living in the new normal as a data engineer
For the past few months most of the world has been in quarantine and you may think that this is the new normal, especially now that “re-opening” has been rolled back or paused in many places.
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
Weekend Cloud Comic
I got a mailer for “The Container Store” this week and thought of the following scenario so I figured I’d hand-draw a comic to lighten your weekend. Enjoy!
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.
SQL TECH BLOG 