Handling Inconvenient Requests
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
Using a Derived Table to Compare Data with Values from a Previous Year
Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL
Understanding your Azure EA Billing Data and Building a Centralized Data Storage Solution
Many organizations are moving to Azure and other cloud providers. Understanding how resources are being used and what is spent is very important. In this article, Feodor explains his solution for automating the collection of the Enterprise Agreement billing from Azure into an Azure SQL Database where it can be analyzed.
CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
Rolling up multiple rows into a single row and column for SQL Server data
Do you need a way to roll-up multiple rows into one row and one column. You know you can roll-up multiple rows into one row using Pivot, but you need all of the data concatenated into a single column in a single row. this tip looks at a simple approach to accomplish this.
Finding a String Anywhere in Another String
Optimize searching for a string within another string with this string storage and indexing technique.
Have You Been Hacked?
Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.
Introduction to Azure Cosmos DB Global Distribution
Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years. Addressing this challenge has become increasingly pressing as the rapid growth of cloud technologies increased the need for deployments capable of spanning multiple geographical areas. In this article, we will provide an introduction to global distribution-related functionality in Cosmos DB.
Building RESTful APIs using Node JS, Express JS, and MS SQL Server
This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server.
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers