(Dennis Fisher) Microsoft Corp. has issued a patch for the first serious vulnerability to be found in the Windows Server 2003 software, which company officials have said is their most secure OS yet.
Tag: sql server
SQL Server Notification Services Developer Overview
Webcast Summary: SQL Server Notification Services is a new powerful notification application platform. The platform helps developers build centralized publish-subscribe (“pub-sub”) applications and deploy them on a large scale. These applications are often used to send notification messages to end-u
How to Buy SQL Server 2000
This link can help you select and purchase the right SQL Server edition for your business. Pricing and licensing information is also available.
INF: How to Write a Variance Query in SQL Server
When you need to make a comparison between a value and the average for that value in the same category, you can execute a variance query. For example, you may want to use a variance query when you want to compare the salary of an employee against the salary of other employees who hold the same title
SQL Server CE Relay
This white paper contains the instructions for setting up connectivity between Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) and SQL Server by using SQL Server CE Relay. SQL Server CE Relay is used to share data with mobile Windows CE–based devices when there is no integrated network
Named Pipe Filename Local Privilege Escalation – @Stake
By Andreas Junestam – While not limited to SQL Server, this vulnerability is especially dangerous to SQL Server as it allows the attacker to gain SQL Server service context. The vulnerability has been addressed in Windows 2000 SP4. Still another reason to minimize SQL Server service context.
Application Incompatibilities Complicate Migration to Windows Server 2003
By Barbara Darrow – The migration must encompass major architectural changes to the portal software itself, including a move onto SQL Server from the old Web Storage System on the database side.
Marking Milestones
By Michael Otey – SQL Server reached significant milestones in performance and overall market share this past year. But Microsoft faces the challenge of keeping SQL Server affordable and easy to use while adding advanced features aimed at the enterprise.
Watch your timeouts – DBA’s quick guide to timeouts, by Chris Kempster
In this article, Chris discusses in detail, the various types of timeout problems, and show you how to alter various settings to address timeout errors. He also provides VB code samples along with this article.
TOP N Clause vs. SET ROWCOUNT N
Q. Is using the TOP N clause faster than using SET ROWCOUNT N to return a specific number of rows from a query? A. With proper indexes, the TOP N clause and SET ROWCOUNT N statement are equally fast, but with unsorted input from a heap, TOP N is faster.
