Skip to content
September 27, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • Premium Content (SQLMaestros)
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Rakesh Mishra

SQL Server

SQL Server Data Type Conversion Options in SSIS

August 7, 2012September 16, 2014 - by Rakesh Mishra - 2 Comments.

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 …

SQL Server Data Type Conversion Options in SSIS Read More
SQL Server

SQL Azure Creating your First Database

December 30, 2011September 22, 2014 - by Rakesh Mishra - Leave a Comment

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 …

SQL Azure Creating your First Database Read More
SQL Server

SQL Azure Introduction

December 23, 2011September 23, 2014 - by Rakesh Mishra - Leave a Comment

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. …

SQL Azure Introduction Read More
SQL Server

Import Multiple Files in SSIS Using Multi Flat File

October 27, 2011November 27, 2014 - by Rakesh Mishra - 6 Comments.

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 …

Import Multiple Files in SSIS Using Multi Flat File Read More
SQL Server

Import Multiple Files in SSIS

October 24, 2011October 9, 2014 - by Rakesh Mishra - 3 Comments.

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: …

Import Multiple Files in SSIS Read More
SQL Server

SQL Server Exclusive Lock on Database ‘model’

September 12, 2011November 13, 2014 - by Rakesh Mishra - 3 Comments.

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 …

SQL Server Exclusive Lock on Database ‘model’ Read More
SQL Server

SQL Server and SSIS Data Types

September 8, 2011November 13, 2014 - by Rakesh Mishra - Leave a Comment

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 …

SQL Server and SSIS Data Types Read More
SQL Server

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

July 1, 2011August 27, 2014 - by Rakesh Mishra - 4 Comments.

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 …

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

Configuration SSIS to Work with a Named Instance

June 29, 2011November 17, 2014 - by Rakesh Mishra - 6 Comments.

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 …

Configuration SSIS to Work with a Named Instance Read More
SQL Server

Flavors of SQL Server 2008 R2 Express Edition

June 29, 2011November 17, 2014 - by Rakesh Mishra - 1 Comment

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 …

Flavors of SQL Server 2008 R2 Express Edition Read More

Posts navigation

1 2 Next

Looking for Premium SQL Content?
Check out advanced SQL tutorials
on SQLMaestros


Subscribe to SQLServerGeeks

Free Live Event


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.