BLOG DBA TIPS AND TRICKS

Step by step configurations

• Create a Windows Cluster for SQL Server HA
• Install SQL Server Cluster database
• Configure Transactional Replication
• Configure AlwaysOn
• SQL Server Auditing

Resolving SQL Server issues

• Resolve OLE DB provider “SQLNCLI11” with SQL Linked Server
• Access blocked to sp_OAxxx Objects

Standard commands

• Day to day maintenance scripts