(Francois Degrelle) Here is a way that allows following the progression of a stored procedure.
Other News
Binding Windows.Forms Controls to Indexed Object Properties in VB.NET
(cigwork) One of the redeeming features of VB.NET — and VB before it — is the ease with which it is possible to create indexed properties.
Loading a MySQL database in memory (with some Ruby help)
(Jorge Bernal) Let’s say when you have to run a batch process monthly, you can survive with times like 10 minutes. I can imagine a lot of seasoned DBAs right now ROFL about my insignificant 10 minutes. The point here is I was developing this process and some test cases, so my usual trial/error metho
Two Types of XML Schema Language
(Roger L. Costello and Robin A. Simmons) XML schema languages come in two types: 1. Grammar-based schema languages 2. Rule-based schema languages This paper discusses which schema language is appropriate for a specific purpose.
SQL Server 2005 Express Edition – Part 1
(Marcin Policht) In order to address the diverse needs of its customers as well as to provide balance between offered feature sets, hardware/software footprints, and pricing, Microsoft has been consistently diversifying its database management portfolio, delivering several options with each new rele
Visual Basic Fusion: Best Practices to Use Visual Basic 6 and Visual Basic .NET Together
(Scott Swigart) A Microsoft Visual Basic 6 application can access .NET class libraries, but to do so, it must go through an interoperability layer, known as a client callable wrapper. This wraps the desired .NET class, and exposes it so that it appears as a traditional COM object, which can be used
Exploring Secrets of the .NET DataGridView and Dynamic Data Manipulation
(Michael Sorens) With the visual designer of Visual Studio 2005 it’s simple and straightforward to stir together a database connection, a SQL query, and a DataGridView control to get a Windows WYSIWYG application. Toss in a few buttons, a dollop of labels, and a text box or two, and you can provide
SQL Server cluster design: One big cluster vs. small clusters
(Michelle Gutzait) Many organizations that have been slowly deploying SQL Server databases on different servers and locations – for varied applications and purposes – are starting to consider consolidation by way of SQL Server clusters. (R)
Powershell and SQL Server – Overview
(Buck Woody) Although you can do most everything you need using Transact-SQL (T-SQL) commands or with the Common Language Runtime assemblies in SQL Server 2005, having a good grasp of scripting techniques is still essential to the Database Administrator (DBA). I’ve defined scripting as those technol
Think: z/OS 1.8, WLM, DB2 9, buffer pools, less pain, and better performance
(Willie Favero) I have discussed a few times over the last few years, the synergy between DB2, z/OS and System z. They work together to give you a best of breed solution. With that in mind, what do you think the 4 things listed in this post’s subject all have in common? Combined, they form a little