By Robert Lemos – The new arch-enemy of Microsoft SQL Server has slammed many networks with bogus data–causing traffic to a server port to jump by a factor of 40 in some reported cases.

Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures you can ensure that your data can be accessed in a much more contro

By Robert Lemos – A new worm that targets Microsoft SQL Server software has inundated networks with thousands of scans for vulnerable database servers, system administrators said Tuesday.The worm, which started spreading Monday, has caused traffic to the server port–a channel for data–used

By Kevin Brown – Developers often take advantage of stored procedures to enhance the performance of database applications that use Microsoft SQL Server. Stored procedures offer a number of advantages over normal SQL statements: They’re precompiled and preoptimized, and they offer some programmable f

Auto-Audit proves a comprehensive, enterprise level tool for auditing Micrsoft SQL Server Databases unmatched on the market today. The tool is both configurable and scriptable and ships with the power of Microsoft VBScript and JScript parser. Whether you are relatively new to SQL Server and just n

By Wylie Wong – The software kingpin is updating its SharePoint Portal Server software to support the company’s overarching .Net strategy to move computing to the Web. The updated software, slated for availability in the middle of next year, will allow nontechnical employees to build corporate porta

You can access Microsoft® SQL Server™ 2000 using HTTP. For more information about the URL syntax that is support by the SQL ISAPI extension, see URL Access. Before queries can be specified using HTTP, a virtual root must be created using the IIS Virtual Directory Management for SQL Server utility.

Reduced time to market is a competitive advantage in today’s fast-moving, information-driven economy. To respond rapidly in this environment, companies must be able to quickly and easily access the information they need to make decisions that impact their customers, sales and profit growth opportuni

By Sanders Kaufman, Jr. – In the case of a .NET architecture, the answer to both questions is a .NET server. In this article, we explore the reasons why there may be an Oracle server in your network, what it will take to move it to SQL Server, and what you will gain by the move.

A worm, code-named “Voyager Alpha Force,” that takes advantage of blank SQL Server system administrator (SA) passwords has been found on the Internet. The worm looks for a SQL Server server by scanning for port 1433, which is the SQL default port. If the worm finds a server, it tries to log in to th