Introduction There can be certain scenarios when one needs to connect to an SQL Server Instance in a Single User Mode by using the Startup Option -m. For example, the need could be to recover a damaged system database...
Category - SQL Server Tips
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...
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 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...
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...
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...
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) :...
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 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...