Free

Managing SQL Server on a Tight Budget

Event Information

Share this event

Date and Time

Location

Location

HCC Business Training Center

6751 Columbia Gateway Drive

Columbia, MD 21046

View Map

Event description

Description

Sponsor: MSSQLTips.com

Title - Managing SQL Server on a Tight Budget


Abstract - If you are a good SQL Server Database Administrator, you know that there are best practices on how to manage a SQL Server environment in a company. But when you have a very limited budget there are some situations on which you can’t comply with best practices, yet you are still responsible for keeping the servers up and running.

Disk Space Issues Strategies: When the free space is not enough.
> Shrinking files to release space.
> Moving data between data files.

Consequences on Log Files of shrinking.
> Excessive VLF in Log Files.
> Performance Impact on ETL Process.

Excessive Virtualization.
> Identifying the Effects caused on SQL Server when the Hypervisor doesn’t give resources.

ETL Processes Migration.
> Importing Mainframe Data with SQL Server Integration Services.
> Export SQL Server Data with Integration Services to a Mainframe.
> Importing Mainframe Data including Packed Numbers with SQL Server Integration Services.


Speaker - Daniel Farina

Share with friends

Date and Time

Location

HCC Business Training Center

6751 Columbia Gateway Drive

Columbia, MD 21046

View Map

Save This Event

Event Saved