(Paul Ferrill) In the last article we walked through the process of downloading and installing Visual Basic 2010 Express edition. What you get when you’re done is essentially the same integrated development environment (IDE) you get with the full Microsoft Visual Studio 2010 product.
Other News
How to Use an XML Gateway with an Asynchronous Web Service using WS-Addressing
(Josh Bregman) In general synchronous web-services are simpler and more common than asynchronous web services. I like them, because for 99% of cases, the security can be done at the transport level using 2-way SSL.
Re-generating SQL Server Logins, Part 2
(Claire Hsu) This is the second article on my Re-generate SQL Server login series. In my first column, I focused on server-level role and database-level role assignment for any assigned login. I also mentioned frequent DBA encountered tasks related to ensuring login properties setup and what kind of
The DB2Night Show #43: DB2’S GOT TALENT!! 2 More Finalists!
(Scott Hayes) Today’s contestant search show featured contestants presenting on both DB2 z/OS and LUW topics! Contestants came to us from all over the globe – even Australia! Our judges selected two contestants to advance to the March finals! Congratulations to Mimo and Bob! This was another great s
Oracle11g: Zero Sized Unusable Indexes (Zeroes)
(Richard Foote) Following on from my previous discussion on “Create On Demand” segments, Oracle 11g R2 has also introduced storage saving initiatives in relation to useable indexes. Starting with a simple Oracle 10g example, we create a table and associated index:
DB2 for z/OS Roles: Trust Me on This One (Part 2)
(Robert Catterall) So, in part 1 of this two-part entry, which I posted a couple of weeks ago, I referred to a question someone had sent to the DB2-L discussion forum.
Back to the Basics: Restoring an Analysis Services Database
Not every DBA or Database Developer has had experience with Analysis Services so it did not come as a surprise when a DBA at a client site approached us for quick help in restoring the Analysis Services Database on-to the development environment. In our back to the basics series of posts, we will b
Part 2 – Simple lessons in improving scalability
(Ronald Bradford) Given the popular response from my first lesson in improving scalability where I detailed simple ways to eliminate unnecessary SQL, let me share another common bottleneck with MySQL scalability that can be instantly overcome.
Circumventing Private Variables In Javascript Using Method Reassignment
(Ben Nadel) Over the weekend, with the help of Julian Aubourg, I continued my exploration of jQuery 1.5, this time looking at how to use $.ajaxPrefilter() in conjunction with $.ajaxSetup() to globally configure AJAX requests.
Use RECLAIM with REORG to free up space in DB2 for Linux, UNIX, and Windows
(Kayalviszhi Ganesan) Extent reclaim is a method of table reorganization that frees up empty data extents within multi-dimensional clustering (MDC) tables, in addition to the space that is freed by regular REORG operations.