Tuesday, August 31, 2010

SQL Data Comparison with Visual Studio 2010

We often need to compare and synchronize the data that tables (which have the same structure) contain. For example we normally define some master data in a development environment during development and would like the same data to be deployed/inserted/updated to Test/QA/UAT/Production environments after development. So how can we do this, how we can compare data of the tables between different databases and generate data synchronization or incremental data deployment scripts? Click here for more details...

SQL Schema Comparison with Visual Studio 2010

Often we need to compare databases across two different environments (or even sometimes in the same environment) to identify the schema object differences, so that one database can be brought in sync with another one. For example, we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts? Click here for more details...

Understanding and creating libraries in SharePoint 2010

A library is kind of container/list for creating, organizing and managing different types of documents/contents and share it with other team members. It allows to store files and meta information about the files so that it can be used among different team members. You can create, store and manage almost every type of file in different kind of libraries for example word documents, spreadsheets, presentations, forms etc. By default a Shared Library is created when you create a site and then on additionally you can create as many as type of libraries you want. This article talks abour different types of libraries and covers creating/managing document library in details, for more details click here.

Creating Web Applications, Site Collections and Sites in SharePoint 2010

SharePoint 2010 introduced several new features, one of them is enhancement to Central Administation site. This article discusses about using SharePoint 2010 Central Administration to create web application, site collections and sites and how they relate to each other. To learn more, click here.

Instant File Initialization for SQL Server 2005/2008

This article discusses Database Instant File Initialization, which instructs the OS to allocate the required disk space immediately before actually zero-ing out the content from the allocated space. This means the content of the allocated disk area remains there until SQL overwrites it, improving the performance and reducing the downtime. Read on to learn more...

Thursday, August 5, 2010

Developing Service Broker Application when Initiator and Target are in same database

SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. In this article, I will be creating an Service Broker application in which Initiator and Target both are in the same database, for more details click here.

Transfer Jobs Task and Transfer Logins Task in SSIS

Making a replica of your production server to create a dev or test environment or moving your production data to new hardware are tasks a DBA needs to perform. So what are different methods to perform these tasks efficiently and without much effort? In this article I am going to demonstrate how you can use the Transfer Jobs Task and the Transfer Logins Task to perform some of these operations, for more details click here.

Transfer Database Task and Transfer SQL Server Objects Task in SSIS

Making copies of databases, moving databases to another SQL Server instance and transferring SQL Server objects to another database are frequent tasks a DBA performs. This article discusses how you can perform these operations by using the Transfer Database Task and Transfer SQL Server Objects Task in SSIS without having to write any code, for more details click here.