(Rachel Wireman) In my last article on this topic, you learned how to interact with Outlook via your WinForms applications. In this article, you will explore how to extend the functionality of Outlook with your custom code. The business value here is clear: Give your users an environment in which th
Other News
Managing PL/SQL Code
(Steven Feuerstein and Bill Pribyl) Creating the code for an application is just the first step; you must then manage it, and that includes everything from compiling to testing and debugging. This article, the first part in a nine-part series, covers these issues for PL/SQL.
Load and Search MySQL Data Using VB.NET 2005 in Windows Applications
(Ernest Bonat) MySQL data load and search are very important business requirements in any Windows or Internet web application development. In general, any application needs to show a result set of data and/or a single record to the end-users. In Windows applications it is very popular to show a resu
Oracle Spatial Mapping and Map Rendering Performance Tips
(Simon Greener) There are lots of things one can do to improve performance in mapping environments because of a lot of the visualisation is based on “background” or read-only data.
Solid Ajax applications: Part 1: Building the front end
(Brett D. McLaughlin, Sr.) With Ajax still one of the industry’s hottest buzzwords, more and more applications are being built with Ajax technologies. However, it’s not always easy to build a good application. This article focuses on how to build intuitive, easy-to-use Ajax-driven applications.
How to import an Excel file into SQL Server 2005 using Integration Services
(Tim Chapman) Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a wonderful tool for extracting, transforming, and loading data. Common uses for Integrations Services include: loading data into the database; changing data into to or out from your relation
Examples of SQL Server 2005 permissions capabilities
(Michelle Gutzait) In SQL Server 2005, more permissions can be given both in the instance and in the database level than in previous releases. Also, permissions can now be inherited — for example, permissions given to a schema are inherited by the schema’s objects. (R)
SQL Server 2008 – Transparent Data Encryption
(Kimberly L. Tripp) Does it sound too good to be true: transparent data encryption? Well, it kind of is and kind of isn’t. Let me explain. Transparent means that the application developer doesn’t do anything (and if you have a third party app in which you can’t do anything anyway, then this is even
String Functions: The .Properties Function, Part II
(William Pearson) In this, the second half of a two-part article, we will continue to expose another useful function within the MDX toolset, the .Properties function. As we noted in The .Properties Function, Part I, the general purpose of the .Properties function is to return a member property value
Call for Comments: Images in the Database?
New Videos Posted: Watch: Food for Thought: Direct SQL Good Idea/Bad Idea? What is it?!? Find out why you should avoid direct SQL. Watch: Upcoming Events in the Database World Watch: Full SelectViews Show with these and other segments Featured Article(s) Understanding Windows Share Point Services A human being’s need for communication is as strong, instinct and as basic as […]