Browse by Tags

• benchmarking
• blocking
• cumulative update
• dmv
• engine
• hints
• hotfix
• knowledge
• monitoring
• optimization
• performance
• performance monitoring
• query
• security
• service pack
• sql server
• tempdb

Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
06 October 08 02:51 AM | SQL Master | 2 Comments   

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself Read More...

Filed under: performance, sql server, query, optimization, hints, performance monitoring, best practices, knowledge, engine

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 Performance issues with Fragmentation and heavy usage of TEMPDB?
15 May 08 01:59 AM | SQL Master | 2 Comments   

Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server Read More...

Filed under: performance, sql server, dmv, tempdb, monitoring, performance monitoring, benchmarking, best practices