(Carvin Wilson) The SQL Distributed Management Objects (SQL-DMO) provide a set of OLE objects that enable applications to use management features of SQL Server. This functionality helps to extend the capabilities of SQL Server by providing access to any 32-bit OLE-compliant application. This art

(Robert L. Bogue) When looking at SQL performance there’s an immediate desire to jump into the queries that a SQL Server is being forced to process and see what can be done to improve them. Unfortunately, it’s not always that simple. Sometimes the queries come from packaged software that cannot be c

(John Papa) When your goal is a scalable and efficient enterprise solution, you need to develop an efficient data-access strategy. You can’t just do some testing on your production machines and rely on the results. While an application can exhibit excellent response times when serving a few users, p

(Marcin Policht) So far, in our series of articles, we have presented the most significant new and enhanced features available in Microsoft’s SQL Server 2005 Beta 2, but neglected to provide you with information regarding its installation. While it is more than likely that, by now, you already have

(Gayathri Gokul) Moving the responsibility for data integrity into the database has been revolutionary to database management. Constraints in Microsoft SQL Server 2000 allow us to define the ways in which we can automatically enforce the integrity of a database. Constraints define rules regardin

(Bob Beauchemin) A user-defined type must be defined in the SQL Server catalog to be visible to SQL Server stored procedures and other T-SQL procedural code, just as an assembly is. Once a UDT is defined in the SQL Server catalog, users need the appropriate permission to invoke it, just as they do f

(Brad M. McGehee) You may find it hard to believe, but it is possible to maintain SQL Server high availability and not spend a fortune. In fact, you can spend a fortune and still not get SQL Server high availability. Sound like a paradox? Not really. SQL Server high availability is not a direct func

(Larry Chesnut) Not too long ago, I was in LA doing a Yukon Ascend delivery for Hilton Hotels, and I had a student in my class who asked about the memory utilization of SSIS, the replacement for the old DTS. The student asked about two items in particular; one, can the service and the packages that

(E.Bertino, D.Bruschi, S.Franzoni, I.Nai-Fovino and S.Valtolina) In this paper we present the results from an analysis focusing on security threats that can arise against an SQL server when included in Web application environments. The approach used is based on the STRIDE classification methodol

(Arun Marathe and Boris Baryshnikov) Build an application to extract a query’s estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-