Introduction to GitHub Actions Part 1: Getting Started
This article series will teach you what you need to know to take advantage of GitHub Actions, especially for deploying database code.
2025-04-07
This article series will teach you what you need to know to take advantage of GitHub Actions, especially for deploying database code.
2025-04-07
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]
2025-04-04
2,845 reads
If you don’t know, DAX (Data Analysis Expressions) is a language for creating custom calculations and aggregations in Power Pivot, Power BI, and other data analysis tools. Two functions in DAX come close to replicating the functionality but come with limitations. Which one of these functions should you use?
2025-04-04
If you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put data directly into a database; we have to encode it and represent it in a format which a machine can handle.
2025-04-02
Learn how the DeepSeek GenAI LLM works and see how it produces SQL code.
2025-03-31
3,512 reads
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks that look like they’re going to lead to more information – but they simply lead back to themselves.
2025-03-31
Learn about the new string similarity functions in Azure SQL Database.
2025-03-28
6,099 reads
Regular expressions (REGEX) let you adaptively investigate, employ, and authenticate text data. This makes it easy to search for simple or complex string patters. There is no direct way to do this in SQL Server, but in this article we look at some SQL functions you can create to emulate regex like functionality.
2025-03-28
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to effectively use it to drive business growth and innovation. Having recognized the power of the cloud in terms of agility, scalability and innovation, organizations are turning their focus to how to get more from their investment. One such consideration is multi-cloud.
2025-03-26
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,362 reads
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, Our old server is on its last legs, and I'm transitioning to a...
Comments posted to this topic are about the item Docker Advice for SQL Server...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers