xSQL Data Compare

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 primarily geared for managing change in data between database instances.…

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 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, the explorer provides the ability to filter…

Normalization

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). OLAP systems are designed solely for use…