Get security recommendations on Microsoft SQL Server installation, administration, and deployment, and dig into the details of the SQL Server security model. This paper applies to SQL Server 2000 Service Pack 3 (SP3). It is intended for administrators and developers.

(Randy Dyess) As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server’s locking scheme and force a particular range of locks on a table. Transact-SQL provides you with a set of table-level locking hint

Some instances of the SQL Server 2000 Personal Edition and the SQL Server 2000 Desktop Engine (also known as MSDE 2000) may operate as local data stores, used only by applications that are running on the same computer. If network connections are never made to these instances of MSDE 2000, the instan

By Brian Moran – All too often, people shortsightedly focus on managing the physical symptoms of their performance problems. You should always begin by trying to identify the root causes of the performance problem.

(Peter Galli and Anne Chen) Microsoft Corp. and its customers need to take joint responsibility for security issues such as the SQL Slammer worm, which brought down systems all across the world earlier this year, several large enterprises said here at the TechEd conference on Monday.

By Peter Galli and Lisa Vaas – Microsoft Corp., influenced by customer feedback, is delaying the release of the next version of SQL Server database, code-named Yukon, so that it can do the necessary quality assurance and because the Visual Studio .Net team has asked for more time.

By Barbara Darrow – In a change of plans, Microsoft now aims to roll out reporting services for the current SQL Server database release.