Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Amit Lohia

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

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.   Read more...
By Amit Lohia 2007/06/18 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 24,877 reads

SQL Server Management Studio

After quite a few versions, Enterprise Manager is being retired. SQL Server 2005 will have a new management tool called the SQL Server Management Studio (SSMS). Amit Lohia brings us a first look at some of the features of this new tool.   Read more...
By Amit Lohia 2006/11/24 (first published: 2005/07/07) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 31,504 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.   Read more...
By Amit Lohia 2005/06/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,318 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.   Read more...
By Amit Lohia 2005/06/06 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 10,337 reads
   Items 1 to 4 of 4