Running SQL Server in Google Cloud Platform

• by Daniel Janik

• Confessions of a Microsoft Addict

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-06

10 reads

Living in the new normal as a data engineer

• by Daniel Janik

• Confessions of a Microsoft Addict

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

77 reads

SQL 2019 UDF (User defined function) inlining

• by Daniel Janik

• Confessions of a Microsoft Addict

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)

386 reads

SQL Server 2019 CU5 is out

• by Daniel Janik

• Confessions of a Microsoft Addict

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

1 reads

Weekend Cloud Comic

• by Daniel Janik

• Confessions of a Microsoft Addict

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

Which Azure Data Platform service should I choose?

• by Daniel Janik

• Confessions of a Microsoft Addict

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)

629 reads

SSMS Quick Tip: Never lose your script from overwrite again!

• by Daniel Janik

• Confessions of a Microsoft Addict

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)

799 reads

May the forced be with you?

• by Daniel Janik

• Confessions of a Microsoft Addict

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)

287 reads

Azure Data Factory trigger tip

• by Daniel Janik

• Confessions of a Microsoft Addict

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)

237 reads

SSMS Quick Tip

• by Daniel Janik

• Confessions of a Microsoft Addict

Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a...

2020-05-14 (first published: 2020-04-30)

939 reads