Knowledge Base
Search Results ...
Using SQL Server Resource Governor for Workload Isolation
The SQL Server Resource Governor is a feature that enables you to manage SQL Server workload and system resource consumption. Its primary function is resource allocation and isolation. This tool is especially beneficial in a multi-tenant environment where[.....]
Handling Multi-Tenant Data Models in SQL Server
Managing multi-tenant data in SQL Server can present a unique set of challenges. Multi-tenant data models are used when a single instance of a software application serves multiple customers, also known as tenants. Each tenant's data is isolated and remains[.....]
SQL Server 2019: Big Data Clusters Introduction
The release of SQL Server 2019 has brought about a substantial shift in the way we handle big data. With the introduction of Big Data Clusters (BDC), SQL Server 2019 provides a complete AI and big data solution. The BDC feature facilitates the deployment o[.....]
Using TVPs (Table-Valued Parameters) in SQL Server
Table-Valued Parameters (TVPs) are a powerful feature in SQL Server that allow developers to pass sets of data to stored procedures and functions. Before the introduction of TVPs in SQL Server 2008, developers had to resort to complex workarounds, such as[.....]
SQL Server Extended Events vs Profiler
In the world of SQL Server, the decision between using SQL Server Profiler and SQL Server Extended Events is a critical one. While both tools provide profound insights into your database's performance, they differ significantly in their capabilities and us[.....]
Dynamic Data Masking for SQL Server Security
Dynamic Data Masking (DDM) is a security feature that Microsoft introduced with SQL Server 2016. It is designed to limit the exposure of sensitive data to non-privileged users by masking it. DDM is a policy-based security feature that hides the sensitive d[.....]
Using OPENJSON to Shred JSON in SQL Server 2016+
With the increasing popularity of JSON (JavaScript Object Notation) as a data interchange format, SQL Server 2016 introduced built-in support for JSON to efficiently deal with JSON data. One of these features is OPENJSON, a table-valued function that parse[.....]
Understanding SQL Server Auto Stats Behavior
In the world of database management systems, understanding how systems optimize performance is key to maintaining efficient operations. One of the key features of SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and Azure SQL that assists in performa[.....]
Temporal Tables for Change Tracking in SQL Server
SQL Server 2016 introduced Temporal Tables, a game-changing feature for tracking historical data changes. Temporal tables, also known as system-versioned tables, keep a full history of data changes and allow easy point-in-time analysis. This is an essentia[.....]
Using TRY_CONVERT in SQL Server for Safer Casting
SQL Server is a highly robust and versatile database management system, employed by businesses of all sizes across the globe. One of the functionalities that sets it apart is its ability to handle data conversion errors more gracefully. In this blog post,[.....]