SqlServer-QA.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 of a hardware or software failure, also it could be one of the reasons such as ...

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 tools to help you manage packages for ETL processes more effectively. To be specific about IS ...

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, but using few statements you could get it, by ...

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 to fetch the data. As per the configuration when it tries to refresh data in the pivot ...

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 since, for example, two of the four servers could go down. In the majority of cases, ...

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, data mining etc. For any sort of performance analysis exercise you must ...

http://www.microsoft.com/india/webcasts/default.aspx Aug - 28th ; 14:00 - 15:30  ISTSQL Server 2005: Reading Execution PlansThe toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this webcast removes this myth. We will walk you through the various operators and what they ...

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 the Publisher are usually delivered to the Subscriber as they occur (in near real ...

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 of these systems is with 64-bit editions of Microsoft Windows products.  Same way SQL ...

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)[Video]