Tuesday, July 24, 2018

Why Surrogate Keys are Needed for a SQL Server Data Warehouse

In this tip we look at some of the reasons why surrogate keys should be used when building a data warehouse.

Monday, January 22, 2018

Field Notes on SQL Server Cluster Installation

Something good to note. 


Monday, November 20, 2017

SQL Server auditing with Server and Database audit specifications

Auditing is a key feature in any application or any system as it provides end users with better analysis for administrators. Apart from analysis, auditing can be used as a troubleshooting mechanism too. Apart from organizational reasons, there are compliance reasons for enabling auditing depending on the domain of operation.

Read more at https://www.sqlshack.com/sql-server-auditing-server-database-audit-specifications/

Sunday, November 12, 2017

Not Align UI

Look at the following screen you will see in SQL Server when configuring Audit.

Where is the aligning?