Video Programming for IT Professionals
Author: SSWUG Research
MyODBC Connector – Part 3: Create a New Project
(Matthew R. King) Open Visual Studio and start a new project. I am calling mine “MyStore” in the example below.
Reviewing DB2 for i5/OS query optimizer and database engine feedback mechanisms
(Mike Cain and Jackie Jansen) For most people, the database engine and query optimizer comprise a “black box.” To get data-centric work accomplished in your applications, you issue structured query language (SQL) requests to tell DB2 what to do, not how to do it. The query optimizer determines the b
Creating MS Word Document using VB.Net, XML and XSLT
(Sudipta Sankar Das) This simple program demostrate how to create well formatted MS Word documents using VB.Net, XML and XSLT. Using XSLT to create Word document requires the knowledge of RTF key words. RTF specification is available in MSDN site.
.NET Framework and Language Enhancements in Microsoft Visual Studio 2005
(Lars Powers and Mike Snell) This chapter covers the enhancements relative to both Visual Basic .NET and C#. In addition, it highlights some of the key advances made in the Framework.
Using the catalog views to see table permissions
(Louis Davidson) I was needing to get an idea of the permissions that had been granted in a couple of databases the other day, and being the GUI novice I am, couldn’t find what I wanted easy enough (if it even is in there.) So, I hunted around in the system views to see what I could find. There ar
Understanding APPLY Clause in SQL Server 2005
(Sachin Dedhia) Those who have extensively worked on database development with SQL Server 2000 would have, at some point in time, come across a shortcoming of user-defined functions. Delve further into this and you would agree too.
Using ETW for SQL Server 2005
(Jay Choe) ETW stands for “Event Tracing for Windows” and it is used by many Windows applications to provide debug trace functionality. This “wide” availability is a key point of using ETW because it can help to track certain activities from end to end. For example, you can literally track a reque
Windows Forms Password Encryption Visual Basic 2005
(Mike McIntyre) This article and source code explain how to use the .NET Cryptography MD5CryptoServiceProvider method to encrypt a string used as a password in a Windows Forms application.
Using SQL Server JOINs for easy range lookups
(Arthur Fuller) JOINs are an essential component for SQL Server developers, yet relatively few of them understand their real power. Most developers learn about equi-JOINs, wherein a value from table T1 is compared to a value from table T2.