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)
398 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
137 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
33 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
14 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)
563 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)
788 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)
902 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)
314 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)
323 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers