MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter























Latest SQL Server Tips














SQL Server Management Studio Articles and Tips




Why it is Important to Customize Model Database Default Settings in SQL Server

In this tip, we will take a look at few of the very importance customizations which a DBA must do for a Model System Database so that all the newly created databases on the SQL Server Instance have better configuration that the default database settings.

How to Fix 'Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib)' error in SQL Server

Learn How to Fix 'Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib)' error in SQL Server

How to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)

Learn How to Enable and Refresh IntelliSense Feature in SQL Server Management Studio (SSMS).

Performance Dashboard Reports in SQL Server 2012

Performance Dashboard Reports are Custom SQL Server Reporting Services Report which Microsoft has developed for Database Administrators to get a quick overview of the overall performance of an Instance of SQL Server 2012.

Become an Expert DBA: SQL Server Database Backup Options and Commands a Step by Step Tutorial with Examples

This tutorial will give you compressive information on different database backup options which is available to a DBA or a Developer within SQL Server. The detailed topics mentioned in this tutorial will help you understand database backups in depth whether you are new to SQL Server or an Expert.

How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio

Starting SQL Server 2008, SSMS allows you to Select Top 1000 rows and Edit Top 200 rows. However in previous version of SSMS 2005 the only option was to open the entire table. Let us see how to alter select top 1000 rows and edit top 200 rows default value in SSMS.

Reset SSMS Keyboard Shortcuts in SQL Server 2012

SQL Server Management Studio (SSMS) keyboard shortcuts may stop working once you have installed SQL Server 2014 on the server which had an instance of SQL Server 2012 installed already. This tip will guide you how to Reset SSMS Keyboard Shortcuts in SQL Server 2012 Instance.

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 how to enable Line Number feature in SQL Server Management Studio (SSMS).

How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio

Starting SQL Server 2008, SSMS allows you to Select Top 1000 rows and Edit Top 200 rows. However in previous version of SSMS 2005 the only option was to open the entire table. Let us see how to alter select top 1000 rows and edit top 200 rows default value in SSMS.

How to Change Database Auto Growth Settings in SQL Server Using SSMS

It is always a best practice to set an appropriate auto growth setting for all Production database to a handle unexpected database growth which can be due to unexpected data load or due to the disk space requirements to perform maintenance tasks. This article discusses How to Change Database Auto Growth Settings in SQL Server Using SSMS.

How to Drop Database in SQL Server by Closing Existing Connections

In this article we will take a look at how to Drop Database in SQL Server when the users are connected to a SQL Server Database. You may need to closing existing connections in a database before restoring the database, before detaching database, get database in SINGLE_USER mode etc.

How to Use Dedicated Administrator Connection in SQL Server

This one very important feature which DBA’s must consider enabling it across all servers which they manage. This feature can help you troubleshoot issue rather than just restarting SQL Services or rebooting servers remotely.

How to Configure PAGE_VERIFY Option as CHECKSUM for all Databases in a SQL Server Instance

Using the PAGE_VERIFY CHECKSUM database option you can provide the most robust detection of database consistency problems caused by the system I/O path. If you use the PAGE VERIFY CHECKSUM option for a database, when SQL Server detects a page has been altered after it has been written to disk, SQL Server reports Msg 824 after reading the page back from disk.

Download Free White Paper: How to Become a SQL Server Database Administrator


The hard part about becoming a DBA is getting the first job. No hiring manager wants to give a user with no track record the keys to the most valuable thing the company owns – the data. A single mistake by a DBA can cause an outage or loss of data that can result in loss of revenue or in the worst case the failure of the company. If you want to become a DBA you have to be ready for that opportunity by building skills above and beyond those you use at work – you need to learn the basic skills of a DBA. There is so much to learn; how do you decide what to learn first?



Different Ways to Enable Dedicated Administrator Connection in SQL Server

Microsoft introduced Dedicated Administrator Connection (DAC) feature in SQL Server 2005. Using DAC feature a database administrator can connect to an SQL Server Instance when SQL Server stops responding to normal connections. During such scenarios using DAC feature a DBA can connect to the instance to troubleshoot and kill processes which are causing issues.

How to Fix Index cannot be reorganized because page level locking is disabled error in SQL Server

This article explains how to fix Index cannot be reorganized because page level locking is disabled error in SQL Server.

How to Identify Currently Used SQL Server Authentication Mode

In this article we will take a look at how you can verify the currently used authentication mode and how to change the authentication mode using TSQL and SQL Server Management Studio.

How to Migrate Existing Database to Partially Contained Database in SQL Server

SQL Server 2012 introduced a new feature namely Contained Databases. In this article we will learn the steps which a DBA needs to follow to Migrate an Existing Database to Partially Contained Database in SQL Server.

How to Configure Network Drive to be Visible for SSMS to Perform Database Backup and Restore?

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 option will be to store the database backup files in a mapped network drive and perform the database restores from the mapped drive. However, things can become really complicated when the developer tries to restore the database using SSMS. This article explains how to achieve this with a simple trick.



Lets be Connected...




Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips