Development With A Dot

Blog on development in general, and specifically on .NET



My Friends

My Links

Permanent Posts

Portuguese Communities

Browse by Tags

All Tags » SQL Server (RSS)
NHibernate Pitfalls: Eager Loading Multiple Collections
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...
Table and Column Checksums
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...
Change Tracking
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...
Change Data Capture
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...
SQL Server 2008 Developer Training Kit Released
Get it here: .
New Downloads
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