Browse by Tags

SQL Server Business Intelligence - adopt sustainable practices on ETL processes with SSIS

Published 24 April 8 6:14 AM | SSQA.net

Making best use of SQL Server Integration Services within your ETL processes is a flexible choice, which has a huge share within the Business Intelligence application platform. You may be aware that SSIS introduces several new and enhanced features and...

Filed under: sql server, ssis, ssas, ssrs, machine, bids, etl, administrator, biztalk, business intelligence, adapter

Windows Server 2008 Terminal Services - extra benefit in using SQL Server 2008 Managment Studio to connect remotely

Published 8 April 8 2:45 AM | SSQA.net

To make better use of features and enhancement within Windows Server 2008 release and SQL Server 2008, where the ability to connect the Management Studio (SSMS 2008) at the server rather than running it locally. Buck Woody SQL Program Manager has given...

Filed under: sql server, machine, 2008, multiple, new features, windows server, benefit, terminal services, remotely

Analysis Services 2000 & 2005 on same server?

Published 10 May 7 3:39 AM | SqlServer-QA.net (SSQA)

Can we handle SQL Server Analysis Services 2000 and 2005 versions on the same server? Yes it is possible, but in the real sense you have to more careful to attain the performance by having a high-end specificiation hardware to cope up the pressure. Theoritically...

Filed under: mdx, analysis, microsoft, server, machine