Browse by Tags

How to find which version of Analysis Services you are running?

Published 5 November 7 11:54 PM | SSQA.net

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out!...

Filed under: sql server, databases, microsoft, integration, ssis, ssas, version, Analysis Services

Dust out few tasks to gain transactional replication performance in SQL 2005

Published 16 August 7 4:20 AM | SSQA.net

Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at...

Filed under: sql server, performance, integration, tuning, ssas, ssms, replication, transactional, hardware

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

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

Taking advantages of Cryptographic features in SQL 2005 - security

Published 12 May 7 5:16 AM | SqlServer-QA.net (SSQA)

When I had a chance to know about encryption features in SQL Server I always go with books online as a first hand information, but there is more to ask about this feature in 2005 version: Have you ever thought about encryption in SQL Server, how to implement...

Filed under: sql server, integration, ssis, security, ssas, cache, entry

Data explosion and attributes in BI

Published 10 May 7 8:4 AM | SqlServer-QA.net (SSQA)

One of our Business Manager has asked can we handle the data explosion and BI requirement to handle billions of rows for their Sales pitch using SQL Server Analysis Servers. The obvious answer was 'yes' using the latest version of SQL Server and...

Filed under: sql server, analysis, integration, ssis, bi, ssas, attributes, business

First-ever Worldwide Microsoft Business Intelligence Conference - Seattle

Published 3 May 7 5:40 AM | SqlServer-QA.net (SSQA)

First-ever Worldwide Microsoft Business Intelligence Conference - Seattle Gain insight from industry thought leaders, learn about the success of other Microsoft BI customers from your peers, discover best practices and gain valuable product knowledge...

Filed under: sql server, microsoft, integration, ssas

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