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

Bidding for BIDS

Published 16 July 7 9:18 AM | SSQA.net

BI Development Studi (BIDS) a mixture of using SQL Server Integration Services, Analysis Services, and Reporting Services. This tool uses a common environment - Visual Studio based development environment. Take a Guided Tour about BIDS (you may need Windows...

Filed under: sql server, microsoft, ssas, bids, media, mms

Business Intelligence virtual labs

Published 1 June 7 4:51 AM | SSQA.net

Why not take advantage of testing your knowledge or make use of technology from Microsoft's Business Intelligence features. Microsoft has setup VirtualLabs for BI solutions in order to give in hand information on advantages & features. Excitingly...

Filed under: microsoft, integration, ssis, bi, ssas, business, intelligence, virtual, sharepoint, labs

SQL Server 2005 Analysis Services community samples

Published 29 May 7 4:44 AM | SSQA.net

As the evolution of Analysis Services has taken to new heights in SQL Server 2005 equally the users are looking to deploy on the large scale and having a need to go though the samples that are helpful. So how about referring to a project that contains...

Filed under: sql server, analysis, microsoft, ssis, server, ssas, codeplex

Swiss-knife features in SQL Server to help you

Published 25 May 7 8:11 AM | SSQA.net

Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface....

Filed under: sql server, microsoft, ssis, ssas, ssms, features

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

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