(Marcin Policht) In the most recent articles of our series covering SQL Server 2005 Integration Services, we have focused on maintenance plans activities, represented by a number of tasks in Maintenance Plan designer of SQL Server Management Studio (including additional caveats introduced by Service
Other News
Build a Custom Data-Bound Generator
(Jeff Levinson) In this information-packed column, I will show you how to write a custom data-bound generator (DBG) for Visual Studio 2005 Team Edition for Database Professionals (DB Pros). You can download the solution code associated with this column (it’s available in both C# and VB). This genera
Mimic SQL Server Management Studio reports for Reporting Services
(Michelle Gutzait) One of the most useful tools shipped with SQL Server Management Studio is the standard reports. Owning the source code in these reports could satisfy a number of needs in your organization. (R)
How Visual Basic 9, Windows Vista appeal to the Visual Basic 6 developer
(Brian Eastwood) For today’s Visual Basic 6 developer, there are three sometimes stark realities. (R)
Manage Microsoft Office 2007 documents with DB2 9 pureXML
(Chris C. Gruber) Integrate your Microsoft Office 2007 documents into your enterprise and Internet applications more easily than ever before with DB2 9. Review older methods of data interchange with MS Office documents, and learn how MS Office 2007 offers better data interchange. This article discus
Using advanced table hints in SQL Server
(Tim Chapman) My previous SQL Server column covered two types of table hints: NOLOCK and READPAST. This article explores the advantages and drawbacks of using three other types of table hints when running queries in SQL Server: READCOMMITTED, REPEATABLEREAD, and SERIALIZABLE.
A revision to my personal opinion/observation on the performance of DB2 V8 Multi-row FETCH
(Willie Favero) It’s raining this dreary Saturday morning in Houston so I’ve decided to post a revision to one of my previous post that I made this week. Because I am now “working”, I’m hoping this gets me out of hanging pictures today. (Isn’t it kind of strange that both of my recent posts on multi
How to Create Microsoft Access DataSource for Win Forms App Visual Basic 2005
(Mike McIntyre) Visual Studio 2005 provides a feature, the ‘Data Source Configuration Wizard’, for creating a DataSource for a Windows Forms 2.0 application. This article provides step-by-step instructions and a sample Visual Basic 2005 application you can use to learn how make a Microsoft Access da
ExecuteWithParams in your Oracle ADF application
(Andrejus Baranovskis) Recently I was researching Google Analytics data for my blog. I have noticed, that there are many search engine keywords with ‘ExecuteWithParams’ word. Really, this action plays one of the central roles in Oracle ADF BC application, it is used quite frequently and people want
Adding some colour to SQL*Plus
(Andy Campbell) Here is a quick tip that I’ve found useful for enhancing my SQL*Plus reports and scripts …