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,101 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,345 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,345 reads

Blogs

Power BI Monthly Digest – August 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 14 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Location Data Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Location Data Privacy

TextBox Property>Action>GotoURL for Multiple Values?

By jbalbo

Hi I am using two stuff commands in my query. One gets the date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers