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

See how Resource Governor can help you 'in action' in managing SQL Server resources?

Published 8 February 8 2:11 AM | SSQA.net

As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...

Filed under: application, sql server, management, blogs, security, query, 2008, resource governor

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

Security best practices - personally & technically

Published 26 January 8 8:12 AM | SSQA.net

See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical...

Filed under: business continuity, sql server, microsoft, blogs, integration, security

SQL Server 2008 Data Compression, what it is - how does it work?

Published 3 December 7 7:54 AM | SSQA.net

As you know data compression facility is added onto the SQL Server 2008 version, though this is not a new feature and I would call it as an enhanced feature in SQL Server. This subject of data compression has already been introduced in SQL Server 2005...

Filed under: sql server, performance, microsoft, blogs, security, 2008, ctp, data capture, 2005, compress, data compression