SQL server Archives - Page 4 of 7

Using For Loop and Foreach Loop Containers in SSIS

September 11, 2011

SQL server, SQL Server 2008 R2, 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…

Using Data Profiling Task in SSIS

September 10, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SSIS, SSIS Package

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…

SQL Azure vs SQL Server

August 19, 2011

Kalyan Bandarupalli

Microsoft, SQL Azure, SQL server

No Comments

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…

Creating Firewall rules using SQL Azure

August 7, 2011

Kalyan Bandarupalli

Microsoft, SQL Azure, Windows Azure

No Comments

The firewall feature in Windows Azure portal allows you to store your data securely on cloud which deny all connections by default. The new firewall feature allows you to specify list of IP addresses which can access your SQL…

Running SQL Server JOBS with different user accounts in SQL 2008

July 12, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

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…

Creating a database in SQL Azure

June 20, 2011

Kalyan Bandarupalli

SQL Azure, SQL server

No Comments

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…

Creating a Database Unit Test using Visual Studio 2010

June 19, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, 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.…

Using Memory Beyond 4GB in SQL Server

May 27, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

Physical Address Extension (PAE) allows you to use up to 64 GB of physical memory depending on operating system you use. All existing 32 bit processors supports this extension of memory. PAE mode requires an Intel Architecture processor and…

Analyzing SQL Server Performance using Performance Monitor Counters

May 25, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL Server 2008 R2

No Comments

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…

What is new in SQL Server Code-Named “Denali”?

May 23, 2011

Kalyan Bandarupalli

Denali, SQL server, SQL Server 2008 R2

This post just re-caps the T-SQL features that introduced in SQL Server 2008 and discusses the new T-SQL features in Microsoft SQL Server next version code name “Denali”. Actually there are not any T-SQL features in SQL Server 2008…