(Troy Coleman) Getting the most from a new DB2 release typically requires some work on the part of customers, who must redesign their applications to take advantage of the latest features. Of course this effort is worthwhile, because it ultimately saves CPU, thus reducing the overall cost of the new
Author: SSWUG Research
MySQL Subquery Optimization
(Sean Hull) MySQL’s optimizer can do a lot of things, but subqueries are not always handled well. Take a look at the IN subquery below. If you see the DEPENDENT SUBQUERY in your explain plan, you may want to take a second look. This will run slow as a dog, when the tables get large.
Manage SQL Server Connectivity through Windows Azure Virtual Machines Remote PowerShell
(Khalid Mouss) The goal of this blog is to demonstrate how we can automate through PowerShell connecting multiple SQL Server deployments in Windows Azure Virtual Machines. We would configure TCP port that we would open (and close) though Windows firewall from a remote PowerShell session to the Virtu
How to build a realtime jQuery plugin
(Phil Leggetter) Back in January this year jQuery announced a new plugins registry, so now seemed like a great time to write a tutorial combining building a jQuery plugin with my passion – realtime web technologies.
High IO Wait on SQL Server Replication Distribution Database
(Thomas LeBlanc) Have you ever heard this question? The database refresh has gone from 10-15 minutes to 1.5 hours. Nothing has changed on the application server and the consultant said ask the DBAs to check the database server. Where do you start to find the problem?
IBM Worklight server configuration for FIPS 140-2 validation and certification, Part 2: Deploying your mobile app on WebSphere Application Server
(Bhargav Perepa) In this article, the second in a two-part series, learn how to set up, configure, and validate a distributed IBM WebSphere Application Server network; deploy and validate IBM MobileFirst solutions; configure end-to-end SSL communications; configure IBM Worklight Server for Federal I
SQL 2012 Reporting Services Gotchas with SharePoint 2010
(Paul Hunt) I now have a perfectly deployed SQL 2012 Reporting Services instance running in Integrated mode in my 2 year old SharePoint 2010 development farm.
Determining the Owner of a File or Folder
(Richard Carr) When using the New Technology File System (NTFS), every file and folder has an owner. This is a user or a group that gains special rights over the item, such as the ability to set its permissions. The owner of a file or folder can be determined with .NET.
Detecting File Type Using Magic Numbers In ColdFusion
(Ben Nadel) At InVision, we get a lot of users that upload files with an incorrect file extension. Typically, when this happens, a user has uploaded a “.jpg” file that is actually a Photoshop (PSD) file under the hood.
Finding the Problems in Your UI and Listening to Users Effectively
(Peter Vogel) You should always monitor your applications to determine what problems they have. Without monitoring, bad things never get better. When it comes to determining if you have problems with your UI, this doesn’t have to be a terrifically complicated process.