Archive of ‘SQL server’ category

Using For Loop and Foreach Loop Containers in SSIS

  SQL Server Integration Services supports two container tasks name For Loop and Foreach loop. These containers supports to execute the repetitive workflows in controlled way. The For Loop has three expressions that control it’s execution and termination. This post also discuss about Foreach loop container in SSIS. The three expressions are InitExpression  The For […]

Using Data Profiling Task in SSIS

  Data Profiling is important in data quality processing and transformation. It provides a way to investigate large datasets and to identify incorrectly formatted data. This post explains doing data analysis using Data Profiling task. Data Profiling task helps you to Identify the problems with your data. Example: Finding the products in your data  which […]

SQL Azure vs SQL Server

  This post discusses the differences between SQL Azure and SQL Server in the context of security                                Supports SQL(native) and Windows authentication. Supports SQL(native) only, no windows authentication. Authorization is based on database users and roles. Authorization is based on database users and roles. SQL Server has fixed server roles such as serveradmin, securityadmin […]

Creating a database in SQL Azure

  This post discusses about setting up a windows Azure and creating a SQL Azure database. There 3 main steps to create a main database Step1: Visit the Windows Azure website and select the suitable offer. For testing and knowing the features there is a introductory offer which is free to use as long as […]

Creating a Database Unit Test using Visual Studio 2010

  This post discusses about creating a database unit test case in Visual Studio 2010 which verifies the functionality of a stored procedure. Creating Database Test cases helps you to identify the code defects which in-directly effects the application behavior. In order to create a database unit test, you need to VS studio 2010 test […]

Analyzing SQL Server Performance using Performance Monitor Counters

This post discusses about using Performance Monitor tool to create a base-line using different performance counters. It also discusses analyzing hardware resource bottlenecks and retrieving performance monitor data in sql server using views. Performance Monitor Tool collects the detailed information of system resources including memory, processor , disk and network.SQL Server 2008 provides extensions to […]