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...
2021-09-06 (first published: 2021-08-13)
264 reads
Daniel Janik
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...
2021-09-01 (first published: 2021-08-11)
333 reads
Migrating from SQL Server to Amazon AWS Aurora
Is Microsoft’s licensing scheme getting you down? It’s 2020 and there are now plenty of data platforms that are good for running your enterprise data workloads. Amazon’s Aurora PaaS...
2020-12-16 (first published: 2020-12-07)
381 reads
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...
2020-07-31
19 reads
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...
2020-07-15 (first published: 2020-07-06)
363 reads
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...
2020-06-28
120 reads
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. Some time ago I...
2020-06-24 (first published: 2020-06-09)
505 reads
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...
2020-06-24
15 reads
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!
2020-06-20
4 reads
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?...
2020-05-28 (first published: 2020-05-17)
763 reads
Blogs
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation...
Forums
Pay close attention to little details
It is crucial for Wikipedia contributors to decide what they will cover in their...
Easy Guide on How to Fix QuickBooks Error 15271
Error code 15271in QuickBooks is common error of the 15x series. A QuickBooks Error...
TCP Provider: A connection attempt failed for target server
Hi. In source SQL Instance target linked server has been created and connection tested...
Ask SSC