Amit Lohia


Overview of SSIS

SQL Server Integration Services, the ETL subsystem for SQL Server 2005, is a new paradigm of development for the SQL Server DBA. It is one of the most popular, and also complex, environments that many people work with in SQL Server 2005. Amit Lohia brings us an introduction to this environment along with the basics of building and deploying a package.

4.71 (7)

2008-05-14 (first published: )

25,170 reads

Finding Table Space

One of the most popular questions on SQL Server 2000 deals with determining how much space the various tables in your database take up. There are a variety of reasons for this and a few ways to gather the information. Author Amit Lohia takes a look at how sp_spaceused works and how you might customize it to suit your needs.

5 (2)

2005-06-23

13,352 reads

Suggestions for Datatypes

SQL Server 2000 does a lot of things for the DBA, tuning, updating statistics, scheduling tasks, wizards and more. But one thing that it does not help with is choosing the correct data type for your data. New author Amit Lohia brings us a technique and some code that will examine your existing data and suggest places where another data type might be a better choice.

5 (1)

2005-06-06

10,346 reads

Blogs

Ethics in Modern Data this Saturday with the South Florida Data Geeks

By

This Saturday Aug 7, Christine and I will present our joint presentation on Ethics...

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Read the latest Blogs

Forums

Minimun Role Permissions Needed

By Lou

Hi Friends, Please some guidance, To import a bacpac file in a MI instance,...

Need counts of payment amounts per week grouped by week

By joewhite

Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...

Import CSV Data Into Existing Tables

By VSCurtis

Hi Guys, I am having issues trying to import data from CSV files into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers