Knowledge Base
Search Results ...
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,[.....]
Managing SQL Server Logins Across Environments
Managing SQL Server logins across different environments can be a challenging task. The environments can range from on-premise SQL Server instances to cloud-based platforms like Azure SQL. One of the critical aspects of managing SQL Server logins is ensuri[.....]
Implementing Service Accounts for SQL Server Security
SQL Server is a popular relational database management system, and its security should not be taken lightly. One of the best practices to ensure the security of your SQL Server is by implementing service accounts. In this blog post, we will provide a detai[.....]
SQL Server Cluster Configuration on Windows Server 2016
SQL Server cluster configuration is a crucial step for any organization that depends on SQL Server for data management. In this blog post, we will guide you through the process of setting up a SQL Server cluster on Windows Server 2016. We will be focusing[.....]
SQL Server Always On High Availability Setup Guide
In the world of databases, ensuring high availability and data resilience is paramount. One of the key technologies that can help achieve this is SQL Server Always On. Introduced in SQL Server 2012 and improved in subsequent versions, Always On provides a[.....]
Security Best Practices for SQL Server 2017 Note from the Data Whisperer
In the fast-paced world of technology, data security is a top priority. With the ever-increasing amount of data being handled, SQL Server 2017 has become a preferred choice for database management systems (DBMS). This post will focus on security best pract[.....]
Monitoring SQL Server Using Extended Events
SQL Server Extended Events, a lightweight performance monitoring system, allows database administrators to collect as much or as little data as needed to troubleshoot issues without impacting the performance of the server. Introduced in SQL Server 2008, Ex[.....]