(depesz) In previous post in the series I wrote about how to interpret single line in explain analyze output, it’s structure, and later on described all basic data-getting operations (nodes in explain tree).
Author: SSWUG Research
Uploading Multiple Files in Chunks from ASP.NET MVC app to Azure Blob Storage
(Suprotim Agarwal) In this third part of our Azure Blog Storage series we will overcome a shortcoming that we saw in the previous ‘chunked’ file upload solution. Previously we were not able to utilize Html5 File Upload input dialog’s multiple file capability. This time, we’ll use it and see how we c
SQL SERVER – How to use xp_sscanf in Real World Scenario?
(Pinal Dave) I need your help. I recently came across extended stored procedure xp_sscanf. After reading a lot about it and searching online, I could not figure out how and where in real world, I will use this function.
The What, How, and Why of DB2 Accelerators
(Cristian Molaro) DB2 for z/OS is celebrating its 30th anniversary this year. When released, DB2 was designed to serve as a data warehouse. With time and development, DB2 evolved into the state-of-the-art Online Transaction Processing (OLTP) and data warehousing engine that we know today.
DB2 10.5 Upgrade – 10 Reasons to Implement immediately!
(Dave Beulke) The International DB2 User Group (IDUG) North American conference is always full of great DB2 Family presentations. I try to go through all of them because they are always full of great ideas, best practices, hints and tips. I guess that’s why IDUG celebrated both DB2 for z/OS’ 30-year
How to Avoid Session Hijacking in Web Applications
(Suthish Nair) Let me try to explain how to avoid session hijacking in ASP.Net web applications. First of all this is not a complete solution to stop session hijacking but this will help to stop the theft of session information to an extent.
Obtaining External Window Handles and Window Captions with Visual Studio 2012
(Hannes Du Preez) Hello again! Today’s topic is a very popular topic on programming forums like CodeGuru. There is always a need to obtain an outside application’s window handle, to be able to manipulate that window from inside your program. This is precisely what we will do today.
Top 3 Performance Killers For Linked Server Queries
(Thomas LaRock) One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries despite there currently being an upper bound due to things like network bandwidth, the spe
Getting Interactive Report Query
(Denes Kubicek) I know this is nothing new but I had a hard time to find out how to get the SQL of the currently viewed Interactive Report. In one of my projects I needed the exact query including the filtered values and sorting in order to save the data into a PL/SQL collection and process it furt
Script Properties and Validations
(rbishop) A new feature for 11.1.2.3 is the ability to use ECMAScript/JavaScript for properties and validations. Here is an example of a validation written in script: