Yan Pan

When I wrote the first installment of this series, I used Denali CTP3. Since then, SQL Server 2012 has been released. In this second installment, I am

SQL Server doesn’t just serve as a storage engine; it’s also a powerful analytical engine. With the new analytic enhancements in SQL Server

Unit testing provides a structured and automated way of testing individual components of a system. Database unit testing specifically tests the data

In SQL Server 2000, you could return XML from SQL Server with the FOR XML clause or parse XML into a result set with the OPENXML function. However, XML

In the first article of this series, we enabled change tracking on the HumanResources.Department table. Now how do we get the changed data? With the

Some applications are designed to pull data from a central database into a local cache. For example, on-the-road sales personnel only connect occasionally

In the first article of this series, we configured a two-node Peer-to-Peer replication topology. In this article, we will add a third node to the topology

International companies with offices and customers around the globe often face a problem. Data specific to a location is updated at that location, but the

SQL server 2008 introduced a new feature called FILESTREAM. FILESTREAM is implemented as a storage attribute of varbinary(max). By enabling this

A busy SQL Server instance with tens or hundreds of databases, for example, a SharePoint server used by the entire company, often has its database files

It would be ideal if an application connecting to SQL Server only needed to access objects and resources inside the SQL Server instance. However,

In Part II of this series, we showed you a step-by-step example of Integrated installation of SQL Server 2008 cluster. In this article, we will move onto