Browse by Tags

• best practice
• best practices
• blocking
• cumulative update
• guidance
• hotfix
• indexes
• performance
• plan guide
• planning
• security
• services
• sql server
• testing
• vulnerability

Microsoft Security Bulletin Summary for July 2008 - what is it now?
09 July 08 01:07 AM | SQL Master | 2 Comments   

I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating Read More...

Filed under: sql server, security, hotfix, best practice, service pack, guidance, vulnerability

SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?
23 May 08 01:44 AM | SQL Master | 2 Comments   

Secured by default, secured by design is the buzzword and catchy stuff for any Enterprise IT administrators. Then it comes about standards and policies to follow such as ISO , with the recent threats (last 10 years) and vulnerabilities within IT world Read More...

Filed under: sql server, security, blocking, hotfix, service pack, best practices, cumulative update

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
30 October 07 08:41 PM | SQL Master | 2 Comments   

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results Read More...

Filed under: performance, sql server, indexes, planning, testing, hotfix, services, best practice, service pack, plan guide