Amit Lohia


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2008-05-14 (first published: )

25,641 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2005-06-23

13,446 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2005-06-06

10,360 reads

Blogs

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Beginner’s Guide: Create a File Organizer CLI Tool in Rust

By

Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Read the latest Blogs

Forums

Azure Database Watcher Monitoring

By bokswager

Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...

Can You Ask for a Raise?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Ask for a...

Stored Procedure Generation Script

By Deepam Ghosh

Comments posted to this topic are about the item Stored Procedure Generation Script

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers