Browse by Tags

All Tags » sql server » ssas (RSS)
SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)
Published 2 May 8 9:12 AM | SSQA.net
Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...
Filed under: , , , , , , ,
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: , , , , , , , , , ,
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: , , , , , , ,
OLAP Connectivity from Pivot Table in Excel - security permissions
Published 25 September 7 4:14 AM | SSQA.net
Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...
Filed under: , , , , , , , ,
Whats the best way to setup memory on a four-node cluster?
Published 6 September 7 4:42 AM | SSQA.net
Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...
Filed under: , , , , , , , , ,
Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks
Published 5 September 7 4:34 AM | SSQA.net
Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries...
Filed under: , , , , , , ,
August - Webcast on Reading Execution Plan & Query Tunning
Published 16 August 7 5:43 AM | SSQA.net
http://www.microsoft.com/india/webcasts/default.aspx Aug - 28th ; 14:00 - 15:30 IST SQL Server 2005: Reading Execution Plans The toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this...
Filed under: , , , , , ,
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: , , , , , , , ,
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: , , , , , , , , ,
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: , , , , ,
A Guided Tour to SQL Server Integration Services (SSIS)
Published 16 July 7 8:2 AM | SSQA.net
I have been asked many of our developers and even got through few questions asking about how to understand SQL Server Integration Services which is a traditional extract methods with a transform, and load (or ETL) model of integrating data from standard...
Filed under: , , , , , ,
BI Survey - world's largest independent survey about your experience
Published 10 July 7 12:59 PM | SSQA.net
If you would like to share your experience in managing Business Intelligence products and applications that are used in business/corporate/enterprise performance management, as a whole it is called OLAP. This survey is to help in identifying the trends...
Filed under: , , , ,
SSIS and Disaster Recovery Planning in multi-user environment
Published 25 June 7 4:50 AM | SSQA.net
I have had an interesting discussion in SSP World about how to grant access & privileges to handle SSIS packages in a high availability and Disaster Recovery scenario. As you may be aware that privilege involves having access to Distributed COM components...
Filed under: , , , , , ,
SQL Server 2008 June CTP: Analysis Services - Dimension Design
Published 11 June 7 5:36 AM | SSQA.net
This is the first of the 6 technical Live meeting series we have planned for you. In this session you will hear directly from Robert Zare who leads this improvement team. AS-Dimension Design enhances UI for creating and editing dimensions to guide users...
Filed under: , , , ,
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 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: , , , , , ,
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: , , , , ,
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: , , , , , , , , , ,
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: , , , , , , , ,
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: , , , , , ,
More Posts Next page »