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.


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.

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.