SQL CLR Integration allows you to create database objects that enhance your ability to provide custom functionality and package them into .NET assemblies. The .NET CLR offers: Access to existing managed code. Security features to ensure managed code will not compromise the server. The ability to create new resources using .NET languages like Microsoft Visual [...]
Category Archives: Video – DBATAG
How to use Managed Code (CLR) in SQL Server? Video
Posted by Mahesh Gupta on November 30, 2010
1 comment
Video : Install SQL Server Denali Setup (Install SQL Server 2011)
Posted by Mahesh Gupta on November 19, 2010
9 comments
Microsoft release Microsoft SQL Server 2011 CTP1 on 08-November-2010. I am going to share my experience related to SQL Server Denali Installation. Adding to this, I also recorded a Video Tutorial for all readers. This Video demonstrates How to install a new instance of SQL Server Denali. Step by Step Video Guide to Install SQL [...]
SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials
Posted by Mahesh Gupta on November 19, 2010
1 comment
Microsoft made a number of improvements on this new release "Denali" specially for Integration Services. These are some of the key improvements in SSIS Migration and Deployment Working with Integration Services projects in Business Intelligence Development Studio (BIDS) Using the Deployment Wizard to deploy an Integration Services project Import an Integration Services Project from the [...]
Video : How to Add a Node to an Existing SQL Server 2008 Failover Cluster
Posted by Mahesh Gupta on November 15, 2010
0 comments
This video demonstrates, how to add a node to an existing SQL Server Failover Cluster instance. Note: To view All this Video, Please install Microsoft Silver light Tags : How to Add a Node to an Existing SQL Server 2008 Failover Cluster,how to add a node to an existing SQL Server Failover Cluster instance, how [...]
Video : How to Setup Replication with SQL Server 2008 ?
Posted by Mahesh Gupta on November 13, 2010
6 comments
What is Replication ? Replication is the mechanism for creating and maintaining multiple copies of the same data. Replication allows, • Multiple copies of data can be kept in sync. • Allows data be closer to users, improving performance. • Allows a branch office to work when not connected to the main office. • Separate [...]
Video : How to Export SQL Server Data to Excel
Posted by Mahesh Gupta on November 12, 2010
1 comment
Copying data from SQL Server to Excel is business requirement. Today I got this question by one of the blog reader, who wanted to learn "How to Export SQL Server Data to Excel" Exporting data from SQL Server to Excel can be achieved in a variety of ways like Data Transformation Services (DTS) SQL Server [...]
