Free SQL Server Article, News, Forums etc. http://www.myTechMantra.com/LearnSQLServer/Index.html Learn the pros and cons of migrating your SharePoint solution to SharePoint 2016 and essential steps that determine the success of your migration project. http://www.mytechmantra.com/SQL-Server/2-signs-you-need-to-migrate-to-SharePoint-2016-and-how-to-nail-the-upgrade/ After the successfully installation of SQL Server 2016, I have realized that SQL Server Management Studio 2016 (SSMS) is missing. In this tip we will discuss how to download and install SQL Server Management Studio for SQL Server 2016. http://www.mytechmantra.com/SQL-Server/Where-can-I-find-SQL-Server-Management-Studio-for-SQL-Server-2016/ Microsoft has introduced a new sample database WideWorldImporters specifically for SQL Server 2016. In this article we will explore how to download and restore SQL Server 2016 WideWorldImporters and WideWorldImportersDW Sample Database. http://www.mytechmantra.com/SQL-Server/Download-and-Restore-SQL-Server-2016-WideWorldImporters-Sample-Database/ Top 10 Trending SQL Server Tips on MyTechMantra.com for SQL Server DBAs, Developers and BI Professionals http://www.mytechmantra.com/SQL-Server/Trending-SQL-Server-Tips/ Microsoft has 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 editions of SQL Server 2016 which are available are Enterprise, Standard, Web, Developer and Express Edition. http://www.mytechmantra.com/SQL-Server/Download-SQL-Server-2016-Developer-Edition-for-Free/ SQL Server 2016 introduces many new T-SQL features for Developers and Database Administrators. In this tutorial we will take a look at some of the new T-SQL enhancements in SQL Server 2016 along with relevant examples. http://www.mytechmantra.com/SQL-Server/New-Features-in-SQL-Server-2016-for-Developers-and-DBAs/ Starting SQL Server 2016, Microsoft has introduced a new clause TRUNCATE TABLE WITH PARTITIONS which can be used to truncate all rows available within a partition. http://www.mytechmantra.com/SQL-Server/TRUNCATE-TABLE-WITH-PARTITIONS-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 introduces a new DROP IF EXISTS statement to DROP objects such as tables, columns, indexes, stored procedures, schemas, triggers and user-defined functions. DROP IF EXISTS statement can be used to check whether the object exists before it is dropped or removed from the database. http://www.mytechmantra.com/SQL-Server/DROP-IF-EXISTS-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 introduces an interesting T-SQL enhancement to improve performance and reduce downtime ALTER TABLE WITH (ONLINE = ON | OFF). This statement will help you alter data types, change column/table collation values, change nullability settings, change column length, and many other options while the table remains online for user connectivity. http://www.mytechmantra.com/SQL-Server/ALTER-TABLE-WITH-(ONLINE=ON-OFF)-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 brings MAXDOP settings, for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP command. Database Administrators can leverage MAXDOP settings to above mentioned DBCC commands to achieve Max Degree of Parallelism. http://www.mytechmantra.com/SQL-Server/MAXDOP-for-DBCC-CHECKDB-DBCC-CHECKTABLE-and-DBCC-CHECKFILEGROUP-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server to achieve similar functionality you could use the trace flag 1117. This would allow all the files of the database to auto grow at the same time if they are configured files to auto grow. http://www.mytechmantra.com/SQL-Server/ALTER-DATABASE-SET-AUTOGROW_SINGLE_FILE-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server to achieve similar functionality you could use the trace flag 1117. This would allow all the files of the database to auto grow at the same time if they are configured files to auto grow. http://www.mytechmantra.com/SQL-Server/ALTER-DATABASE-SET-AUTOGROW_ALL_FILES-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 introduces two new string functions namely STRING_SPLIT and STRING_ESCAPE.. http://www.mytechmantra.com/SQL-Server/COMPRESS-and-DECOMPRESS-T-SQL-Enhancement-in-SQL-Server-2016/ SQL Server 2016 introduces two new system functions namely COMPRESS and DEOMPRESS. http://www.mytechmantra.com/SQL-Server/STRING_SPLIT-and-STRING_ESCAPE-T-SQL-Enhancement-in-SQL-Server-2016/ FORMATMESSAGE statement is enhanced in SQL Server 2016 to accept a msg_string argument. In the previous versions this function was used to form a message from text located in sys.messages. http://www.mytechmantra.com/SQL-Server/FORMATMESSAGE-T-SQL-Enhancement-in-SQL-Server-2016/ SERVERPROPERTY is an inbuilt function which gives you information about the server instance. http://www.mytechmantra.com/SQL-Server/SERVERPROPERTY-T-SQL-Enhancement-in-SQL-Server-2016/ 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. http://www.MyTechMantra.com/SQL-Server/Why-it-is-Important-to-Customize-Model-Database-Default-Settings-in-SQL-Server/ 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. In this article we will take a look at steps which one needs to follow to start SQL Server with Minimal Configuration to troubleshoot SQL Server configuration issues. http://www.mytechmantra.com/LearnSQLServer/How-to-Start-SQL-Server-with-Minimal-Configuration/ 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 such as Master, Model, MSDB etc or you may want to change the server configuration options. In this article we will take a look at steps which one needs to follow to Start SQL Server in Single User Mode. http://www.mytechmantra.com/LearnSQLServer/How-to-Start-SQL-Server-in-Single-User-Mode/ SQL Server Database Engine defines the size of virtual log files dynamically while creating or extending transactional log files in SQL Server. Virtual log files will not have a fixed size and one cannot predict the number of VLFs within the transactional log file. Internally, SQL Server will always try to maintain a smaller number of VLFs. However, there is no way for a database administrator to configure or set a fixed size for VLFs in SQL Server. http://www.mytechmantra.com/LearnSQLServer/What-are-Virtual-Log-Files-in-SQL-Server-Transaction-Log-File/ SQL Server Database Engine supports different startup options for SQL Server Database Engine Service. A database administrator can set the startup options very easily using SQL Server Configuration Manager. In this article we will explore startup options available in SQL Server Database Engine in detail. http://www.mytechmantra.com/LearnSQLServer/Different-Startup-Options-for-SQL-Server-Database-Engine-Service/ This article demonstrates the steps that one needs to follow to start SQL Server without TempDB database or with minimal configuration. http://www.MyTechMantra.com/LearnSQLServer/How-to-Start-SQL-Server-without-TempDB-Database-or-with-Minimal-Configuration/ There are often times when as a DBA you need to quickly retrieve SQL Server Configuration Details for a SQL Server Instance. In this article we will explore different ways to retrieve SQL Server configuration details using TSQL queries. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Different-Ways-to-Retrieve-SQL-Server-Configuration-Details/ 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. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Find-which-user-deleted-the-database-in-SQL-Server/ In this tip we will take a look at how to identify and fix sudden surge of transaction log file especially when a database is configured for Snapshot Replication. http://www.mytechmantra.com/LearnSQLServer/Reasons-behind-Large-Transaction-Log-File-Size-when-database-is-configured-for-Snapshot-Replication/ List of SQL Server Replication Articles and Tips which can help DBAs and Developers. http://www.mytechmantra.com/SQL-Server-Replication-Articles-And-Tips/ In this tip we will take a look at different ways to find the location of default trace file in SQL Server and how to enable or disable default trace file in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Different-Ways-to-Find-Default-Trace-Location-in-SQL-Server/ Disabling an Index in SQL Server is a very useful feature which will help you identify whether the index is really useful or not without actually dropping the index. http://mytechmantra.com/LearnSQLServer/Different-Ways-to-Disable-an-Index-in-SQL-Server/ This article demonstrates how to enable an index in SQL Server. It is a very useful feature which will help you enable an index which was disabled earlier to check whether the index was really useful or not without actually dropping the index. http://mytechmantra.com/LearnSQLServer/Different-Ways-to-Enable-an-Index-in-SQL-Server/ Helpful SQL Server Indexing Tips, Articles, Tutorials, How-to's, Scripts, White Papers and much more for SQL Server DBAs and Developers to Improve the Performance of SQL Server Database across your organization. http://www.mytechmantra.com/SQL-Server-Indexing-Articles-And-Tips/ Microsoft has announced that the SQL Server 2014 Developer Edition will available for free to Visual Studio Dev Essentials members. This article explains how to register and then download SQL Server 2014 Developer Edition for FREE. http://mytechmantra.com/SQL-Server-News/Download-SQL-Server-2014-Developer-Edition-for-Free/ This article explains why it is important 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 Server. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Best-Practice-Auto-Close-Database-Option-Should-Remain-OFF/ This article outlines some of the major database backup and restore enhancements which is available in SQL Server 2014. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-2014-Backup-and-Restore-Enhancements/ This tip demonstrates how to use System Configuration Checker Tool (SCC) to identify potential issues which one can encounter before even installing SQL Server on any new or existing server. http://www.mytechmantra.com/LearnSQLServer/Using-System-Configuration-Checker-Identify-Potential-Issues-before-Installing-SQL-Server/ In this article we will take a look at how to install and use SQL Server Discovery Tool to discover all the SQL Server Components which are already installed on a local server. http://www.mytechmantra.com/LearnSQLServer/Discover-SQL-Server-Components-Installed-Using-SQL-Server-Discovery-Tool/ Learn How to Fix 'Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib)' error in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Fix-Cannot-execute-script-insufficient-memory-to-continue-the-execution-of-the-program-(mscorlib)-error-in-SQL-Server/ 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. http://www.mytechmantra.com/LearnSQLServer/Change-Select-Top-1000-Rows-and-Edit-Top-200-Rows-Default-Value-in-SSMS/ In this tip we will take a look at the steps you can follow to quickly enable and refresh IntelliSence in SSMS to resolve this issue of IntelliSense not displaying latest schema changes. http://www.mytechmantra.com/LearnSQLServer/How-to-Enable-and-Refresh-IntelliSense-in-SQL-Server-Management-Studio/ List of SQL Server Management Studio Articles and Tips which can help DBAs and Developers to better use SSMS. http://www.mytechmantra.com/SQL-Server-Management-Studio/ List of SQL Server Database Corruption Related Articles and Tips http://www.mytechmantra.com/SQL-Server-Database-Corruption/ This article explains how a DBA can use SUSPECT_PAGES table available in MSDB system database to keep track of corrupt pages in any of the SQL Server Database residing on an instance of SQL Server. http://www.mytechmantra.com/LearnSQLServer/Detecting-Corruption-Issues-in-SQL-Server-Using-Suspect-Pages/ List of SQL Server Analysis Services Administration Related Articles and Tips http://www.mytechmantra.com/SQL-Server-Analysis-Services/SQL-Server-Analysis-Services-Administration-Articles/ Due to an unplanned reboot of SQL Server one of the transactional log file of a database become corrupt. DBA noticed this issue once regular transactional log backup job started failing with BACKUP detected corruption in the database log error message. This article outlines the steps to be followed to fix BACKUP detected corruption in the database log error in SQL Server. http://www.mytechmantra.com/LearnSQLServer/BACKUP-detected-corruption-in-the-database-log-error-in-SQL-Server/ This article mentions How to Enable and Disable XP_CMDSHELL using SP_CONFIGURE. http://www.mytechmantra.com/LearnSQLServer/How-to-Enable-and-Disable-XP_CMDSHELL-using-SP_CONFIGURE/ This article demonstrates How to Export records from SQL Server to Text File using BCP http://www.mytechmantra.com/LearnSQLServer/How-to-Export-records-from-SQL-Server-to-Text-File-using-BCP/ This article describes the steps to recovery a database which is marked as SUSPECT. http://www.myTechMantra.com/LearnSQLServer/Repair_Suspect_Database_P1.html This article outlines the steps to identify deadlocks in SQL Server using Graphical Deadlock Chain Event in SQL Server Profiler. http://www.mytechmantra.com/LearnSQLServer/Identify-Deadlocks-Using-Graphical-Deadlock-Chain-Event-in-SQL-Server-Profiler/ This article demonstrates steps you need to follow to take a full backup of SQL Server Database. http://www.myTechMantra.com/LearnSQLServer/How-to-Backup-Database-SQL-Server-P1.html This article explains the steps you must follow to move TempDB database from one drive to another in SQL Server. http://www.mytechmantra.com/LearnSQLServer/How-to-Move-TempDB-to-New-Drive-in-SQL-Server/ 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 about different database backup methods and how to perform database backups along with relevant examples. http://www.mytechmantra.com/SQL-Server-Tutorials/SQL-Server-Database-Backup-Options-and-Commands-a-Step-by-Step-Tutorial-with-Examples/ 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 which data it needs to retain within SQL Server transactional logs and for the time period. http://www.mytechmantra.com/SQL-Server-Tutorials/Different-SQL-Server-Recovery-Models-Step-by-Step-Tutorial-with-Examples/ 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 the transaction is completed successfully the data gets written to data file; SQL Server will automatically clear the space used by the transaction within transaction log file for newer transactions. http://www.mytechmantra.com/SQL-Server-Tutorials/SQL-Server-SIMPLE-Recovery-Model-Tutorial-with-Examples/ In Full Recovery Model Point in Time recovery of the database is possible as long as you have all the valid database backups along with the transactional log tail backup file. In Full Recovery model all the transactions are retained within the transaction log file until the log file is backed up or the transactional log file is truncated. http://www.mytechmantra.com/SQL-Server-Tutorials/SQL-Server-FULL-Recovery-Model-Step-by-Step-Tutorial-with-Examples/ When a database is configured to use a BULK-LOGGED Recovery Model then SQL Server will log minimal amount of information for operations such as SELECT INTO, BULK INSERT, BCP, CREATE INDEX, ALTER INDEX, and REBUILD INDEX etc within the transaction log file there by reducing the transactional log file size. The Point in Time recovery of the database is possible only if the last transaction log doesn’t have any BULK-LOGGED operations. http://www.mytechmantra.com/SQL-Server-Tutorials/SQL-Server-BULK-LOGGED-Recovery-Model-Step-by-Step-Tutorial-with-Examples/ SQL Server supports different types of backups for databases. In this tutorial we will discuss in detail each of the available database backup options and how to perform backups using TSQL scripts and with SQL Server Management Studio (SSMS). http://www.mytechmantra.com/SQL-Server-Tutorials/Different-Types-of-SQL-Server-Backups/ In order to take backups a user must be a member of DBCREATOR Server Role and DB_OWNER Database Role else you will receive the below mentioned error while performing backups. http://www.mytechmantra.com/SQL-Server-Tutorials/Permissions-Required-to-Take-Database-Backup-in-SQL-Server/ Full database backup represent the database at the time when the backup has finished. However, as the database size increases the full database backup takes more time to finish and it will also require more storage space. Hence for larger databases one must supplement a full database backup with a series of differential database backups and even transactional log backups if the database is in FULL or BULK-LOGGED recovery model. Transactional log backup is not allowed when the database is in SIMPLE recovery model this is by design. http://www.mytechmantra.com/SQL-Server-Tutorials/FULL-Database-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ DIFFERENTIAL database backup will only record the data which has changes since the last successful full database backup. This backed up data is known as differential base. When compared to full database backups the differential database backup are quick to complete and will also be smaller in size as this has only the changes thereby reducing the work loss exposure. Differential database backups are very useful especially when subset of database is modified most often than the rest of the database. http://www.mytechmantra.com/SQL-Server-Tutorials/DIFFERENTIAL-Database-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ Transactional log backup is only possible when your database is in FULL or BULK-LOGGED recovery model. With the help of Transactional Log backup one can achieve Point in Time recovery for the database in case of any disaster It is highly recommended to perform transactional log backups at regular intervals to minimize the loss of work and to truncate the transactional log. http://www.mytechmantra.com/SQL-Server-Tutorials/TRANSACTIONAL-LOG-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ COPY_ONLY backup is a special type of SQL Server Backup which is independent of the sequence of conventional SQL Server backups. Normally whenever you take a backup it will affect how later backups are restored. However, when you use COPY_ONLY backup feature of SQL Server one can take a backup of the database without affecting the overall backup and restore procedures for the database. http://www.mytechmantra.com/SQL-Server-Tutorials/COPY_ONLY-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ Using MIRRORED Backup feature a DBA can create up to 3 identical copies of a database backup. This feature is available in SQL Server 2005 Enterprise Edition and later versions. http://www.mytechmantra.com/SQL-Server-Tutorials/MIRRORED-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ Using FILE backup one can backup SQL Server Data File individually. While backing up the database you can specify whole of FILEGROUP instead of specifying each database file individually within the FILEGROUP. In case if there is any file within the FILEGROUP OFFLINE may be because of file being restored then the whole FILEGROUP will be OFFLINE and cannot be backup up. A FILE backup can also serve as the differential base for differential file backups. For more information, see Differential Backups in SQL Server. http://www.mytechmantra.com/SQL-Server-Tutorials/FILE-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ Using FILEGROUP backup one can backup all the data files within the SQL Server FILEGROUP individually. While backing up the database you can specify whole of FILEGROUP (i.e., PRIMARY or SECONDARY) instead of specifying each database file individually within the FILEGROUP. http://www.mytechmantra.com/SQL-Server-Tutorials/FILEGROUP-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ PARTIAL Backups are designed for use under SIMPLE recovery model; thereby to improve flexibility to backup very large database which contain one or more read-only Filegroups. They are useful whenever you want to exclude read-only Filegroups. A partial backup resembles a full database backup, but a PARTIAL backup does not contain all the Filegroups. Instead, for a read-write database, a partial backup contains the data in the primary FileGroup, every read-write FileGroup, and, optionally, one or more read-only files. http://www.mytechmantra.com/SQL-Server-Tutorials/PARTIAL-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ A tail-log backup captures any log records which has not yet been backed up i.e., the tail of the transactional log to prevent any work loss and to keep the transactional log chain intact. Before you can recover a SQL Server database to its latest point in time, one must back up the tail of its transaction log without fail. Note that the tail log backup will be the last backup of which one can take to recovery the database. http://www.mytechmantra.com/SQL-Server-Tutorials/TAIL-LOG-Backup-in-SQL-Server-Step-by-Step-Tutorial-with-Examples/ This article explains the steps to be followed by a DBA or a Developer to Install SQL Server 2014. http://www.mytechmantra.com/LearnSQLServer/Install-SQL-Server-2014-Step-by-Step-Guide/ More and more DBAs are now move towards using PowerShell to perform routine Database Maintenance Tasks on SQL Server. In this article we will go through the quick steps to determine which version of PowerShell is installed on the Server where SQL Server is hosted using TSQL Script. http://www.mytechmantra.com/LearnSQLServer/How-to-Identify-Version-of-PowerShell-Installed-on-Server-Using-TSQL-Script/ 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. http://www.mytechmantra.com/LearnSQLServer/How-to-Migrate-Existing-Database-to-Partially-Contained-Database-in-SQL-Server/ 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. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-2014-Build-List/ 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. http://www.mytechmantra.com/LearnSQLServer/Monitoring-Transactional-Log-File-Space-Utilization-in-SQL-Server/ 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.. http://www.mytechmantra.com/LearnSQLServer/Configure-TempDB-on-Local-Disk-in-SQL-Server-2012-Failover-Cluster-to-Improve-Performance/ During PASS Summit 2014 Microsoft Unveiled Major Enhancement to Azure SQL Database. This article explains some of the major enhancements to Azure SQL Database. http://www.mytechmantra.com/SQL-Server-News/PASS-Summit-2014-Roundup-Microsoft-Unveiled-Major-Enhancement-to-Azure-SQL-Database/ This tip explains How to Deny Access to Specific DMVs in SQL Server for users to whom you have Granted VIEW SERVER STATE Permissions. http://www.mytechmantra.com/LearnSQLServer/Deny-Access-to-Specific-DMVs-in-SQL-Server-for-Users-who-have-VIEW-SERVER-STATE-Permissions/ This tip explains how to enable Line Number feature in SQL Server Management Studio (SSMS). http://www.mytechmantra.com/LearnSQLServer/Display-Line-Numbers-In-SSMS-SQL-Server-Management-Studio/ 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. http://www.mytechmantra.com/LearnSQLServer/Backup-and-Restore-Resource-Database-in-SQL-Server/ This article explains the steps to enable or disable BACKUP CHECKSUM default configuration option using SP_CONFIGURE at instance level in SQL Server 2014. http://www.mytechmantra.com/LearnSQLServer/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 Trace Flag at instance level in SQL Server 2005 and higher versions. http://www.mytechmantra.com/LearnSQLServer/Enable-BACKUP-CHECKSUM-in-SQL-Server-Using-Trace-Flag-3023/ This article explains how to enable database users in SQL Server when they are disabled accidently. http://www.mytechmantra.com/LearnSQLServer/How-to-Enable-Database-Users-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. http://www.mytechmantra.com/LearnSQLServer/Setting-PAGE_VERIFY-Database-Option-to-CHECKSUM-for-all-Databases-in-SQL-Server/ 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 does not have any valid System Administrator or SA Accounts. This article explains the steps to follow to add a new login with SA privileges. http://www.mytechmantra.com/LearnSQLServer/Steps-to-Connect-to-SQL-Server-When-all-System-Administrators-are-Locked-Out/ 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. http://www.mytechmantra.com/LearnSQLServer/Identify-Database-Properties-Using-DBCC-CHECKPRIMARYFILE-Undocumented-DBCC-Command/ Microsoft announces the release of SQL Server 2008 Service Pack 4 (SP4). http://www.mytechmantra.com/SQL-Server-News/Microsoft-Releases-SQL-Server-2008-SP4/ Microsoft announces the release of SQL Server 2008 R2 Service Pack 3 (SP3). http://www.mytechmantra.com/SQL-Server-News/Download-SQL-Server-2008-R2-SP3/ SQL Server Live provides comprehensive education and knowledge share on SQL Server database management, data warehouse, BI model design, Big Data analytics, performance tuning, troubleshooting and coding against SQL Server. The conference is designed to finely tune the skills of DBAs, developers, Business Intelligence specialists with five days of workshops, deep dives and breakout sessions http://www.mytechmantra.com/SQL-Server-News/SQL-Server-Live-An-Excellent-Training-Opportunity-for-SQL-Server-DBAs-and-Developers/ This article explains how to increase the number of SQL Server Error Logs from the default value of six. http://www.mytechmantra.com/LearnSQLServer/How-to-Increase-Number-of-SQL-Server-Error-Log-Files/ This article explains how to recycle SQL Server Error Log file without restarting SQL Server Service. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Recycle-Error-Log-Without-Restarting-Service-DBCC-ErrorLog-or-SP_CYCLE_ERRORLOG/ This article explains how to limit the size of SQL Server Error Log file in SQL Server 2012 and later versions. http://www.mytechmantra.com/LearnSQLServer/Limit-SQL-Server-Error-Log-File-Size-in-SQL-Server-2012/ There can be a rare scenario when database restore or a query is being blocked by negative SPIDs when trying to find the lead blocker by running SP_WHO2 or using Dynamic Management Views. Negative SPIDs in SQL Server cannot be killed using KILL Command. This article explains how to kill Negative SPIDs in SQL Server and what they mean in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Kill-Negative-SPID-in-SQL-Server/ Using DBCC CHECKDB Command one can check the logical and physical integrity of all the objects within the specified database. This article explains How to check when last time DBCC CHECKDB command was successfully run against the user database in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Last-Successful-DBCC-CHECKDB-Run-Date-for-all-Databases-in-SQL-Server/ The TSQL script mentioned in this article can be used to Convert Seconds to Minutes, Hours and Days in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Convert-Seconds-to-Minutes-Hours-and-Days-in-SQL-Server/ 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. http://www.mytechmantra.com/LearnSQLServer/Reset-SSMS-Keyboard-Shortcuts-in-SQL-Server-2012/ As DBA there might be scenarios where you might find the need to identify to which SQL Server Publications a specific table belong too. It can be because the subscribers have informed that they are missing newer records, or there may be a need to rename the table and you want to make sure it is not part of replication. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Replication-Query-to-find-all-tables-involved-with-Replication/ Sometime it can be very difficult for one to find out the sequence of SQL Server Agent Job execution when there are multiple jobs running on the same server. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Query-to-Find-Last-Successful-SQL-Server-Agent-Job-Run-Status-Data-and-Time/ There can be a scenario where you need to load data in batch into warehouse for the current month. During such scenarios identifying the first and last day of the month becomes necessary. This article includes the TSQL script specific to find first and last date of a month in SQL Server 2008 and higher versions. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Query-to-Find-First-Day-And-Last-Day-of-Month/ One of the most common tasks performed by the DBA is to moving user databases across different editions of SQL Server especially during Disaster Recovery Situations. There are some Enterprise Edition only features which are not available on other editions of SQL Server. Hence its better to know which features are supported before one goes ahead and restore the database on new a server. http://www.mytechmantra.com/LearnSQLServer/Does-my-SQL-Server-Database-Use-Enterprise-Edition-Features/ Microsoft announces the release of SQL Server 2012 Service Pack 2 (SP2) http://www.mytechmantra.com/SQL-Server-News/SQL-Server-2012-SP2/ Microsoft SQL Server 2014 has been released to manufacturing and the promised generally availability is by April 1, 2014. New feature in SQL Server 2014 include Enhanced In-Memory ColumnStore for Data Warehousing, New Buffer Pool Extension, Enhanced AlwaysOn, Enhanced Security, Greater scalability of compute etc. http://www.mytechmantra.com/SQL-Server-News/SQL-Server-2014-RTM/ MyTechMantra.com gives a chance to win Pluralsight Monthly Vouchers. http://www.mytechmantra.com/GiveAway/ Microsoft has improved the configuration of startup parameters in SQL Server 2012 much simpler and easier. In this article we will take a look at the steps to add a Trace Flag 1222 to identify deadlocks in SQL Server 2012 as a Startup Parameter. http://www.mytechmantra.com/LearnSQLServer/Improved-Startup-Parameters-in-SQL-Server-2012/ SQL Server 2012 has introduced new Date and Time functions in SQL Server 2012. This article explains each of them with along with an example. http://www.mytechmantra.com/LearnSQLServer/New-Data-And-Time-Functions-in-SQL-Server-2012/ Idera SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL events and see whats happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology making it more efficient, more powerful and more scalable than SQL Trace http://www.mytechmantra.com/SQL-Server-News/News-Idera-Announces-Free-SQL-XEvent-Profiler/ Microsoft has introduced Database Backup Encryption feature in SQL Server 2014 (CTP2). Starting SQL Server 2014, SQL Server will have the ability to encrypt the data while the backup is in progress. One can encrypt the database backup by specifying Encryption Algorithm and an Encryptor (Certificate or Asymmetric Key) while creating database backups. This article is a step by step guide to implement database backup encryption feature in SQL Server 2014. http://www.mytechmantra.com/LearnSQLServer/Backup-Encryption-SQL-Server-2014/ Contained Databases is a new feature which is available in SQL Server 2012. A contained database is a database that will store all its metadata within the database thereby not storing any configuration information within the master database of the SQL Server Instance where the Contained Database is created. A contained database is isolated from other databases which are available on the instance of SQL Server. http://www.mytechmantra.com/LearnSQLServer/Contained-Databases-SQL-Server-2012/ Microsoft Power BI for Office 365, is a cloud-based business intelligence service that gives people a powerful new way to work with data in the tools they use every day, Excel and Office 365. http://www.MyTechMantra.com/SQL-Server-News/Microsoft-PowerBI-a-self-service-tool-for-simplified-data-analysis-and-visualizations/ 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 Protocol. It is used to provide a highly secure method to authenticate windows users. http://www.mytechmantra.com/LearnSQLServer/Verify-and-Register-SPN-for-SQL-Server-Authentication-with-Kerberos-Connections/ Microsoft SQL Server 2014 Developer Training Kit is meant for Developers and DBAs who wants to familiarize themselves with some of the new and improved features and functionality in SQL Server 2014. It is available as a free download from Microsoft Download Center. http://www.mytechmantra.com/SQL-Server-News/SQL-Server-2014-Developer-Training-Kit/ SQL Server Integration Services service always relies on configuration file for its settings. This article explains the steps you need to follow to configure the Integration Services Service (SSIS Service) in a clustered environment. http://www.mytechmantra.com/LearnSQLServer/Issues-when-running-SQL-Server-Integration-Services-in-a-Clustered-Environment/ In one of the major Technology Breaking News, Microsoft Windows Azure Cloud Service has a set of new members joining it and those are Oracle Database, WebLogic Application Server, Java programming language and other products. http://www.mytechmantra.com/SQL-Server-News/News-Oracle-Software-on-Windows-Azure/ In order to improve error handling in TSQL scripts Microsoft has introduced throw statement in SQL Server 2012. This feature will help the database developers to handle errors more effectively. http://www.mytechmantra.com/LearnSQLServer/Error-Handling-Using-Throw-Statement-in-SQL-Server-2012/ This article outlines some of the SQL Server Security Best Practices which Database Administrators can follow to Secure SQL Servers in their environment. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-Security-Best-Practices/ This article gives you an overview of New Features in Red Gate SQL Monitor 4.0 which is a Performance Monitoring Tool for Microsoft SQL Server. http://www.mytechmantra.com/SQL-Server-News/New-Features-in-Red-Gate-SQL-Monitor-v4.0/ This article demonstrates different ways by which you can enable and disable trace flags 1204 and 1222 to capture detailed deadlock information in SQL Server Error Logs. http://www.mytechmantra.com/LearnSQLServer/Identify-Deadlocks-in-SQL-Server-Using-Trace-Flag-1222-and-1204/ Product Review of Idera SQL Elements. Idera's SQL Elements Tool is a SQL Server Inventory Management Solution. Using this tool one can easily discover and track all SQL Servers in your environment. Moreover, this tool also helps you monitor all the discovered instances and performs Health Checks and provides recommendations. http://www.mytechmantra.com/Product-Reviews/Idera-SQL-Elements-Product-Review/ This article demonstrates the steps which you need to follow to Fix Cannot open user default database. Login failed. Login failed for user SQL Server Error. http://www.mytechmantra.com/LearnSQLServer/Fix-cannot-open-user-default-database-Login-failed-Login-failed-for-user-SQL-Server-Error/ In this article we will take a look at the steps which you need to follow when you receive The transaction log for database BizTalkMsgBoxDb is full error in SQL Server. http://www.mytechmantra.com/LearnSQLServer/the-transaction-log-for-database-BizTalkMsgBoxDb-is-full-steps-to-fix-this-error/ This tip gives you an overview of How to Manage SQL Server Failover Cluster Using Command Line. http://www.mytechmantra.com/LearnSQLServer/How-to-Manage-SQL-Server-Failover-Cluster-Using-Command-Line-an-Overview/ This article demonstrates How to Measure SQL Server Transactional Replication Latency Using Trace Tokens. http://www.mytechmantra.com/LearnSQLServer/How-to-Measure-SQL-Server-Transactional-Replication-Latency-Using-Trace-Tokens/ This article demonstrates How to Identify SQL Server Cluster Node and Shared Drives Information Using TSQL Queries. http://www.mytechmantra.com/LearnSQLServer/How-to-Identify-SQL-Server-Cluster-Node-and-Shared-Drives-Information-Using-TSQL-Queries/ This article demonstrates how to identify the location of Resource database in SQL Server using a TSQL script. http://www.mytechmantra.com/LearnSQLServer/How-to-Identify-the-Location-of-Resource-Database-in-SQL-Server/ This article introduces SQL Elements which is a new Free Tool from Idera to automatically discover and track enterprise wide SQL Server inventory and health in less than 5 minutes. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-News-New-Idera-SQL-Elements-Tool-Must-Have-For-DBAs/ Red Gate Software announces the release of SQL Prompt 6 - Write, Refactor and Explore SQL Effortlessly. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-News-Red-Gate-Software-announces-the-release-of-SQL-Prompt-6/ Melissa Data Announces FREE Community Edition of its Flagship Data Quality Components for SQL Server. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-News-Melissa-Data-Announces-Community-Editions-of-its-Flagship-Data-Quality-Components-for-SQL-Server/ This article introduces SQL Integrity Check which is a new Free Tool from Idera to Detect SQL Server Database Corruption Issues. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-News-New-Free-Tool-from-Idera-to-Detect-SQL-Server-Database-Corruption-Issues/ This article explains How to Use Dedicated Administrator Connection in SQL Server. http://www.mytechmantra.com/LearnSQLServer/How-to-Use-Dedicated-Administrator-Connection-in-SQL-Server/ This article explains Different Ways to Enable Dedicated Administrator Connection in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Different-Ways-to-Enable-Dedicated-Administrator-Connection-in-SQL-Server/ This article explains How to Restart an Interrupted Database Restore in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Restart-an-Interrupted-Database-Restore-in-SQL-Server/ This article describes the steps to fix Failed to decrypt protected XML node DTSassword with error 0x8009000B? error in SSIS. http://www.mytechmantra.com/LearnSQLServer/How-to-Fix-Failed-to-decrypt-protected-XML-node-DTSassword-with-error-0x8009000B-in-SSIS/ This article describes How to Identify CPU Bottlenecks in SQL Server Using Performance Counters. http://www.mytechmantra.com/LearnSQLServer/How-to-Identify-CPU-Bottlenecks-in-SQL-Server-Using-Performance-Counters/ This article includes the script to identify the time required to complete database backup and restore in SQL Server http://www.mytechmantra.com/LearnSQLServer/Time-required-to-complete-database-backup-and-restore-in-SQL-Server/ This article mentions Script to Update Statistics for all databases in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Script-to-Update-Statistics-for-all-SQL-Server-Databases/ In this article we will take a look at different ways in which a DBA to retrieve System and SQL Server Information. http://www.mytechmantra.com/LearnSQLServer/Different-ways-to-retrieve-System-and-SQL-Server-Information/ In this tip we will take a look at how to configure SQL Server Agent to restart SQL Server and SQL Server Agent Services automatically if they end up stopping unexpectedly. http://www.mytechmantra.com/LearnSQLServer/How-to-configure-SQL-Server-Agent-to-Restart-SQL-Server-and-SQL-Server-Agent-Services-Automatically/ This article explains some of the reason because of which you wont be able to connect to a named instance of SQL Server and how to resolve them. http://www.mytechmantra.com/LearnSQLServer/How-to-connect-to-a-named-instance-of-SQL-Server/ This article explains how to fix Index cannot be reorganized because page level locking is disabled error in SQL Server. http://mytechmantra.com/LearnSQLServer/Index-cannot-be-reorganized-because-page-level-locking-is-disabled/ This article outlines the steps a database administrator can follow to grant access to DMVs in SQL Server for non administrators. http://mytechmantra.com/LearnSQLServer/Grant-Access-to-DMVs-in-SQL-Server-for-Non-Admin.html This article outlines some of the optimization techniques which a database administrator can follow to improve the performance of SQL Server Replication. http://mytechmantra.com/LearnSQLServer/Optimizing-SQL-Server-Replication.html Microsoft SQL Server 2012 System Views Map shows the key system views included in SQL Server 2012, and the relationships between them. http://mytechmantra.com/LearnSQLServer/SQL-Server-2012-System-Views-Map-Poster.html This article explains the steps to troubleshoot issue when you are unable to create or open SSIS projects or maintenance plans in SQL Server 2012. http://www.mytechmantra.com/LearnSQLServer/Unable-to-create-or-open-SSIS-projects-or-maintenance-plans-in-SQL-Server-2012.html This article explains the steps to troubleshoot “The remote procedure call failed. [0x800706be]" WMI Error in SQL Server 2012. http://www.mytechmantra.com/LearnSQLServer/The-remote-procedure-call-failed-0x800706be-Error.html This article illustrates how to use mirrored database backup feature in SQL Server along with its advantages, disadvantages and best practices.. http://www.mytechmantra.com/LearnSQLServer/Mirrored-Backup-in-SQL-Server.html This article demonstrates different ways in which one can rename SQL Server Database. http://www.mytechmantra.com/LearnSQLServer/Different-ways-to-Rename-SQL-Server-Database.html This article demonstrates how to Synchronize Analysis Services Database using Synchronize Database Wizard to make two analysis services databases identical by copying the metadata and data between source and the destination SSAS database. http://www.mytechmantra.com/LearnSQLServer/how-to-synchronize-analysis-services-databases.html This article demonstrates the steps to Detach Analysis Services Database in SQL Server Using SSMS and by Using XMLA Script. http://www.mytechmantra.com/LearnSQLServer/How-to-Detach-SSAS-Database-in-SQL-Server-or-Detach-Analysis-Services-Database.html This article demonstrates the steps to Attach Analysis Services Database in SQL Server Using SSMS and by Using XMLA Script. http://www.mytechmantra.com/LearnSQLServer/How-to-Attach-SSAS-Database-in-SQL-Server-or-Attach-Analysis-Services-Database.html Download Updated Version of Microsoft Windows Azure Training Kit which includes a comprehensive set of technical content to help one learn how to use Windows Azure. http://www.mytechmantra.com/LearnSQLServer/Download-Windows-Azure-Training-Kit-Updated-October-2012.html This article demonstrates New Features in SQL Server 2012 Reporting Services for SQL Server BI Report Developers. http://www.mytechmantra.com/LearnSQLServer/New-Feature-in-SQL-Server-2012-Reporting-Services-for-Developers.html Melissa Data’s Data Quality Component for SSIS is an excellent suite of custom Data Transformation components for Microsoft’s SQL Server SSIS that encapsulates the six levels of complete Data Quality. In this article I will demonstrate how easily an organization can leverage Melissa Data’s Contact Verify SSIS Component to Standardize, Verify, Correct and Normalize U.S and Canadian addresses. The usage of this Melissa Data’s Data Quality Components can help organizations save millions of dollars in a year by storing accurate customer information in their databases. http://www.mytechmantra.com/LearnSQLServer/Melissa-Data-Quality-Component-for-SSIS-Product-Review-P1.html Devart dbForge Schema Compare for SQL Server is an excellent Schema Comparison tool to compare schema between source and target database. This tool can be used by Database Developers and Administrators in their day-to-day work to increase the overall efficiency. This article reviews Devart’s dbForge Schema Compare for SQL Server. http://www.myTechMantra.com/LearnSQLServer/Devart-dbForge-Schema-Compare-for-SQL-Server-Review-P1.html Idera SQL Check is a fantastic performance monitoring tool which can be used for monitoring and diagnosing Performance Issues on a single SQL Server Instance. The best thing is that Idera’s SQL Check is a free SQL Server Performance Monitoring Dashboard tool but it has a limitation of monitoring only one server. http://www.myTechMantra.com/LearnSQLServer/Performance-Monitoring-tool-Idera-SQL-Check-Review-P1.html This article describes steps to be followed to rename SQL Server Stand Alone Instance After Installing SQL Server. The steps mentioned are applicable across SQL Server 2000 and higher versions. http://www.mytechmantra.com/LearnSQLServer/How-to-Rename-SQL-Server-Stand-Alone-Instance-After-Installing-SQL-Server.html This article demonstrates How to fix Orphaned Users in SQL Server Database. http://www.mytechmantra.com/LearnSQLServer/How-to-fix-Orphaned-Users-in-SQL-Server-Database.html This article demonstrates how to Detect Virtual Log Files in SQL Server Transaction Log File http://www.mytechmantra.com/LearnSQLServer/How-to-Detect-Virtual-Log-Files-in-SQL-Server-Transaction-Log-File.html This article demonstrates How to Fix Virtual Log Files in SQL Server Transactional Log file http://www.mytechmantra.com/LearnSQLServer/How-to-Fix-Virtual-Log-Files-in-SQL-Server-Transactional-Log-File.html This article demonstrates how to attach a database in SQL Server when transaction log file is missing http://www.mytechmantra.com/LearnSQLServer/How-to-attach-database-without-a-transaction-log-file-in-SQL-Server.html In this article we will go through the steps to change SQL Server Database Auto Growth Settings. http://www.mytechmantra.com/LearnSQLServer/How-to-Change-SQL-Server-Database-Auto-Growth-Settings.html This article demonstrates how to Drop Database in SQL Server when the users are connected to an SQL Server Database. http://www.mytechmantra.com/LearnSQLServer/Drop-Database-in-SQL-Server-by-Killing-Existing-Connections.html Free downloadable eBooks from Microsoft on various topics such as SQL Server, SharePoint, ASP.Net, Visual Studio, Windows, Windows Azure, Windows Phone etc. http://www.mytechmantra.com/LearnSQLServer/Free-ebook-on-SQL-Server-from-Microsoft.html This article demonstrates how to use COPY_ONLY feature in SQL Server to perform full, differential and transactional log backups without breaking the database restore sequence. http://www.myTechMantra.com/LearnSQLServer/COPY-ONLY-Backups-In-SQL-Server-P1.html This article demonstrates how to Attach Database in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Attach-Database-in-SQL-Server.html This article demonstrates how to use Detach Database method in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Detach-Database-in-SQL-Server.html This article describes the steps to resolve Property Owner is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights error in SQL Server http://www.mytechmantra.com/LearnSQLServer/Troubleshooting-Property-Owner-is-not-available-for-Database.html Troubleshoot SQL Server Reporting Services Error This page might not function correctly because either your browser does not support scripts or active scripting is disabled in SQL Server 2008. http://www.mytechmantra.com/LearnSQLServer/Troubleshooting-SQL-Server-Reporting-Service-Error.html This article demonstrates How to Create Database in SQL Server using TSQL code and by using SQL Server Management Studio. http://www.mytechmantra.com/LearnSQLServer/Create-Database-in-SQL-Server.html This article demonstrates how to change SA Password in SQL Server using TSQL code and by using SQL Server Management Studio. http://www.mytechmantra.com/LearnSQLServer/change-sa-password-in-SQL-Server.html In this article we will take a look at different ways in which one can easily identify when was SQL Server last restarted. http://www.mytechmantra.com/LearnSQLServer/When-SQL-Server-was-last-restarted.html This article describes troubleshooting steps for SYSPOLICY_PURGE_HISTORY SQL Server Job failure in Failover Cluster Instance of SQL Server 2008 http://www.mytechmantra.com/LearnSQLServer/Troubleshooting-SYSPOLICY_PURGE_HISTORY-Job-Failure-in-Failover-Cluster-Instance-SQL-Server-2008.html This article describes troubleshooting steps for SYSPOLICY_PURGE_HISTORY SQL Server Job failure in Stand Alone Instance of SQL Server 2008 http://www.mytechmantra.com/LearnSQLServer/Troubleshooting-SYSPOLICY_PURGE_HISTORY-Job-Failure-in-Stand-Alone-Instance-SQL-Server-2008.html This article describes steps to Troubleshoot SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs' Error in SQL Server. http://www.mytechmantra.com/LearnSQLServer/Troubleshooting-SQL-Server-blocked-access-to-procedure-sp_send_dbmail.html In this article we will take a look at Performance Dashboard Reports which 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. http://www.MyTechMantra.com/LearnSQLServer/Performance-Dashboard-Reports-SQL-Server-2012-P1.html In this article we will take a look at some of the tips which can help you Avoid Account Lockout issues. http://www.mytechmantra.com/LearnSQLServer/Tips-to-Avoid-Account-Lockout-Issues.html This article describes how to Encrypt Database Backups in SQL Server Using MEDIAPASSWORD Option available in Restore Database Command. http://www.MyTechMantra.com/LearnSQLServer/Encrypt-Database-Backups-SQL-Server-Using-MEDIAPASSWORD-Option-P1.html This article demonstrates the steps you need to follow to Install SQL Server 2012 on a Windows Server 2008 R2 Service Pack 1. However, the steps mentioned can be followed to Install SQL Server 2012 on Windows Server 2008 SP2. http://www.mytechmantra.com/LearnSQLServer/Install-SQL-Server-2012-P1.html This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2012 released by Microsoft. http://www.mytechmantra.com/LearnSQLServer/SQL-Server-2012-Build-List.html This article describes how to quickly gather Diagnostic Data and Health Information of SQL Server 2012 using sp_server_diagnostics system stored procedure for Performance Analysis. http://www.mytechmantra.com/LearnSQLServer/Using-sp_server_diagnostics-Quickly-Capture-Diagnostic-Data-and-Health-Information-SQL-Server-2012.html This article demonstrates steps you need to follow to restore a full database back up in SQL Server. http://www.mytechmantra.com/LearnSQLServer/How-to-Restore-Database-SQL-Server-P1.html This article demonstrates New Features available in Microsoft SQL Server 2012 for Database Administrators. http://www.myTechMantra.com/LearnSQLServer/New-Features-SQL-Server-2012-DBA.html This article demonstrates New Features available in Microsoft SQL Server 2012 for Database Developers. http://www.mytechmantra.com/LearnSQLServer/New-Features-SQL-Server-2012-Developer.html This article demonstrates how to configure and use Indirect Checkpoint Feature of SQL Server 2012. http://www.myTechMantra.com/LearnSQLServer/Indirect-Checkpoints-Feature-in-SQL-Server-2012.html This article illustrates how to achieve SQL Server Pagination using OFFSET and FETCH NEXT Feature of SQL Server 2012. http://www.myTechMantra.com/LearnSQLServer/SQL-Server-Paging-Using-OFFSET-and-FETCH-Feature-in-SQL-Server-2012.html This article illustrates with an example the WITH RESULT SETS Feature of SQL Server 2012. http://www.myTechMantra.com/LearnSQLServer/With-Result-Set-Feature-SQL-Server-2012.html This article describes how to Troubleshooting OLE DB Provider Microsoft.ACE.OLEDB.12.0 is not registered Error Message when Importing data from Excel 2007 file to SQL Server 2008 or while Exporting data from SQL Server 2008 to Excel 2007 file formats. http://www.myTechMantra.com/LearnSQLServer/Troubleshoot_OLE_DB_Provider_Error_P1.html This article describes the steps to downgrade an SQL Server 2008 R2 database to SQL Server 2008 using SQL Server Import and Export Wizard. http://www.myTechMantra.com/LearnSQLServer/Downgrade_SQL_Server_Database_P1.html This article demonstrates how to install a SQL Server 2008 Service Pack. http://www.mytechmantra.com/LearnSQLServer/Install_SQL_Server_2008_Service_Pack_P1.html This article demonstrates how to identify currently used SQL Server Authentication Mode using TSQL and SQL Server Management Studio. http://www.mytechmantra.com/LearnSQLServer/SQL_Server_Authentication_Mode_P1.html This article describes the steps to install a standalone instance of SQL Server 2008 R2 on Windows Server 2008 R2. http://www.mytechmantra.com/LearnSQLServer/Install_SQL_Server_2008_R2_P1.html If you are trying to restore a database on an SQL Server 2005 or a lower version from the database backup which was performed on an SQL Server 2008 instance then it will fail. In this article we will take a look at the reason why an SQL Server Database from a higher version cannot be restored onto a lower version of SQL Server. http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html Is there an easy way to identify whether the database was upgraded from a previous version of SQL Server or it was created on the existing instance of SQL Server? In this article we will go through the steps to identify whether a database was upgraded from a previous version of SQL Server or it was created newly on the existing instance. http://www.mytechmantra.com/LearnSQLServer/Identify_Internal_Version_Number_of_a_Database_P1.html This article demonstrates how to rebuild system databases in SQL Server 2008. http://www.myTechMantra.com/LearnSQLServer/Rebuild_System_Databases_In_SQL_Server_2008.html In this article we will take a look at how database administrator can leverage ALTER DATABASE Commands to get exclusive or restricted access of a database. http://www.myTechMantra.com/LearnSQLServer/Exclusive_Access_SQL_Server_Database.html This article describes about different types of SQL Server recovery models and also discusses difference between Simple, Bulk Logged and Full Recovery Models. http://www.myTechMantra.com/LearnSQLServer/SQL_Server_Recovery_Model.html This article demonstrates how to change the Default SQL Server Backup Folder in SQL Server 2008 Using Policy Based Management Feature. http://www.myTechMantra.com/LearnSQLServer/Changing_Default_Backup_Location.html This article demonstrates how to change the default file location of SQL Server Data and Log Files. http://www.myTechMantra.com/LearnSQLServer/Changing_default_location_of_Data_and_Log_files.html This article demonstrates the steps to create an SQL Server Login which enforces password policies and password expiration policies feature that is available in Windows Server 2003 and later versions to passwords which are used inside SQL Server 2005 and higher versions. http://www.myTechMantra.com/LearnSQLServer/Enforce_Password_Policies_for_SQL_Server_Logins.html This article demonstrates how to create an SQL Server Agent Job to backup an analysis services database. http://www.myTechMantra.com/LearnSQLServer/Automate_Backup_of_Analysis_Services_Database.html This article demonstrates the steps which a database administrator needs to follow to restore an analysis services database. http://www.myTechMantra.com/LearnSQLServer/Restore_Analysis_Services_Database_P1.html This article demonstrates the steps which a database administrator needs to follow to backup an analysis services database. http://www.myTechMantra.com/LearnSQLServer/Backup_an_Analysis_Services_Database.html This article demonstrates how to take advantage of Common Table Expression (CTE) feature of SQL Server 2005 to delete duplicate records from a table. http://www.myTechMantra.com/LearnSQLServer/How_to_Delete_Duplicate_Records_from_an_SQL_Server_Table.html This article demonstrates how a database administrator can easily enable auditing in SQL Server for logins. http://www.myTechMantra.com/LearnSQLServer/Auditing_SQL_Server_Logins_P1.html Database administrator is often asked a question whether It is possible to hide an SQL Server Instance? so that it is not visible to users across the network. In this article we will go through the steps which DBA needs to follow in order to hide an instance of SQL Server. http://www.myTechMantra.com/LearnSQLServer/How_to_Hide_an_Instance_of_SQL_Server.html SQL Server 2008 introduces four new DATE and TIME data types namely TIME, DATE, DATETIME2 and DATETIMEOFFSET. In this article we will take a look into each of these new data types in detail. http://www.myTechMantra.com/LearnSQLServer/New_Date_and_Time_Data_Types_in_SQL_Server_2008.html An overview of SQL Server Configuration Manager Tool which was introduced in SQL Server 2005. Using this tool you can manage all the SQL Server Services, configure network and client protocols, change service accounts and update service account passwords. http://www.myTechMantra.com/LearnSQLServer/Overview_of_SQL_Server_Configuration_Manager.html SQL Server 2008 introduces five new functions namely SYSDATETIME, SYSDATETIMEOFFSET, SYSUTCDATETIME, SWITCHOFFSET and TODATETIMEOFFSET. In this article we will take a look into each of these new functions in detail. http://www.myTechMantra.com/LearnSQLServer/Date_and_Time_Functions_in_SQL_Server_2008.html Database administrators often find the need to restart a remote server once they have completed the installation of an SQL Server Service Pack or a Hot fixes or a Windows Monthly Patch etc. This article gives an insight into SHUTDOWN.EXE command and its usage. http://www.myTechMantra.com/LearnSQLServer/How_to_Remotely_Shutdown_Restart_or_Log_Off_Windows_Server_across_the_network.html This article gives you an overview of Transparent Data Encryption feature of SQL Server 2008. Database Administrator can use this new feature of SQL Server 2008 to protect data and log files of databases. http://www.myTechMantra.com/LearnSQLServer/Using_Transparent_Data_Encryption_Feature_of_SQL_Server_2008_P1.html This article describes the different options that are available to get the total number of rows within all tables in a SQL Server Database. http://www.myTechMantra.com/LearnSQLServer/RowCount_of_all_Tables_P1.html This article gives you a deeper insight into the various means of cutting cost with the help of technology. http://www.myTechMantra.com/LearnSQLServer/Cost_Cutting_Using_Technology_P1.html Microsoft SQL Server 2008 R2 introduces lot many new features for Business Intelligence users, Developers and Database Administrators. This article gives you an overview of some of the new features in SQL Server 2008 R2. http://www.myTechMantra.com/LearnSQLServer/Microsoft_SQL_Server_2008_R2.html This article is a step by step guide which can be used by database administrators to uninstall SQL Server 2008 Enterprise Edition manually. http://www.myTechMantra.com/LearnSQLServer/Uninstalling_SQL_Server_2008_P1.html SQL Server Database Administrators can leverage Database Instance File Initialization Feature which is available in Microsoft Windows XP Professional, Windows Server 2003 or later versions to reduce the time taken to restore very large databases. http://www.myTechMantra.com/LearnSQLServer/Database_Instant_File_Initialization_Feature.html This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2005 released by Microsoft. http://www.myTechMantra.com/LearnSQLServer/SQL_Server_2005_Build_Versions.html This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2008 released by Microsoft. http://www.myTechMantra.com/LearnSQLServer/SQL_Server_Versions_P1.html This article keeps track of all the Security Patches, Cumulative Updates, Service Packs for SQL Server 2005 released by Microsoft. http://www.myTechMantra.com/LearnSQLServer/SQL_Server_2008_R2_Build_Versions.html Microsoft SQL Server 2008 introduces much awaited Database Backup Compression feature. This article describes how database administrators can configure and use database backup compression feature in Enterprise and Developer Editions of SQL Server 2008. http://www.myTechMantra.com/LearnSQLServer/Backup_Compression_Feature_In_SQL_Server_2008_P1.html