An installable assembly for SQL Server that adds Deflate (the algorithm used by GZip) Compression functions for nvarchar values. Download the latest release from the Download page. Please note that ...

Currently, the Internet is filled with software that can quickly turn your computer into a DLNA streaming box, but we’re not going to dig into those because they are not needed. We will talk about ...

When writing queries in SQL Server, I frequently use NVARCHAR strings that start with N'. However, after typing N', the auto-close feature doesn't seem to work, as the second single quote doesn't ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment in its ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

The next version of Windows Server is coming soon, and in this article I'll look at some of the improvements and new features. Recently Microsoft held a Windows Server summit, full of (pre-recorded ...

In the new system I am building, we are discussing if and how it might make sense to allow contacts to have social media contact information entered for them. User Story: User enters the information ...