By Brian Moran – The software-bug accountability debate continues as readers share their responses and suggestions for solving this lack of quality control.
Tag: sql server
Introduction to SQL-DMO
Most SQL Server administrative tasks are programmable thanks to a set of objects known as SQL-DMO. This article introduces the concepts of programming DMO, and steps you through some basic, and commonly requested examples.
SQL Server 2000 Security Update for Service Pack 2
Microsoft released another security update for SQL Server 2000. This page has been updated with security releases from August 14th, 2002 and August 15th, 2002.
Foam – FOR XML EXPLICIT Tool
Foam is a .Net Windows application that is used to ease the creation of FOR XML EXPLICIT queries for use with MS SQL Server 2000. Foam does this by taking an XML document that you have formatted according to the incredibly simple structure specified below, and then parsing through the document to cr
Programming Visual Basic .NET: ADO.NET
Many software applications benefit from storing their data in database management systems. In this book excerpt, the author show you how to connect to a SQL Server using ADO.
HOWTO: Retrieve XML Data by Using a SQL XML Query
If you run an ADODB command stream and specify SQL SELECT with the FOR XML AUTO clause, an XML document stream is fetched from SQL Server and displayed in the Visual Basic Intermediate window.
Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework
Discover best practices and suggestions for working with Microsoft SQL Server and Microsoft Analysis Services for analytic applications. These practices and suggestions have been compiled from answers to questions submitted by developers and customers, and cover topics ranging from dimensional model
Microsoft’s JDBC Driver for SQL Server Stacks Up Against Competition
Microsoft recently released its SQL Server 2000 Driver for JDBC. Dr. Heinz Kabutz demonstrates how he put this Type 4 driver to the test against some other JDBC drivers currently available, including the JDBC-ODBC Bridge. He also explains why as a Java developer he’s so pleased to finally see this M
How to Interact with SQL Server’s Data and Procedure Cache
by Randy Dyess – As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool t
Help: ADO Truncates milliseconds from SQL Server Datetime columns
When I query a SQL Server Database using ADO 2.6 – the data from Datetime columns comes back WITHOUT Milliseconds.