(Jay Stanley) This is the first installment of a series of shorter whitepapers that just cover the basics of a particular aspect of the Oracle RDBMS. The first one is on the subject of upgrading Oracle. After doing literally hundreds of Oracle RDBMS upgrades and patches over the past 18 years, these
Author: SSWUG Research
DB2 read-only clause and performance
(Jack Vamvas) Question: Why do some sql queries use a read-only clause? Is there any performance gain by using the read only clause?
The DB2Night Show #125: DB2’s GOT TALENT Contestant Search #2
(Scott Hayes) 100% of our studio audience learned something! Today’s presentations were fantastic! We had seven LUW themed contestants! You can learn about ADMIN_MOVE_TABLE, monitoring and tuning static SQL, reclaiming space with db2dart, solving a complex DB2 DPF performance issue, the change event
SQL SERVER – Get Current TimeZone Name in SQL Server
(Pinal Dave) A very common question we developer often encounters is what is the current Timezone of the server where SQL Server is installed. It is very easy to get current Timezone of the server where SQL Server is installed. Here is the simple script for the same.
Thoughts On JavaScript Generators
(K. Scott Allen) In a previous post we used a Node.js script to copy a MongoDB collection into Azure Table Storage. The program flow is hard to follow because the asynch APIs of both drivers require us to butcher the procedural flow of steps into callback functions.
Working with the Treeview Control in VB.NET
(Hannes Du Preez) The Treeview control gave me nightmares when I started programming many aeons ago. For some reason I couldn’t wrap my head around it. I had a similar experience with the ListView, but I’ll talk about that next time.
Rebinding for Optimal DB2 Access Paths
(Craig S. Mullins) The access paths formulated by the DB2 optimizer during the BIND and REBIND processes are critical to your application performance. It is these access paths that determine not only how DB2 data is accessed by your program, but how efficiently it is accessed.
DBA Myths: An index on a bit column will never be used.
(Kenneth Fisher) Not true. (Or I guess probably wouldn’t be posting about it would I?)
A practical guide to ASP.NET Web API
(Imran Abdul Ghani) Microsoft ASP.NET Web API framework is the best choice for developing HTTP services in more simpler way. It enables us to reach more wider ranger of clients such as browsers as well as mobile devices.
Rendering a Partial View and JSON Data Using AJAX in ASP.Net MVC
(Sandeep Singh Shekhawat) This article explains how to render a partial view and JSON data using AJAX. I have divided this article into three sections to understand both concepts, the first section describes the basic code and structure that is common in both concepts, the second section describes h