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...
Chetna BhallaSQL Server FULL Recovery Model Step by Step Tutorial with Examples
Tutorials: SQL Server Database Backup Options > Next Topic: BULK-LOGGED Recovery Model Page 4 / 16 Introduction In Full Recovery Model Point in Time recovery of the database is possible as long as you have all the...
Convert Seconds to Minutes, Hours and Days in SQL Server
Introduction The TSQL script mentioned in this article can be used to Convert Seconds to Minutes, Hours and Days in SQL Server. /* Example: Where Time Is Given In Seconds Output: In “Day(s) : Hour(s) : Minute(s) :...
SQL Server Best Practice Auto Close Database Option Should Remain OFF
Introduction In this article, we will take a look at why it is essential to leave AUTO CLOSE database option turned OFF for a Production or a Non-Production SQL Server Database across all versions and editions of SQL...
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...
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...
Ashish MehtaHow 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.
How to Verify and Register SPN for SQL Server Authentication with Kerberos Connections
Introduction This article explains how to verify and register Service Principal Names (SPN) for SQL Server Authentication with Kerberos Connections. Kerberos Authentication is a widely accepted network authentication...
Fix Cannot open user default database. Login failed. Login failed for user SQL Server Error
Introduction In this article we will take a look at the steps which you need to follow when you receive “Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error:...
SQL Server SIMPLE Recovery Model Step by Step Tutorial with Examples
Introduction SIMPLE recovery model as the name suggests it is the most basic recovery model which is available in SQL Server. In this recovery model every transaction is written to the transactional log file and once...
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...
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...
How to Repair Suspect Database in SQL Server | DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS | Repair Suspect Database
Introduction 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. In this...
How to Enable & Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
Introduction In this tip we will take a look at the step to follow to enable or disable XP_CMDSHELL using SP_CONFIGURE system stored procedure. In order to use XP_CMDSHELL you need to be a system administrator. Read the...
Display Line Numbers in SQL Server Management Studio (SSMS)
As a developer you may have often encounter errors while debugging TSQL code. SQL Server will show you an error message referencing you to a particular line number where the syntax error has occurred. This tip explains...
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...
SQL Server: How to Find which user deleted the database in SQL Server
Introduction In this article we will take a look at the steps which you can follow to quickly identify the user who deleted the user database in SQL Server. There are two different methods by which one can easily find...
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...
Different SQL Server Recovery Models Step by Step Tutorial with Examples
Introduction Recovery Models in SQL Server are basically designed to control the transaction log maintenance and to help you recover your data from a disaster. Based on the choice of Recovery Model, SQL Server decides...
Identify Deadlocks in SQL Server Using Trace Flag 1222 and 1204
Introduction 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...
2 Signs you need to migrate to SharePoint 2016 and how to nail the upgrade
Reasons to Migrate to SharePoint 2016? Debates on migrating SharePoint solutions to its 2016 version started even before the version was officially released. All the stir is basically about the assertive promotion of...
