(Serdar Yegulalp) Just like Windows Server, SQL Server can be administered directly on the computer to which it’s installed or from a remote computer. One common remote-administration technique is to use SQL Server Enterprise Manager, which can connect to a remote SQL Server via TCP/IP, named pipes

The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: • When you run a query in Microsoft SQL Server 2000 that has many items in the IN clause, you may receive the following error message: Server: Msg 3628, Level 16, State 1, Line 2 A floating point exception occurre

When you run a snapshot backup command from a Microsoft SQL Server Virtual Device Interface (VDI) application, the backup may not be finished successfully if the following conditions are true: • Multiple VDI snapshot backups are occurring. • The thaw command (CompleteCommand) has not been is

(Brad M. McGehee) If you have gotten this far, you have done a lot of reading. In this final article on how to perform a SQL Server Audit, we will take a look at some best practices about how to best implement a SQL Server Performance Audit. You will want to read this before you begin any actual per

(Vinod Kumar) The amount of features introduced in SQL Server 2005 are numerous. I think we have taken a tour of some T-SQL enhancements, DTS a.k.a. SSIS, XML and others before. But in this article we will take a look at another toolset that is available in SQL Server 2000 world but has been enhance

(Jim Duffy) Microsoft has introduced a number of new features and enhancements in the T-SQL language in SQL Server 2005. Some of the new features include the PIVOT and UNPIVOT commands, CTE, DDL (data definition language) triggers, error and exception handling with the TRY/CATCH block, and ranking f

(Mike Gunderloy) Microsoft SQL Server supports T-SQL, an implementation of ANSI standard SQL. T-SQL is designed to (among other things) search for matches in your data.

(Narayana Vyas Kondreddi) Recently, SwisSQL approached me for a review of their product that can convert SQL statements from one dialect to another. They told me that “SwisSQL SQLOne Console” is a GUI application that can convert SQL statements from one RDBMS implementation to another and the dialec

(Ron Talmage) Part I of this article described the transaction-based SNAPSHOT isolation level. At the time Part I was written, just prior to the release of Beta 2, only the SNAPSHOT isolation level was fully documented. With the release of SQL Server 2005 Beta 2, a fuller explanation of a second typ

(Andrew Novick) The theme this month is logging messages so that they get to the proper human. In the last issue I discussed the SQL Server ErrorLog and showed a stored procedure, dba_ErrorLog_Search that can be used to search the current log. It turns out that SQL Server Agent also has an error l