Stop using TOP to page for data from now on use the OFFSET

  With all the innovation that SQL 2012 bring to us in the T-SQL area we have the offset command. What is the offset command? I early version of SQL (before 2012) when we wanted to select out of a table a number of row we all have used the TOP command, the top command…

0

SQL Server 2012 Audit Enhancements

SQL Server Auditing is useful for auditing the usage of your database operations. We’ve got quite a bit of new features and enhancements in SQL Server 2012. First, server level auditing is now available in all SQL Server 2012 editions. Database level auditing is available only in Enterprise, Developer and the Evaluation editions. SQL Server…