Product Announcement – mssqlXpress is the latest full-featured integrated development environment (IDE) for MS SQL.

(Vyas Kondreddi) Here are some SQL Server DBA/Developer interview questions I faced myself personally and/or heard from people. I will try to answer these questions briefly here, but be advised that these answers may not be complete and it will be better for you to go through text books, books onlin

Microsoft SQL Server 2000 Service Pack 3a (SP3a) update is available and replaces the previously released SP3. If you successfully upgraded to SP3, you may not have to apply SP3a. This Support WebCast will talk about what changed and how to decide if applying SP3a in your environment is appropriate.

By Joseph Sack – I’ve often been asked what the “best” method is for trapping DTS errors. This is a very broad question. What errors you care about capturing can differ from project to project, and package to package.

By Martin LaMonica – The software maker plans to release an update to its Visual Studio.Net development tool bundle, code-named Whidbey, in the latter half of 2004, timed to coincide with the introduction of an overhaul to its SQL Server database, code-named Yukon.

By Gregory A. Larsen – Microsoft SQL server does not support a method of identifying the row numbers for records stored on disk, although there are a number of different techniques to associate a sequential number with a row. This article will show various different methods of assigning a record seq

SQL Server Security by Chip Andrews, David Litchfield – Addresses SQL Server vulnerabilities and provides security solutions. Covers installation, administration, and programming–plus security issues such as authentication, encryption, intrusion detection, and more. Written for IT professionals adm

By Joseph Sack – Have you ever been asked a seemingly simple question about a SQL Server configuration, and realize that you do not remember (or do not know) the answer?Some information is critical to rebuilding your SQL Server machine in the event of a disaster. I’ve compiled seven question

Learn about three common deployment options for the Voicemail .NET Alerts Quick Start Kit, plus Notification Services architecture basics and security considerations.

By Brian Moran – Microsoft’s original Web page describing SP3a didn’t specify what new features the service pack included or whether you needed to apply SP3a if you were already using SP3. Clearer answers to these questions are now available.