Coronavirus (COVID-19) Dashboard provides an overview of its impact. The dashboard also includes the total number of cases reported by each country. Data is refreshed automatically. COVID-19 Vaccination Status...
Ashish MehtaDatabase 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...
How to Repair Suspect Database in SQL Server
There can be a possibility that when you connect to an SQL Server Instance you will find the database being marked as SUSPECT. During such scenarios, you will not be able to connect to the database. Steps to Fix...
Chetna BhallaHow to Configure TempDB on Local Disk in SQL Server 2012/2014 Failover Cluster to Improve Performance
Starting SQL Server 2012 Failover Cluster installation supports Local Disk to be used for TempDB Data and Log files. This article explains the steps to be followed by the DBA to configure SQL Server 2012 Failover...
Identify Deadlocks in SQL Server Using Trace Flag 1222 and 1204
This article outlines the steps which one can follow to enable Trace Flag 1222 on SQL Server to capture deadlock information. You can also use Trace Flag 1204 in conjunction with Trace Flag 1222. Difference between...
COVID-19 Dashboard
Coronavirus (COVID-19) Dashboard provides an overview of its impact. The dashboard also includes the total number of cases reported by each country. Data is refreshed automatically. COVID-19 Vaccination Status...
SERVERPROPERTY Function T-SQL Enhancement in SQL Server 2016
SERVERPROPERTY is an inbuilt function which gives you information about the server instance. Learn How To Get SQL Server Info Using SERVERPROPERTY Function in SQL Server. This is Part 10 of 10 Part T-SQL Enhancements in...
How to Use SQL Server Configuration Manager
How to Use SQL Server Configuration Manager to Manage SQL Server Services, Configure Network Protocols, and Network Connectivity Configuration “SQL Server Configuration Manager” is a tool that can be used to...
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...
Display Line Numbers in SQL Server Management Studio (SSMS)
SSMS Show Line Numbers | SSMS Line Numbers This article explains how to enable SSMS show line numbers. SHOW Line Numbers in SQL Server Management Studio As a developer you may have often encounter errors while debugging...
Identify Deadlocks Using Graphical Deadlock Chain Event in SQL Server Profiler
This article explains how to identify deadlocks in SQL Server using graphical deadlock chain event in SQL Server Profiler. We would highly recommend you to read “Identify Deadlocks in SQL Server Using Trace Flag 1222...
How to Change SQL Server Database Auto Growth Settings
Introduction In this article we will go through the steps to change SQL Server Database Auto Growth Settings. It is always a best practice to set an appropriate auto growth setting for all Production database to a...
Different States of SQL Server Database
SQL Server Database can reside in one among the seven states. For example these can be ONLINE, OFFLINE, RESTORING, EMERGENCY, SUSPECT etc. This article explains each of these states and includes a T-SQL code which can...
FILE Backup in SQL Server Step by Step Tutorial with Examples
Using FILE backup one can backup SQL Server Data File individually. While backing up the database you can specify whole of FILEGROUP instead of specifying each database file individually within the FILEGROUP. In case if...
ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server...
Drop Database in SQL Server by Killing Existing Connections
DROP Database SQL Server Let’s learn how to Drop Database in SQL Server when the users are connected to the SQL Server Database. You may find the need to close all the existing database connections in a database...
How to Restore Database in SQL Server?
Summary This article mentions different methods to restore the database in SQL Server from the backup files (.bak files). You can RESTORE a database from a backup file using SQL Server Management Studio (SSMS) or...
Does SQL Server Database Use Any Enterprise Edition Features?
One of the most common tasks performed by the DBA is to moving user databases across different editions of SQL Server especially during Disaster Recovery Situations. There are some Enterprise Edition only features which...
Why Model Database Default Settings Customization is Important for SQL Server?
What is a Model System Database? Model is a system database which is used as a template while creating newer user databases in SQL Server. Why you must make necessary changes to default settings of a Model System...
PARTIAL Backup in SQL Server Step by Step Tutorial with Examples
As per MSDN “PARTIAL Backups are designed for use under SIMPLE recovery model; thereby to improve flexibility to backup very large database which contain one or more read-only Filegroups. They are useful whenever...
How to Detach SSAS Database in SQL Server
This article explains How to Detach Analysis Services Database in SQL Server. The steps mentioned in this article are applicable on SQL Server 2008 and Higher Versions. Different ways to Detach an Analysis Services...
How to Attach SSAS Database in SQL Server
This article explains How to Attach Analysis Services Database in SQL Server. The steps mentioned in this article are applicable on SQL Server 2008 and Higher Versions. Different ways in which an Analysis Services...
