SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 now available in Microsoft Update Catalog

SQL Server 2008 Service Pack 4 and SQL Server 2008 R2 Service Pack 3 were the last service packs for both versions respectively and they are now available on Microsoft Update Catalog. Refer Original Post: Click Here  References: SQL Server 2008 R2 Service Pack 3 https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2008-r2-service-pack-3-has-released/ SQL Server 2008 Service Pack 4 https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2008-service-pack-4-has-released/   Cheers HopeContinue reading “SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 now available in Microsoft Update Catalog”

Fix – Tempdb path was wrongly updated

You have Moved the tempdb to other drive and forgot to add the name of the MDF and LDF at the end of the file path, hence the error Error: 5123, Severity: 16, State: 1. Also, unable to restart the SQL Server. Don’t be panic. We can fix this. In this example I’m going to move the tempdb without providingContinue reading “Fix – Tempdb path was wrongly updated”

Database Mirroring = SQL Server 2016 AlwaysON Basic Availability Groups

Database Mirroring was one of the widely used feature since SQL Server 2005 until Microsoft announces Always On availability groups. Database Mirroring feature has been listed as deprecated ever since Availability groups have been introduced from SQL Server 2012. SQL Server 2016 BOL states Database Mirroring feature will be removed in a future version of MicrosoftContinue reading “Database Mirroring = SQL Server 2016 AlwaysON Basic Availability Groups”

Availability Groups Monitoring Alerts

You have setup the availability groups. How would know that the availability groups are running fine? All the good DBA’s always want to be notified via email when there are any issues related database servers not just only availability groups. In order to do this, you would need a alerts setup so that you canContinue reading “Availability Groups Monitoring Alerts”

Powershell Script to Add New Database to Existing Availability Groups

One of the common tasks for DBA to add the new database to existing availability groups. This can be done fairly easy via SSMS. The requirement is how to deploy the new database from Team Foundation Server (TFS) to SQL Server Alway on AG listener and automatically add this database to Availability groups. Here is theContinue reading “Powershell Script to Add New Database to Existing Availability Groups”

Backup and Restore Database without non clustered indexes

In this post, I’m going to demonstrate how to take backup of database without considering non clustered indexes. Before describing how to eliminate index data from backups, it’s first important to point out that a non clustered index contains simply a copy of the rows from its associated table, sorted differently by the index’s keys toContinue reading “Backup and Restore Database without non clustered indexes”

Enable Instant File Initialization is easy in SQL Server 2016

Starting from SQL Server 2005, Microsoft introduced a feature called Instant File Initialization. By default, when you create a database, add a new data file, increase the size of an existing file,  in SQL Server first initialized by filling the files with zeros. File initialization causes these operations to take longer. However, when data is written toContinue reading “Enable Instant File Initialization is easy in SQL Server 2016”

Tempdb Enhancements in SQL Server 2016

Tempdb Trace Flags 1117 and 1118 are no longer needed in SQL Server 2016. 1117 flag is controlled by the AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES option of ALTER DATABASE and 1118 flag is controlled by the SET MIXED_PAGE_ALLOCATION option of ALTER DATABASE. What are these Trace Flags TRACE FLAG 1117 – GROW ALL FILES IN A FILE GROUPContinue reading “Tempdb Enhancements in SQL Server 2016”

Fix – Availability Group Listener Failed with the message WSFC could not bring the network name resource

One of the common issue I and my team have encountered several times when we setup availability group listener in SQL Server as below Msg 19471, Level 16, State 0, Line 2 The WSFC cluster could not bring the Network Name resource with DNS name ‘<DNS name>’ online. The DNS name may have been takenContinue reading “Fix – Availability Group Listener Failed with the message WSFC could not bring the network name resource”