Browse by Tags

• attacks
• authentication
• benchmarking
• blocking
• clustered
• clustering
• dba
• dbcc
• defrag
• disk space
• diskkeeper
• dmv
• environment
• file
• forums
• index plan
• indexes
• injection
• links
• management
• microsoft
• monitoring
• msdn
• newsgroups
• object
• performance
• performance monitoring
• query
• rebuild
• reference
• reorganize
• san
• schedule
• schema
• security
• showcontig
• slow query
• sql server
• sql server central
• technet

SQL Injection attacks - don't forget to visit guidance information from Microsoft
31 May 08 01:59 PM | SQL Master | 4 Comments   

One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding security-related Read More...

Filed under: sql server, security, authentication, best practice, blogs, injection, reference, attacks

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
26 March 08 01:01 AM | SQL Master | 5 Comments   

Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best Read More...

Filed under: performance, sql server, dbcc, object, best practice, defrag, showcontig, blogs, disk space, monitoring, diskkeeper, file

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
29 February 08 03:04 AM | SQL Master | 4 Comments   

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the Read More...

Filed under: performance, sql server, clustered, best practice, clustering, blogs, monitoring, environment, benchmarking, san

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
05 February 08 01:57 AM | SQL Master | 6 Comments   

SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question Read More...

Filed under: performance, sql server, security, query, blocking, best practice, blogs, index plan, newsgroups, sql server central, forums

SQL Server indexing - when to reorganize or rebuild?
21 January 08 03:30 AM | SQL Master | 4 Comments   

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts Read More...

Filed under: sql server, indexes, msdn, rebuild, schema, best practice, blogs, performance monitoring, reorganize, links, schedule

SQL Server: How do I identify the queries that are worth tuning?
16 November 07 06:02 AM | SQL Master | 2 Comments   

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Read More...

Filed under: performance, sql server, microsoft, management, dmv, dba, best practice, blogs, technet, slow query