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 MehtaSQL 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...
Chetna BhallaDifferent Types of SQL Server Backups
SQL Server supports different types of backups for databases. However, which type of a database backup can be performed totally depends upon the recovery model of the database one choose. If you are unclear of the...
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...
How to Synchronize Analysis Services Database Using Synchronize Database Wizard in SSMS
In this article we will take a look at how to Synchronize Analysis Services Database using Synchronize Database Wizard to make two analysis services databases identical by copying the metadata and data between source...
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...
SQL Server: How to Start SQL Server with Minimal Configuration
Introduction There can be certain scenarios when SQL Server is not starting because of configuration problems. During such scenarios one need to start an instance of SQL Server by using minimal configuration...
How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio
Introduction Starting SQL Server 2008, SSMS allows you to Select Top 1000 rows and Edit Top 200 rows. However, in the previous version of SSMS 2005, the only option was to open the entire table. Let us see how to alter...
How to Fix Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib) error in SQL Server
Introduction Database Administrators often need to get involved in code deployments wherein they release new code from one environment to another. As a best practice it is highly recommended to note down issues faced...
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...
How to Backup and Restore Resource Database in SQL Server
Microsoft SQL Server 2005 introduced a new system database namely Resource database. It’s a read-only system database which is hidden from users and in this article we will discuss how to backup and restore Resource...
How to Get SQL Server Instance Information
In this article we will take a look at different ways in which a DBA or a Developer can Retrieve System and SQL Server Information. The method mentioned is applicable for SQL Server 2005 and all higher versions. Below...
Improved Startup Parameters in SQL Server 2012
Microsoft has improved the configuration of startup parameters in SQL Server 2012 and it is much simpler and easier. In this article we will take a look at the steps to add a Trace Flag 1222 to identify deadlocks in SQL...
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 Monitor Transaction Log File Usage in SQL Server
As a Best Practice database administrator should always monitor the space usage within the SQL Server Transaction Log file. This will help you quickly understand how much space the Transaction Log file is using during...
How to Export records from SQL Server to Text File using BCP Command
Introduction Is there a quick way to export records from SQL Server to text file? In this tip we will take a look at an example to export records from SQL Server to text file using BCP. In this tip we will learn how to...
Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS
Introduction Most of the Development and Test Database Servers will not have enough disk space to store both the database and backup files in order to perform the periodic database refreshes. In such scenarios, the best...
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 Move TempDB to New Drive in SQL Server
There are times when as a DBA you find the need to move TempDB Data and Log Files to a new Drive. This article explains all the steps you need to follow to move TempDB files.
Download SQL Server 2016 Developer Edition for Free
Introduction Microsoft announced the release of the Release to Manufacturing (RTM) version of SQL Server 2016 on June 1, 2016. The good news is that you can download SQL Server 2016 Developer Edition for Free. Different...
How to Change SQL Server Login Properties to Enforce Password Policies and Expiration Settings
This article demonstrates the steps to create an SQL Server Login which enforces password policies and password expiration policies. Let us start by creating a new SQL Server Login. 1. Using SQL Server Management...
How to Restore Database in SQL Server
How to Restore Full Database Backup in SQL Server This article explains the steps you need to follow to restore a Full Database Backup in SQL Server Using SQL Server Management Studio and by using TSQL Script...
