Browse by Tags

SQL Server ETL Performance during Data Load Optimization

Published 20 December 7 8:40 AM | SSQA.net

Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL...

Filed under: sql server, performance, indexes, backup, etl, disable, bulk insert, slow query, alter index, load

Disable SA account on a live SQL Server2005 instance, any drawbacks?

Published 13 August 7 4:3 AM | SSQA.net

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more...

Filed under: sql server, management, microsoft, security, windows, login, sa, disable, authentication, mixed