How to add additional article into existing Publication. Method 1: To add an article after a publication is created On the Articles page of the Publication Properties – <Publication> dialog…

I was assigned a database replication projects to setup database replication that supported ETL projects for a Fire and Policy department. The Source and Target database are located in the…

My DBA Story. As a production DBA, I wanted to make sure all production sql servers are backup properly. And it’s amazing to me that when I assigned to Audit…

On my continue IT learning and passion.  I have setup two nodes Microsoft SQL Server 2016 clustering on Azure. There are many preparations that must be done like: Setup Azure…

I continued to explorer my skills and knowledge on MS SQL Server 2016 on AlwaysOn. I have been tested and  setup three (3) nodes clustering that running on VMWare environment…

Problems: Cluster resource SQL Server Agent in clustered role ‘ZZZCRMSQLP1VS1’ failed Resolutions: Requesting a temp local admin right on both cluster nodes RPD into both WIndow Server 2012 cluster nodes…

Starting Microsoft SQL Server 2012 version, the SQL Server clustering is called SQL Server 2012 AlwaysOn. Recently, I have setup, configured, and installed SQL Server 2012 Clustering in VMware environment.…

Problem I’ve been to restore a Microsoft SQL Server 2008 R2 production database to a development/test server in order to troubleshot Microsoft Dynamics AX problems. Currently, I’m doing this process…

I am working on a client who running Microsoft SQL Server 2008 R2 Express that implented in Retail stores. The database architecture setup was very unique due to the nature of business.…