SqlServer-QA.net

You may have seen the sp_replwriterovarbin - New SQL Server Injection-Based Attack Found vulerability about the new public reports of a vulnerability that could allow remote code execution on systems with supported editions of SQL Server 2000, 2005, 2005 Express Edition, 2000 Desktop Engine (MSDE 2000), and Windows Internal Database (WYukon). ...

Another security vulnerability or rather call in the sense of security experts that ''A zero day vulnerability has been reported in SQL Server''!  Though its a not serious flaw or problematic loophole to worry but still its a security flaw in using the sp_replwriterovarbin extended stored procedure, which is an undocumented one as per ...

Here is the email extract that we get from Microsoft CSS Team:  What is the purpose of this alert? This alert is to provide you with an overview of the new security bulletins being released on December 9, 2008. Security bulletins are released monthly to resolve critical problem vulnerabilities.   New Security Bulletins: ...

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 best practices and rules to secure the database & web environment to avoid any escalation ...

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 it is most important factor you need to follow as per the compliance standards that are ...

Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required to retrieve a report if the report is large or accessed frequently. Bear in mind that ...

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server 2005 offers a number of ...

Various options availability from the SQL Server using a Cluster and Standby server technologies, this whitepaper helps you to understand what best or solution can be applied to your business availability & continuity.

Bob Beauchemin from SQL Skills released a white paper highlighting the operational and administrative tasks associated with SQL Server that help ensure a more secure SQL Server system. The whitepaper can be downloaded from here

When you have a Vista operating system along with SQL Server, the common error you get when trying to perform any sort of SYSADMIN sort of tasks. For instance when creating a database:  TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Database 'dbname'.  ...