xSQL Data Compare

Please see my other Database Development articles. Managing Database Change While the xSQL package also comes with xSQL Object Compare, an impressive tools for managing changes between database instances, this article will focus solely on the product used for managing data changes, xSQL Data Compare. Produced by xSQL, xSQL Data Compare represents a robust application…

SQL Server: SSMS Object Explorer Filter

Please see my other Database Development articles. Leveraging the Object Explorer Filter to work more efficiently. The SQL Server Studio Manager’s primary interface to database objects is the object explorer. While this tool is very powerful, the results it displays can be quite overwhelming, especially in a production environment. To make locating objects more efficient,…

Normalization

Please see my other Database Development articles. Introduction Before I define the process of designing a database, or “normalization,” I think some background is essential. In most implementations of SQL Server databases, the system they are designed to support are generally defined in two broad categories: Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP).…