October, 2012

  • 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...
  • 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...