Random Number Generator in SQL using Marsaglia Polar

How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?

The Ending Substring

Personal Contact Is Vital

I'm writing this while in hiding at the PASS Data Community Summit that's taking place in Seattle this week. I just had a real surprise, finding out that DocumentDB is PostgreSQL under the covers and always has been. However, as much as I enjoy talking PostgreSQL, for the moment, I'll shut up about it. Instead, […]

Specifying the Collation

Economics of AI: What is the Real Cost to Profit?

Artificial intelligence is everywhere: It’s in our tools, our workflows, our marketing pitches…and increasingly, in our bottom lines. But a thought-provoking article published recently on the AI bubble asks a far more sobering question: What’s it really going to cost to profit from AI? Many people will roll their eyes and say, “Isn’t that obvious? […]

Docker Advice for SQL Server in Production

Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server remains the gold standard. However, there are still certain scenarios—or even specific environments—where deploying SQL Server in containerized setups using the Docker engine becomes necessary. In this article, I will offer practical tips based on my hands-on […]

Strange String Splits

How Implicit Transactions Hurt SQL Server Performance Without You Knowing

Learn about implicit transaction and why you might not want to enable this setting.

I Love Editorials

Why do I love editorials, I can hear you asking. The answer is simple. It's all about opinions. I have opinions. Lots of them. Lots and lots of them. I'm flying home from Hong Kong after visiting a Redgate customer. They are doing amazing work.. It's so cool getting to see how people are solving […]

Building a RESTful API with FastAPI and PostgreSQL

This article shows how to use Python to create a REST API for your application that developers can use to access the database.