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.
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.
This article explains How to Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS
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.
This tip explains How to Deny Access to Specific DMVs in SQL Server for users to whom you have Granted VIEW SERVER STATE Permissions.
This tip explains how to enable Line Number feature in SQL Server Management Studio (SSMS).
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.
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.
This article explains how to enable database users in SQL Server when they are disabled accidently.
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
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.
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.
This article explains how to increase the number of SQL Server Error Logs from the default value of six.
This article explains how to recycle SQL Server Error Log file without restarting SQL Server Service.
|Latest SQL Server Tips|