SQL SERVER SELECT Statement | SQL SELECT TABLE | SQL SELECT | SQL QUERY The “SQL SELECT statement” is used to select data from a database. In SQL SERVER, the SELECT Statement is used to query the data stored...
Ashish Kumar MehtaFILEGROUP Backup in SQL Server Step by Step Tutorial with Examples
Using FILEGROUP backup one can backup all the data files within the SQL Server FILEGROUP individually. While backing up the database you can specify whole of FILEGROUP (i.e., PRIMARY or SECONDARY) instead of specifying...
Chetna BhallaHow to Detect Virtual Log Files in SQL Server Transaction Log File
This article demonstrates how to Detect Virtual Log Files in SQL Server Transaction Log File. The steps mentioned in this article are applicable on SQL Server 2005 and higher versions. To know more about how to fix...
Limit SQL Server Error Log File Size in SQL Server
SQL Server Error Log contains valuable information which can be used by database administrators to troubleshoot issues with SQL Server. A typical Error Log file contain informational messages, warnings, critical events...
Download SQL Server 2014 Developer Edition Free
Introduction Download Microsoft SQL Server 2014 Developer Edition for Free for Visual Studio Dev Essentials Members Microsoft has announced that the SQL Server 2014 Developer Edition will available for free to Visual...
Database Backup Encryption in SQL Server 2014 a Step by Step Implementation Guide
Microsoft has introduced inbuilt Database Backup Encryption Feature in SQL Server 2014. Starting SQL Server 2014, SQL Server will have the ability to encrypt the data while the backup is in progress. One can encrypt the...
AUTOGROW_SINGLE_FILE in SQL Server 2016: Syntax & TF 1117 Comparison
Learn how to use AUTOGROW_SINGLE_FILE in SQL Server 2016 to manage database file growth. This guide compares the new T-SQL enhancement to legacy Trace Flag 1117, explaining how to optimize storage while avoiding I/O...
How to Drop Database in SQL Server by Closing Existing Connections
SQL Server DROP Database | SQL DROP Database Statement This article outlines the steps to DROP Database in SQL Server when the users are connected to a SQL Server Database. You may need to closing existing connections...
How to Backup Analysis Services Database in SQL Server Using SQL Server Management Studio
In this article we will take a look at the steps which a database administrator needs to follow to backup an analysis services database. The steps mentioned below are applicable on SQL Server 2005 and higher versions...
How to Fix PowerShell Execution Policy Error in Windows Server
There are instance when you execute your PowerShell scripts on server from your command prompt you will end up seeing below mentioned error message. Error Message File cannot be loaded because the execution of scripts...
SERVERPROPERTY T-SQL Enhancement in SQL Server 2016
Discover the essential SERVERPROPERTY enhancements in SQL Server 2016. In this final part of our 10-part T-SQL series, we show you how to natively track ProductUpdateLevel (CU/SP) and find default file paths without...
How to Identify the Location of Resource Database in SQL Server
In this article we will take a look at how to identify the location of Resource database in SQL Server using a TSQL script. Importance of Resource Database in SQL Server Microsoft initially introduced Resource database...
T-SQL Enhancements in SQL Server 2016 for Developers and DBAs
SQL Server 2016 introduces many new T-SQL features for Developers and Database Administrators. Let us take a look at some of the new T-SQL enhancements in SQL Server 2016 along with relevant examples. This is Part 1 of...
How to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)
Introduction In SQL Server 2008, Microsoft had introduced IntelliSense feature in SQL Server Management Studio (SSMS). As a Developer or as a DBA you may face issues with IntelliSense feature not to be working or not...
MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces MAXDOP for DBCC commands, allowing granular control over CPU usage during consistency checks. Learn how to specify the Maximum Degree of Parallelism for DBCC CHECKDB, CHECKTABLE, and...
How to Change SQL Server Login Properties to Enforce Password Policies and Expiration Settings
How to set SQL Server Password Policy | Set SQL Password Policy This article demonstrates the steps to create an SQL Server Login which enforces password policies and password expiration policies. Let us start by...
Modernizing Database Backups: The SQL Server 2025 Zstandard (ZSTD) Backup Compression Revolution
SQL Server 2025 introduces Meta’s Zstandard (ZSTD) algorithm, revolutionizing backup strategies. This guide explores how ZSTD outperforms traditional MS_GZRY, providing the T-SQL configurations and architectural...
