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. Coronovirus Case Reported by Each...
Ashish MehtaCOPY_ONLY Backup in SQL Server Step by Step Tutorial with Examples
COPY_ONLY backup is a special type of SQL Server Backup which is independent of the sequence of conventional SQL Server backups. Normally whenever you take a backup it will affect how later backups are restored...
Chetna BhallaWhere can I find SQL Server Management Studio for SQL Server 2016?
After the successfully installation of SQL Server 2016, I have realized that SQL Server Management Studio 2016 (SSMS) is missing. In this tip we will discuss how to download and install SQL Server Management Studio for...
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...
How to Restore 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 restore an analysis services database. The steps mentioned below are applicable on SQL Server 2005 and higher versions...
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...
COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new system functions namely COMPRESS and DECOMPRESS. This is Part 7 of 10 Part T-SQL Enhancements in SQL Server 2016 for Developers and DBAs. Click here to read it from the beginning…...
TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
It is a well known fact that TRUNCATE TABLE is faster than DELETE statement. TRUNCATE TABLE uses lesser system resources and transaction log file when compared to a DELETE statement. This is Part 2 of 10 Part T-SQL...
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...
SQL Server Database Backup Tutorial with Examples
Introduction It is very critical for any organization to protect its data within the database. Hence it is must for an organization to perform database backups at regular intervals. In this tutorial, you will learn...
Troubleshooting SQL Server blocked access to procedure sp_send_dbmail
Troubleshooting SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this...
MIRRORED Backup in SQL Server Step by Step Tutorial with Examples
Using MIRRORED Backup feature a DBA can create up to 3 identical copies of a database backup. This feature is available in SQL Server 2005 Enterprise Edition and later versions. This is Part 12 of 16 Part SQL Server...
How to Automate Backup of Analysis Services Database Using SQL Server Agent Job
In this article we will take a look at how to create an SQL Server Agent Job to backup an Analysis Services Database. However, read the following article to know the steps you need to follow to restore a database in SQL...
FULL Database Backups in SQL Server Step by Step Tutorial with Examples
FULL database backup is used to back up the whole database in SQL Server. A full database backup will include parts of transaction log so that if the need arises a database can be recovered completely by restoring full...
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...
ALTER DATABASE SET AUTOGROW_SINGLE_FILE 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...
Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server
You may end up getting “The remote procedure call failed. [0x800706be] WMI Error“ when you click SQL Server Services in SQL Server Configuration Manager as shown in the snippet below. This article explains the steps to...
Mi Watch Launched, offers Heart rate monitoring, Blood oxygen sensor, Dual SIM Support via eSIM, Powerful 570 mAh Battery
Xiaomi has officially launched Mi Watch on November 5, 2019, in China. The smart watch comes in two colors Elegant Black and Technology. The smart watch is loaded with excellent features and is priced at CNY 1299...
FILEGROUP 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...
Different Ways to Find Default Trace Location in SQL Server
How to Find SQL Server Default Trace Location Starting SQL Server 2005, Microsoft introduced a light weight trace which is always running by default on every SQL Server Instance. The trace will give very valuable...
TRANSACTION LOG Backups in SQL Server Step by Step Tutorial with Examples
Transaction log backup is only possible when your database is in FULL or BULK-LOGGED recovery model. With the help of Transaction Log backup one can achieve Point in Time recovery for the database in case of any...
SQL Server SELECT DISTINCT Clause T-SQL Tutorial with Examples
The SELECT DISTINCT Clause is used to fetch distinct values in a specific column of a given table. This is Part 3 of 40 Part SQL Server T-SQL Tutorial. Click here to read it from the beginning…. SELECT DISTINCT Syntax...
