By Shane Dovers – Optimum portability is one of the most important goals in creating a Data Transformation Services package that can execute properly on virtually any server.

By Vyas Kondreddi – Are you a VB, Web or Windows developer? Completely new to SQL programming? Look no further! This book is just for you. “Murach’s SQL for SQL Server” is a good first book for anyone interested in learning the basics of SQL programming, and becoming a database developer, or probabl

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

(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

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.

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 Parthasarathy Mandayam – Here’s a simple script that can be customized to quickly grant permissions to various users on all tables or stored procedures. Using this script I was able to reduce the time taken to grant permissions during installation from 30 minutes to 1 second! It is much faster th

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

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.