Browse by Tags

SQL Injection attacks - don't forget to visit guidance information from Microsoft

Published 31 May 8 3:59 PM | SSQA.net

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...

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

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

Published 14 May 8 3:23 AM | SSQA.net

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

Published 26 March 8 3:1 AM | SSQA.net

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...

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

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

Published 29 February 8 4:4 AM | SSQA.net

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...

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

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?

Published 5 February 8 2:57 AM | SSQA.net

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...

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

SQL Server indexing - when to reorganize or rebuild?

Published 21 January 8 4:30 AM | SSQA.net

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...

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

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

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...

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