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! I mean there isn't a straight way to find out...
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 Media player to view this show)...( read more...
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 in participating any of virtual labs will get...
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 Analysis Services (latest edition) samples contributed...
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. May be it is a smaller system or mission-critical...
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 that is dedicated to databases, rather tighten...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
05-18-2007
Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba
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 all the Business solutions with 1 shot using...
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 from Microsoft’s product experts. This is a 3-day...
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 to know by referring to the media presentation and...