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,040 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,338 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

Data Masker Reads Column Classificiations

By

One of the newer features in Data Masker for SQL Server is the ability...

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

By

Yesterday in this post I described a method to correct permissions when upgrading a...

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

error trying to create another log file

By Snargables

For some reason I'm unable to create another log file. Ideas? ALTER DATABASE [DBNAME]...

One machine is not able to connect to sql server while others connect fine

By Partha Mandayam

One of our machines is not able to connect to sql server It gives...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The CTE Insert

See possible answers