Techbubbles

Archive of ‘SQL server 2008’ 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 Loop evaluates […]

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 are […]

Running SQL Server JOBS with different user accounts in SQL 2008

 

This post discusses about configuring different user account to JOB running in SQL Server 2008. By default SQL JOBs runs under service account that you have configured while installing the SQL Server. You can follow the below steps to change the user account that running under JOB

 
1. Open SQL Server Management Studio and expand the […]

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 suite […]

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 […]

Monitoring running processes in SQL Server 2008 R2

 

You can view the current connections and processes that running on a sql server instance in two ways

Using Activity Monitor
Using T-SQL statements

Monitoring Process in Activity Monitor
To open the Activity Monitor in SQL Server Management Studio Right click the server then select the Activity Monitor option as shown below

Related Posts:Deploying SSIS packages into SQL […]

SQL Server Reporting with Analysis Services

 
 

SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL […]