Knowledge Base
Search Results ...
SQL Server Contained Users and Cross-Database Access Note from the Data Whisperer
Welcome to SQLSupport.org, your trusted resource for all things SQL. The Data Whisperer is back with another insightful post. This time, we're delving into the realm of SQL Server Contained Users and Cross-Database Access. If you've worked with SQL Server[.....]
SQL Server Transparent Data Encryption Monitoring
As the world continues to generate more data, the importance of data security has never been greater. One key aspect of data security is encryption, which protects your data by converting it into an unreadable format. SQL Server 2022, Azure SQL, Microsoft[.....]
SQL Server 2022: T-SQL Enhancements Overview
The year 2022 marked a significant leap in the SQL Server platform with the introduction of several T-SQL enhancements. These enhancements were aimed at increasing the efficiency, scalability, and reliability of data operations. In this blog post, we will[.....]
SQL Server JSON Data Types in Modern Applications
The rise of modern applications has brought about an evolution in the way we handle data. JSON, due to its versatility and compatibility with JavaScript, has become a popular choice for data interchange. With SQL Server 2022, Microsoft has introduced JSON[.....]
SQL Server and Azure Blob Storage for Backups
With the advent of cloud technologies and big data, the role of the database administrator has evolved. Today, managing databases involves more than just ensuring optimal performance and data integrity. It also includes leveraging cloud storage solutions t[.....]
SQL Server 2022: Data Virtualization with External Sources Note from the Data Whisperer
The advent of SQL Server 2022 has ushered in a new era of data management capabilities, providing businesses with the tools needed to integrate and analyze data from various sources. One such feature that has particularly piqued the interest of data profes[.....]
SQL Server 2022: Ledger Tables for Tamper Detection
Welcome to the latest blog post for SQLSupport.org. Today, we'll be diving into one of the most exciting features offered by SQL Server 2022: Ledger Tables for Tamper Detection. Ledger Tables are a revolutionary feature in SQL Server 2022, enabling busines[.....]
SQL Server Role Membership Audits with PowerShell
In the era of data-driven decision making, ensuring the integrity and security of your databases is paramount. One key aspect of database security is role membership audits, which allow you to monitor and control who has access to what within your SQL Serv[.....]
SQL Server External Tables with Azure Blob Storage
In the ever-evolving world of data storage and management, one cannot underestimate the importance of SQL Server External Tables and Azure Blob Storage. With SQL Server 2022, Azure SQL, Microsoft Fabric, Delta Lake, OpenAI + SQL, and Databricks, we can cre[.....]
SQL Server 2022: Query Store Hints and Performance Tuning
The SQL Server 2022 has brought significant improvements and new features that enhance query performance and developer productivity. One such feature is the Query Store Hints, a much-awaited addition that allows developers to optimize their queries for bet[.....]