Translate

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?

Saturday, November 11, 2017

New T-SQL Commands in SQL Server 2017

Despite the maturity of TSQL, SQL Server 2017 still introduces several new features which to the T-SQL family which can be very useful in database development.
http://www.sql-server-performance.com/2017/new-t-sql-commands-in-sql-server-2017/