The Bit Bucket

I’m always excited when I can get involved in conferences with our Polish friends.

Coming up very soon is the Data Science Summit 2022: https://dssconf.pl/en/

For this summit, I’ll be presenting a quick (around 40 minutes) session highlighting what’s changed in T-SQL for SQL Server 2022. I’m always so glad to see T-SQL enhancements in SQL Server and SQL Server 2022 has more than what we’ve seen in other recent versions. There are a number of very important enhancements that will take a little while to get our heads around, on the best way to use them.

2022-11-06

I’ve just finished publishing another show for the Cosmos Down Under Podcast. This time the guest is Charles Feddersen.

Charles (and ex-Melbourne local) is working for Microsoft in the Azure Cosmos DB team. His current focus is the PostgreSQL API that Azure Cosmos DB supports.

In this show, Charles discusses the state of the PostgreSQL market, how it’s implemented in the Azure Cosmos DB for PostgreSQL API, how that compares to Microsoft’s Flexible Server offering for PostgreSQL, distributed tables, scaling databases, and so much more.

2022-11-04

I have a varied client base. Many of my customers are traditional larger financial organizations. But I also work with start-ups and software houses. (Microsoft calls these ISVs - Independent Software Vendors).

Most software houses don’t want to sell software any more. Instead, they want to repackage their solutions as services i.e. they want to offer Software as a Service. (SaaS)

Converting an application to a service is not easy. Even Microsoft had false starts with moving their on-premises applications to cloud-based offerings.

2022-10-03

I’ve just finished publishing another show for the Cosmos Down Under Podcast. This time the guest is Will Velida.

Will is an Engineer for Microsoft working in the Fast Track for Azure team. His focus is on application development and modernization. He is passionate about developers from all walks of life build great things using Azure. Prior to joining Microsoft, he has worked as a software engineer in the financial and agricultural sectors. He was also a Microsoft MVP in the Data Platform category, focusing on Azure Cosmos DB.

2022-08-31

This month, T-SQL Tuesday is hosted by an old friend of mine Kevin Kline. He’s an old friend as I’ve known him a long time, not because of age. (There are lots of miles left in Kevin).  The invite asked about a conference or event that changed your life, that created an opportunity, or just changed your life. It could be career related or another area.

Background

I was invited to join the Microsoft Regional Director program back in the early 2000’s. The RD program had grown out of the original DevDays events, and the RDs were the people who spoke at those events. By the time I joined, they were commonly used as speakers at events like TechEd around the world.

2022-08-09

I was pleased to be sent a pre-release copy of Benjamin Nevarez’s new book SQL Server Query Tuning and Optimization. Last time, I reviewed his High Performance SQL Server book.

This book seems to be somewhat new and somewhat an update, but this time with the main focus on query tuning and optimization. That’s pleasing as the main way to get better performance out of SQL Server is to fix the queries. much more so than anything to do with the hardware or server configurations that so many people focus on.

2022-08-05

One of our popular free resources is the SDU Tools library. If you haven’t checked it out, I’d encourage you to do so. It’s a large library of functions, procedures, and views all written in native T-SQL code.

You can easily use it as a complete library, or use it as examples of how to write T-SQL code. v22 is now available for download.

If you aren’t on our notification list, you can add yourself here:

2022-06-05

One weekend many years ago, my youngest daughter Erin was looking for something to do. She was a very creative child so I suggested “why don’t you write a book?”

She said she could write one, if she only had a title. I told her that you could write a book about almost any title. I randomly picked:

What the duck didn’t see

(with the emphasis on didn’t)

To get her started, I wrote some content, then asked her to continue. She did the same, and then I wrote some more. I turned out to be quite fascinating. I had no idea where she was taking the story and I’d be excited to read what she’d written. Along the way, my eldest daughter Kirsty wrote some content as well. My second daughter Andrea’s name was used for the main person in the story.

2022-01-25

I get pretty excited about new T-SQL enhancements. Back in 2016, I was so pleased to see Microsoft finally add a string split option to T-SQL, but my enthusiasm was limited when I saw how it was implemented. Now that’s mostly fixed !

While it’s possible to build functions that did string splitting just like I wanted, the problem is that no matter how you implemented them, they were really just too slow. And most importantly, much slower than a built-in function would be.

2021-11-05

Azure Data Factory (ADF) is great for moving data around. It often needs to connect to SQL databases. If you’re creating linked services for this, please try to avoid using SQL logins. Don’t use usernames and passwords for authentication if you can avoid them.

Azure SQL Database lets you can create a user from a data factory’s managed service identity (MSI). MSIs are a special type of Service Principal (SP). They provide an identity where you don’t need to manage the ID or any sort of password.  Azure does that for you.

2021-09-26