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
32 reads
Confessions of a Microsoft Addict
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)
396 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
135 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
31 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
13 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)
558 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)
786 reads
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...
2020-05-27 (first published: 2020-05-07)
899 reads
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...
2020-05-21 (first published: 2020-05-05)
311 reads
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...
2020-05-19 (first published: 2020-04-30)
320 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers