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.
https://www.mssqltips.com/sqlservertip/5602/why-surrogate-keys-are-needed-for-a-sql-server-data-warehouse/

Monday, January 22, 2018

Field Notes on SQL Server Cluster Installation

Something good to note. 

https://gdatatech.blogspot.com/2018/01/field-notes-on-sql-server-cluster.html

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?