(Gregory A. Larsen) Having a consistent SQL Server environment is important. Knowing that all your SQL Server machines are setup the same helps to minimizing confusion when managing multiple machines. If you have lots of machines, it is absolutely imperative that all your SQL Server setups be the sa
Author: SSWUG Research
Monitoring server disk space in SQL Server
(Hilary Cotter) DBAs must monitor their SQL Servers carefully to ensure that the system and user databases have sufficient disk space for the life time of the applications using these SQL Servers. (R)
Adding Processes to HTML DB Applications
(Lawrence Linnemeyer and Bradley Brown) In this second part of a three-part series covering HTML DB applications, you will learn about processes.
Enforce resource property semantics with metadata
(Dan Jemiolo) The WS-ResourceProperties specification defines a standard for declaring strongly-typed properties as part of a Web service interface, but it does not say anything about permissions, validation, and other important topics. Fortunately, the WS-ResourceFramework authors have provided a n
Using C#’s yield to Return an Enumerable Collection
(Paul Kimmel) Throughout the years I have said that the CodeDOM would offer some pretty cool capabilities. Well, Microsoft stuck a new one in the seemingly innocuous phrases yield return and yield break. In this article, you learn how this new word pairing works and how using the inline state machin
DB2 Change Management Expert, Part 2: Database version control with DB2 Change Management Expert
(Carolyn Henry, Marcia Miskimen, Jayashree Ramachandran and Sailaja Bandlamoori) Have you ever wondered when the database was changed? With IBM DB2 Change Management Expert wonder no more! This tool can help you keep track of changes, work seamlessly with other team members, reverse or undo changes,
Automate your .Net build – II
(Partha S) Continuing with the last entry – Automate your .Net build – I , in this post we shall see what are the ways to get your build files created from the Visual Studio projects, instead of manually creating the file. Note that I have used the next steps on Visual Studio .Net 2003 – they may ap
Thoughts on DB2 as a MySQL storage engine
(Daniel Krook) IBM and MySQL have announced plans to port MySQL to IBM’s mid-range i5/OS servers.
VSAM to DB2 conversions: Expert advice and user tip contest
(Kathryn Marquis) Migrating from VSAM to DB2 isn’t easy, but as SearchDataManagement.com experts and readers point out, it can help ease data access to diverse data sources. However, organizations must be careful when they approach the project, warns Craig Mullins, site expert on SearchDataManagemen
MARS (Multiple Active Result Set)
(Abey George Peter) MARS is a new feature in ado.net 2.0 and Sql Server 2005 that allows for multiple forward only read only result sets.