SQL Server 2008 has some great new features. One of them is the new auditing capability. Now we can audit at the server, database and table level according to specifications provided by the DBA.

Of course, making sure that the purchase orders audit table was always properly updated has been a royal pain. If you've ever faced the problem of determining what the state of your data was at a ...

If you're using SQL Server 2016 or later then I would recommend taking a look at Temporal table (https: ... WARNING The existing audit table will be deleted if you add @ForceDropRecreate = 1!!!

Q&A. SQL Server Design: No Code Necessary . Data pro Thomas LaRock dives into the intricacies of SQL Server design, emphasizing the power of smart datatype decisions.