Browse by Tags

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?

Published 19 December 7 6:6 AM | SSQA.net

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes'...

Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring

SQL Server - database maintenance gotchas

Published 3 December 7 12:43 PM | SSQA.net

What kind of database maintenance operations you should be doing when you are DBA? You should have better understanding on the terms in managing the Database platform at your end, without proper information it is very hard to say you are managing your...

Filed under: dashboard, sql server, performance, databases, security, maintenance plan

SQL Server 2005 using Cryptography & Encryption what they are for?

Published 13 September 7 7:46 AM | SSQA.net

Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication...

Filed under: sql server, performance, databases, microsoft, security, audit, encryption, authentication, authorization, cryptography

SET TRUSTWORTHY ON when using SP_CONFIGURE

Published 17 July 7 4:9 AM | SSQA.net

SET TRUSTWORTHY ON, from the name itself it sounds like you are not allowing anything that cannot be trusted. SQL Server 2005 has introduced a new database property called TRUSTWORTHY that is used to indicate whether the instance of SQL Server trusts...

Filed under: sql server, performance, databases, security, alter, trustworthy

Restrict Access to SQL Server using "Certificates"

Published 2 July 7 4:7 AM | SSQA.net

Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer...

Filed under: sql server, performance, databases, security, access, encryption, certificate