Browse by Tags
All Tags »
SQL Server (
RSS)
Updated on July 19. Thanks, Hazzik! This is part of a series of posts about NHibernate Pitfalls. See the entire collection here . If you want to load multiple joined collections simultaneously eagerly you will end up with a cartesian product . This is...
Following my last posts on Change Data Capture and Change Tracking , here is another tip regarding tracking changes: table and colum checksums. The concept is: each time a column value changes, the checksum also changes. You can use this simple method...
You may recall my last post on Change Data Control . This time I am going to talk about other option for tracking changes to tables on SQL Server: Change Tracking . The main differences between the two are: Change Tracking works with SQL Server 2008 Express...
There's an hidden gem in SQL Server 2008: Change Data Capture (CDC). Using CDC we get full audit capabilities with absolutely no implementation code: we can see all changes made to a specific table, including the old and new values! You can only use CDC...
Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=E9C68E1B-1E0E-4299-B498-6AB3CA72A6D7&displaylang=en .
Service Pack 3 for SQL Server 2005 has been recently released. You can get it here . Note that now there are different versions depending on what SQL Server you are using (Express, Express with Advanced Services, etc). The Books Online has also been updated...
More Posts