2016-10-28
884 reads
2016-10-28
884 reads
Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.
2014-12-19 (first published: 2012-05-31)
14,635 reads
In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.
2014-12-12 (first published: 2012-01-16)
13,228 reads
2010-07-30
2,752 reads
2010-07-23
2,598 reads
2010-07-16
2,883 reads
2010-07-09
3,001 reads
Do you have a table listing departments for each company? Assuming there are always 4 depts for each company as in your example: SELECT counts.company_no, counts.dept_no, counts.count FROM ( SELECT dept_no = 1 UNION SELECT dept_no = 2 UNION SELECT dept_no = 3 UNION SELECT dept_no = 4 ) depts […]
2004-11-22
Thanks Jonathan! Again two new ones I like this flowery language! Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-08
hi Phill your reply was very helpful, thank you. we don't the process at the moment. what we are trying is: VB 6 front end and SQL 2K back database. then we need to send this data to other department. In other department they use Progress front end and Progress database as back end. Once […]
2003-09-03
2 reads
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers