(Bilal Haidar) In part two of this series, we demonstrated the authentication and authorization by developing an ASP.NET 2.0 web application to host the ASP.NET 2.0 AJAX 1.0 Extensions Application Services. After that, we created a Windows client application that was enabled for authentication and a
Other News
.NET Tip: String Literals Without Escape Characters
(Jay Miller) Today’s tip is a very simple one, but if you are like me you will find yourself using it frequently. Do you have string literals that are filled with escape characters because they include characters that have a special meaning? One of the most common places you will find this is in fil
Access Non-.NET APIs with PInvoke
(Bill McCarthy) The .NET Framework provides managed libraries for many Windows APIs, but there are still many Windows APIs that aren’t in the .Net libraries. Today, you have to write wrappers for the unmanaged calls if you want to take advantage of Windows Vista’s new APIs, create a VPN connection,
Microsoft’s Lineup of SQL Server Related Webcasts for April 2008
Eight new webcasts are scheduled for April, covering such topics as “Securing Your System”, “Upgrade SQL Now” and more.
MySQL File System Fragmentation Benchmarks
(Peter Zaitsev) Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with real tables so I’ve got the script and ran tests for MyISAM and Innodb tables on ext3 filesystem.
Avoid Index Redundancy in SQL Server Tables
(Armando Prato) I’m trying to design indexes on a new Customer table and I have three separate query searches to satisfy. One query search is by lastname. The 2nd query search is by last name and first name. The last query search is by lastname and an active flag. How should I create my indexes?
i5/OS DBA: New Derived Key Indexes in DB2 for i5/OS V6R1
(Tom McKinley) A good indexing strategy is the key to good performance. The performance gain indexes provide comes from the ability to identify rows of interest without having to scan all rows of the table on every search.
Loading image files from a directory using SQL 2005
Featured Article(s) Loading image files from a directory using SQL 2005 The following procedure uses the new BULK in OPENROWSET set function in order to load all image files from a given directory location to a table inside SQL Server , If the table does not exist, the procedure creates it. The table structure is an identity column, the file […]
IBM and VCs Invest in EnterpriseDB
(Timothy Prickett Morgan) EnterpriseDB, the commercial enterprise that is providing support and services for the open source PostgreSQL relational database management system, announced this week that it has received its third round of venture capital funding, including some dough from IBM.
The Problem with People (Modeling Them)
(Chuck Allen) One of HR-XML’s big challenges is people — or more specifically how to model them. HR-XML needs to represent human resources — and a variety of their “designees” — in a variety of contexts and roles: employee, candidate, contractor, subscriber, account holder, assessment subject, scree