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)
258 reads
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
17 reads
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)
356 reads
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
115 reads
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)
460 reads
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
6 reads
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
2 reads
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)
752 reads
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)
838 reads
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)
292 reads
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...
CPU Usage was running very high than normal. Identified the top query, so removing...
Is the a way in SSIS to add a comma to the end of...
I've had this problem rear its head before but not in some time. There's...
Ask SSC