Categories
Azure

Grab Yourself Some Free Azure SQL Offerings

Its the time of year where things may winding down for the new year and we can get a bit of breathing room. With that free time you might want to try something new, let’s say some SQL Server in the cloud? It could be a good time to start brushing up on new skills, […]

Categories
Misc

Streamlining Email Alerts with Sub-addressing

Automated email alerts lead to information overload. Emails for failures, confirmation, or just for information. So, we build rules and filters to try and handle them, hoping nothing new slips through the net. How about an alternative to bring consistency and streamline your inbound emails? Let’s take a look at Sub-addressing to overcome the overload. What is […]

Categories
Azure

Legacy Problems for a Modern Solution: Establishing a Linked Server into Azure

Connecting different versions of SQL Server can allow us to combine or transfer data between environments. This can become a challenge when the versions are really different. Have you tried to connect SQL Server 2008 to a SQL database in Azure? – it can throw up a few curve balls. In this post we’ll look at how […]

Categories
T-SQL Tuesday

T-SQL Tuesday #181 – The Festive Tech Calendar ft. Query Store

Rounding out T-SQL Tuesday for 2024, Kevin’s invitation brings it together with the Festive Tech Calendar (more on that at the end), and asks us to write about a Microsoft Data Platform announcement that could be considered a gift. For context, this post is targeted at developers or engineers who don’t have the time to dig into SQL Server […]

Categories
SQL

You Probably Don’t Need ODBC Functions

This past week I stumbled across an ODBC Scalar Function for the first time. What was this which lay before me? Is that SQL with curly braces?! It returned the current date like this: It’s a function, but not quite as we know it. They’re surrounded by { curly braces } and prefixed with fn. The kind of thing I’d […]