(Pinal Dave) Recently I was reading excellent blog post by Lenni Lobel on Spatial Database. He has written very interesting function ShortestLineTo in Spatial Data Classes. I really loved this new feature of the finding shortest distance between two shapes in SQL Server.
Other News
Recovering Semantics of Tables on the Web
(Petros Venetis, Alon Halevy, Jayant Madhavan, Marius Pasca, Warren Shen, Fei Wu, Gengxin Miao and Chung Wu) The Web offers a corpus of over 100 million tables, but the meaning of each table is rarely explicit from the table itself. Header rows exist in few cases and even when they do, the attribute
Top 10 New Features for Oracle 11g Data Guard – Part Two
(Karen Reliford) After nearly a year’s hiatus from writing for Database Journal, I’m very glad to be back, and to finally be finishing the second part of my article on my favorite new features in Oracle 11g Data Guard, their primary product for protecting databases and an integral part of many Disas
SQL Server Database corruption–Part VI: Regular Corruption Checks
(Michael K. Campbell) Previously we looked at how to set up alerts for cases where SQL Server encounters issues with the storage subsystem. Setting those up is a key component to staying alerted to when problems happen – but another great mechanism for detecting corruption early is to set up regular
LUHN Validation for ASP.NET (Web Forms and MVC)
(Keith Wood) In this post, I thought I’d look at a complete server-side and client-side solution for validating credit card numbers using the LUHN algorithm for both ASP.NET Web Forms and MVC. The core code uses some nice LINQ that I have previously blogged about, but thought it was worth providing
Care required in extending SharePoint 2010 capabilities externally
(Brien M. Posey) Let’s face it, the usual method of using email to request information from a business partner for a joint project is inefficient. Someone in one organization typically sends a message to someone in the other, then must wait for a response and hope that it contains all of the informa
Pre-Order Now: DB2 10 for z/OS Database Administration: Certification Study Guide
(Susan Visser) After a long delay, I can finally announce that this long awaited book is about to publish and you’ll be able to buy it in time for the IDUG conference. The publisher has provided a 10% discount on all pre-orders. If you’re attending IDUG Denver this year, make sure you take the pre
10 Reasons Why Visual Basic is Better Than C#
(Andy Brown) Visual Basic is a better programming language than Visual C#. Who says so? This article! Here are 10 reasons why you should always choose VB over C#.
jQuery DataTables and ASP.NET MVC Integration – Part I
(Jovan Popovic) The jQuery DataTables plug-in is an excellent client-side component that can be used to create rich-functional tables in the web browser. This plug-in adds lot of functionalities to the plain HTML tables that are placed in web pages such as filtering, paging, sorting, changing page l
FilteredTextboxExtenderContol in AJAX
(Davin Martyn) Ajax (Asynchronous JavaScript and XML) is a new web development technique for interactive websites. With AJAX help we can develop web applications and retrieve small amounts of data from a web server. AJAX consists of a different type of technology.