MyTechMantra.com
Connect With MyTechMantra.com

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






























Microsoft SQL Server Articles, Tutorials, News, Tips & Tricks




SQL Server 2014 Build List

In this article we have compiled an exhaustive list of all the security patches, cumulative updates and service packs for SQL Server 2014 Build List released by Microsoft.

Monitoring Transactional Log File Space Utilization in SQL Server

This article explains How to Monitor SQL Server Database Transactional Log File Space Usage over a period of time and How to Identify the growth pattern for every database over a stipulated period of time to troubleshoot sudden growth spurts recorded for Transaction Log files in SQL Server.

Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS

This article explains How to Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS

How to Configure TempDB on Local Disk in SQL Server 2012 Failover Cluster to Improve Performance

Starting SQL Server 2012 Failover Cluster installation supports Local Disk to be used for TempDB Data and Log files. This article explains the steps to be followed by the DBA to configure SQL Server 2012 Failover Cluster to use Local Disk for TempDB Data and Log Files.

How to Deny Access to Specific DMVs in SQL Server for Users who have VIEW SERVER STATE Permissions

This tip explains How to Deny Access to Specific DMVs in SQL Server for users to whom you have Granted VIEW SERVER STATE Permissions.

Display Line Numbers in SQL Server Management Studio (SSMS)

This tip explains how to enable Line Number feature in SQL Server Management Studio (SSMS).


Backup and Restore Resource Database in SQL Server

Resource database is a read-only system database which is hidden from users. System objects such as sys.objects are physically stored in Resource Database which appears logically in the SYS schema of each database. This article explains Importance of Resource Database, how to identify the location of Resource Database in all SQL Server Versions and How to Backup and Restore Resource Database in SQL Server.

Using SP_CONFIGURE Enable or Disable BACKUP CHECKSUM DEFAULT Configuration Option in SQL Server 2014

This article explains the steps to enable or disable BACKUP CHECKSUM default configuration option using sp_configure at instance level in SQL Server 2014.

Enable BACKUP CHECKSUM in SQL Server Using Trace Flag 3023

This article explains the steps to enable or disable BACKUP CHECKSUM default configuration option using Trace Flag at instance level in SQL Server 2005 and higher versions.

How to Enable Database Users in SQL Server

This article explains how to enable database users in SQL Server when they are disabled accidently.

Steps to Connect to SQL Server When all System Administrators are Locked Out

SQL Server Security is one of the key responsibilities of a Database Administrator. However, there can be scenarios when a DBA will be asked to manage SQL Server which doesn’t have any valid System Administrator or SA Accounts. This article explains the steps to follow to add a new login with SA privileges

Setting PAGE_VERIFY Database Option to CHECKSUM for all Databases in SQL Server

This article explains why it is important to set PAGE_VERIFY Database Option to CHECKSUM for all databases in SQL Server. When CHECKSUM is used as PAGE_VERIFY option for a database it helps in detecting database consistency problems with the system I/O path and provides a high level of data-file integrity.

Identify Database Properties Using DBCC CHECKPRIMARYFILE Undocumented DBCC Command

DBCC CHECKPRIMARYFILE is one among the many undocumented SQL Server DBCC Command. Using this DBCC Command a Database Administrator can Identify Database Properties such as Database Name, FileName, Version and Collation etc.

How to Increase Number of SQL Server Error Log Files

This article explains how to increase the number of SQL Server Error Logs from the default value of six.

How to Recycle SQL Server Error Log file without restarting SQL Server Service

This article explains how to recycle SQL Server Error Log file without restarting SQL Server Service.



Share this Article





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



Latest SQL Server Tips