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

Whats with 64 bit computing on SQL Server

Published 4 August 7 9:41 AM | SSQA.net

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage...

Filed under: sql server, performance, management, ssis, security, ssas, ssms, ssrs, x64, computing

What we have and what we need in BI?

Published 30 May 7 5:15 AM | SSQA.net

There is no doubt that from SQL Server 2005 version onwards Business Intelligence (BI) solutions has been better as compared to the previous versions. Still it is interested to know what is the Microsoft's strategy on the expansion of BI. Having the...

Filed under: sql server, integration, ssis, bi, ssas, ssrs, business, intelligence

Anti-virus tool on SQL Server

Published 18 May 7 9:33 AM | SSQA.net

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server...

Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba

Beginner in SQL Server Business Intelligence

Published 16 May 7 1:30 PM | SqlServer-QA.net (SSQA)

You may be aware that SQL Server 2005 version provides many new features as compared to other Business Intelligence products with rich media presentations, not only on the presentation layer if you deep dive into the new features there many more to integrate...

Filed under: sql server, microsoft, integration, ssis, ssas, ssrs, business, reporting, intelligence

Get to know new and enhanced business intelligence features in SQL Server 2005

Published 1 May 7 3:19 AM | SqlServer-QA.net (SSQA)

Microsoft is investing a lot to help the Business Intelligence (BI) platform users with the content and get acquaintance to the platform. You are aware BI includes SQL Server Analysis Services, Integration Services and Reporting Services, you can get...

Filed under: sql server, management, microsoft, integration, ssis, ssas, ssms, ssrs, services