Export and Import the database objects using BACPAC file

In this post i will be explaining about how to export the database objects to backpac and import from bacpac file. Connect to SQL Server , Right click on the database and Go to Tasks –> Export Data Tier Application   2. Introduction screen will be appeared as shown below, click next to continue 3. Export setting screenContinue reading “Export and Import the database objects using BACPAC file”

Different ways to Monitor Deadlocks

Every database environment, deadlocks are common problems and it is important for DBA’s to monitor deadlocks and make sure to prevent them from reoccurring. There are multiple ways to monitor deadlocks Using Trace Flags  We can enable two trace flags 1204 and 1222 to capture deadlock information in error log. Run the below code, this willContinue reading “Different ways to Monitor Deadlocks”

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”

Free SQL Server 2016 Developer Edition

Earlier this month, Microsoft announced the general availability of SQL Server 2016 for Windows and Windows Server.  You can get started today with SQL Server 2016 Developer Edition, which is free and has all the features and capabilities of Enterprise Edition (Dev/Test only; not for production environments or use with production data). Cheers Hope you likeContinue reading “Free SQL Server 2016 Developer Edition”

New SQL Server 2016 Truncate Table With Partitions

I have a table with different partitions and would like to truncate rows in the particular partitions in a table rather than truncating whole table. How can we do this? This task is fairly easy in sql server 2016. Microsoft introduced a new clause called “With Partitions” in truncate table command. Let’s see how it works. ForContinue reading “New SQL Server 2016 Truncate Table With Partitions”

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”