Category: MSSQL

How To Check the Compatibility Level of Databases Using Policy Based Management

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we

Change Data Capture (CDC) is a technology that can be used in incremental data transfers from OLTP systems to data

The Backup Compression feature was introduced with SQL Server 2008. We can reduce our backup sizes by selecting this option

With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable

With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table

The Query Store is a feature that introduced in SQL Server 2016. In order to understand the Query Store, it

Database Engine Tuning Advisor (DTA) examines how queries are running in the database and provides us with suggestions. It has

With SQL Server 2008, we can now easily uninstall Service Packs and Cumulative Updates from Control Panel, Programs and Features.

With BULK INSERT you can upload text, csv data files to the database in any format. Users must have insert

With OPENROWSET, you can access remote data using OLE DB. OPENROWSET is a system function as you will see below.