CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't.

Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

In-Depth Top 7 Features Coming to SQL Server 2016 SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. By Joey D ...

Microsoft today released the 2022 version of its SQL Server database, which features a number of built-in connections to its Azure cloud.

DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Checking Service Dependencies is an important step because SQL Server might rely on other services to function correctly. SQL Server won’t start if these dependent services aren’t running.

AI Server Market AI Server Market Dublin, Jan. 13, 2025 (GLOBE NEWSWIRE) -- The "AI Server Market by Processor Type, Function, Form Factor, Cooling Technology - Global Forecast to 2030" report has ...