(Willie Favero) This is my first post for 2014. I’m looking forward to posting even more stuff about DB2 this year than previous. Time to submit your post request. Now on to the titled subject.
Author: SSWUG Research
SQL SERVER – Learning More About SQL Wait Stats
(Pinal Dave) I was recently visiting my customer for my day job in Delhi. During the meeting, I had a great time to meet a few of the technical domain experts of the leading organization. We discussed lots of different things while we were there and much of the conversation was surrounding to SQL Se
Calculating the Median Value within a Partitioned Set Using T-SQL
(Dwain Camps) It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Although the recent window functions provide the solution, there isn’t an obviously superior algorithm performance-wise, particularly
Using BIML to Generate an SSIS Import Package
(Koen Verbeeck) In my previous tip, Introduction to Business Intelligence Markup Language (BIML) for SSIS, we looked at a simple example of how to use BIML. In this tip, we look at a real world example of importing data into a database using BIML.
Windows Forms Scrolling Marquee with Text and Image
(Ged Mead) This came up as a question on VBCity recently. A member wondered how to display a scrolling marquee display that included both text and one or more images. Although this can be done with Timer, to my mind, the best way of achieving any kind of animation effect in Windows Forms is to us
The importance of multi source replication
(Daniël van Eeden) One of the latest labs releases of Oracle MySQL brings multi source replication. This lifts the limitation found in earlier releases that a MySQL slave can only have one master.
Security setup for RESTful web services
(Syed Ahmed) This article helps you understand commonly used options for securing web services. It also provides instructions on how to perform security configuration settings for a RESTful web service and how to set up authentication against IBM Bluepages enterprise directory and authorization usin
Best practices for converting wsadmin scripts from Jacl to Jython
(Zheng You Zhou and Xi Ying Zhou) This article describes best practices for manual and automatic conversion of Jacl script to Jython. Jacl and Jython are types of WebSphereAdministration Scripting (wsadmin scripts), which is the preferred way to manage servers and applications on WebSphere Applicati
Three ways to populate selected value in DropDownList on Edit or Update views – MVC
(Abhimanyu Kumar Vatsa) I have been asked this question many times that ‘how to populate/activate selected value/item (which I selected while inserting/adding new record) in Edit/Update mode’.
A Simple HTML Minifier for ASP.NET
(Dean Hume) I have previously blogged about the importance of serving your users web pages with speedy load times. Poor web performance equals lost revenue and customers. As you continue to build and improve on the web performance of your site, you will need to look for ingenious ways to squeeze tho