Log in | Register

Rakesh Mishra, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Rakesh Mishra, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



About Rakesh Mishra

This author has not yet filled in any details.
So far Rakesh Mishra has created 18 entries.

SQL Server Data Type Conversion Options in SSIS

SQL Server Data type conversion is one of the most common tasks in any ETL process. There are several ways of data conversion in SSIS. We have Special “Data Conversion” transformation task or we can use derive column to change data type of a column or we can change the data type while reading […]

By |August 7th, 2012|Categories: SQL Server|Tags: , |2 Comments

SQL Azure Creating your First Database

In my previous post Introduction: SQL Azure; we had a brief introduction of SQL Azure and how this is different from SQL Server. This blog post will illustrate “How to create database” in SQL Azure (SQL Azure Creating your First Database).
To create a database in SQL Azure (Evolution Edition), all you need is a […]

By |December 30th, 2011|Categories: SQL Server|Tags: , |0 Comments

SQL Azure Introduction

SQL Azure Introduction

SQL Azure is part of Microsoft Azure Service Platform which provides data storage/manipulations capabilities to the platform. SQL Azure uses a special version of SQL Server as backend. This provides two editions of database namely   Business Edition and Web Edition. Maximum database size in Business edition can be of 150 GB and […]

By |December 23rd, 2011|Categories: SQL Server|Tags: |0 Comments

Import Multiple Files in SSIS Using Multi Flat File

In my previous post, I have discussed about various options available in SSIS to load multiple flat files. One of the mentioned options is using “MultiFlatFile”. A multi flat file connection allows us to access multiple files in parallel i.e. we can read data from multiple files in parallel and it produces data as […]

Import Multiple Files in SSIS

Many times we require to import multiple files in SSIS. There are various ways to achieve this and the best option depends upon on case to case. The available options are:

For Each Loop and a variable to create dynamic connection
In Single dataflow, use separate Connection for different files and use “Union All” or separate […]

By |October 24th, 2011|Categories: SQL Server|Tags: , |3 Comments

SQL Server Exclusive Lock on Database ‘model’

model database is one of the sytem databases that act as a template database for creating new database, also the size of new database should be greater or equal to model database. We can create, modify and drop objects in the Model database. The newly created database will have all the DB objects including […]

By |September 12th, 2011|Categories: SQL Server|Tags: |3 Comments

SQL Server and SSIS Data Types

Many times we are in need of cross-references between SQL Server data types and the data types available with SQL Server Integration Services. This is very much needed when we require to set a variable in SSIS from a result set returned from Execute SQL Task or when we need to pass parameters to […]

By |September 8th, 2011|Categories: SQL Server|Tags: , |0 Comments

SQL Server: CSS kind of Approach for formatting Reports in SSRS

Till now, SSRS does not support Cascading Style Sheets (CSS) or themes & skins that are available with HTML or .Net development. The approach that I am going to describe is very helpful and I hope it will increase productivity by avoiding repetitive and laborious report element formatting that we usually do during report development. […]

Configuration SSIS to Work with a Named Instance

SQL Server family has various services like Database Services (SQL Server), Analysis Services, Reporting Services which supports Named Instance of the services but there are few others like Integration Services which does support named instance. This means, we can have one and only one service of Integration Services on each server.

By default, the MSDB […]

By |June 29th, 2011|Categories: SQL Server|Tags: |6 Comments

Flavors of SQL Server 2008 R2 Express Edition

SQL Server 2008 R2 Express, a free edition of SQL Server is ideal for learning and building applications for desktops, servers and the web.
One of the biggest changes from its previous versions is the maximum size of database that can be supported on Express editions. The current version of Express Edition supports databases of […]