T-SQL: Checksum

Constructing a hashtable with recordsets. Often times when building complex queries, it becomes difficult linking different sets of data using… Read more T-SQL: Checksum

xSQL Data Compare

While the xSQL package also comes with xSQL Object Compare, an impressive tools for managing changes between database instances, this… Read more xSQL Data Compare

SQL Server: SSMS Object Explorer Filter

Leveraging the Object Explorer Filter to work more efficiently. The SQL Server Studio Manager’s primary interface to database objects is… Read more SQL Server: SSMS Object Explorer Filter

Normalization

Introduction Before I define the process of designing a database, or “normalization,” I think some background is essential. In most… Read more Normalization

T-SQL: Bitwise Arithmetic

Using bits as flags. Recording user settings, often as “categories” represents significant persistence within many applications. Storing all these values… Read more T-SQL: Bitwise Arithmetic