Browse by Tags

• .net
• advisory
• benchmarking
• blocking
• cumulative update
• dmv
• engine
• hints
• hotfix
• knowledge
• monitoring
• optimization
• performance
• performance monitoring
• query
• security
• service pack
• sql authentication
• sql injection
• tempdb
• tools

Tools that can help to secure SQL server security within web environment
21 October 08 12:47 AM | SQL Master | 3 Comments   

When the SQL Server is faced to the internet then you have to take utmost care to ensure that the each row in the table is not compromised to avoid any unprecedented activity. As it is getting popular that rise in SQL injection attacks has reminded the Read More...

Filed under: sql server, security, sql authentication, tools, best practices, .net, advisory, sql injection

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