Object Explorer Menu is a free, open-source extension for SQL Server Management Studio (SSMS), developed in C#. It enables users to add custom menu items to the right-click context menu within the ...

Parameterized logic (IN / OUT / INOUT). Full SQL scripting: control flow (IF, FOR, WHILE, LOOP, LEAVE/ITERATE), variable declaration, condition handlers (SIGNAL ...

Below is a cheat sheet that can be used for configuring SQL Server audit policies to log and detect potentially malicious behavior. It also includes some TSQL cheats for viewing the current audit ...

When you create a SQL Azure server via the SQL Azure portal, you generate a username and password simultaneously. This is your administrative account, which has access to all databases on that server.

A year ago support for nested data types in Excel was announced on the Excel blog, but the announcement didn’t have much detail about what nested data types are and the docs are quite vague too. I was ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...

On this page, you'll find ESXi Monitoring tools as well as Free Tools for VMware, Microsoft. This is one of the best selections of Free Tools for VMware and Microsoft. Monitoring tools for virtual ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...