Browse by Tags

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: sql server, security, ssas, ssms, olap, excel, pivot, execute, credentials

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: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

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: sql server, performance, management, ssis, security, ssas, ssms, ssrs, x64, computing

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, ssis, security, ssas, users, recovery, disaster

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

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