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.
Category: Azure
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.
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.
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.
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.
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.
It’s 2020, Do I really need to DBCC CHECKDB?
I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from Aug ‘19; though, I haven’t seen any release notes on corruption in Azure.
Let’s say you see a request to restore a database backup to an Azure Managed Instance. You do this task and then a few days later the team that asked for the restore says they are having problems connecting to the newly restored backup.
Database classifications have changed
Some time back I wrote about the new data classification features in Azure and SQL Server Management Studio. If you’ve done quite a bit of work classifying your data using the extended properties, guess what?
SQL TECH BLOG 