SQL Server 2022 (16.x) enables integrated offloading and acceleration with Intel® QuickAssist Technology (QAT). You can offload backup compression with Intel® QAT to reduce CPU usage, backup completion times, and reduce storage consumption. To back up or restore databases with … Continue reading Improve Performance by configuring Integrated acceleration and offloading with Intel® QuickAssist Technology (QAT) for SQL Server 2022

Hi everyone, Hope you are doing well and great time using the MS SQL Server! I have recently found this new brilliant utility, it quickly will become a really nice tiny tool in your toolbox! The go-sqlcmd utility lets you … Continue reading go-sqlcmd

Hi friends! I came back with a quick script post! One of the initial configurations which every DBA should set up is the max degree of parallelism or MaxDop. Microsoft has a clean recommendation table in this article that shows … Continue reading A Script to get Max Recommended Value for MaxDOP

This is not included when installing the new SQL Server 2022 CTP 2.0 and SSMS preview. We should download the new ODBC 18 and OLE DB 19 drivers. Prerequisite SQL Server 2022 ODBC or OLE DB Driver for SQL Server … Continue reading Connect to SQL Server 2022 with strict encryption

  SQL Server 2022 (16.x) Preview deprecates: Distributed Replay Machine Learning server Query deprecated features: Source: Deprecated database engine features in SQL Server 2022 – SQL Server 2022 | Microsoft Docs Continue reading SQL Server 2022 Deprecated Features

To download the latest version of SQL Server Management Studio (SSMS) 19 use the following URL: SQL Server Management Studio (SSMS) 19 (Preview) SSMS 19 Preview 2 is the latest preview. Release number: 19.0 (Preview 2) Build number: 16.0.19056.0 Release … Continue reading SSMS 19 Preview 2