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/


Saturday, October 7, 2017

Microsoft Releases SQL Server 2012 Service Pack 4

Microsoft today announced that the final service pack for SQL Server 2012 is now available for download.
The latest official release for the half-decade-old version of Microsoft's database management system includes a rollup of all hotfixes released over the years and focuses on scalability and performance improvements, especially on newer hardware. 

The final service pack also includes:
  • Enhancements to dynamic management views (DMV), extended events, and query plans to provide additional monitoring capabilities.
  • Consistency check performance improvements.
  • Increased diagnostic tools in showplan XML.
  • Resource Governor query hints, which Microsoft said will provide increased granular control.
  • Performance improvements when accessing XEL files in the XEvent Linq reader.
  • Database cloning, which will copy the schema and metadata (without the actual data) for troubleshooting.
  • Spatial queries performance improvements.