(Arshad Ali) As DBAs, we have the responsibility to backup databases on a regular basis, but we also have to ensure that backups are stored securely and safely, so databases can be restored when needed. With the current method it is sometimes difficult to control that these backup files are readily
Author: SSWUG Research
The jQuery ‘live(…)’ Function
(Steve Wellens) The live function has been deprecated: http://api.jquery.com/live/ “As of jQuery 1.7, the .live() method is deprecated. Use .on() to attach event handlers.”
Custom Routes in ASP.NET MVC
(Suprotim Agarwal) ASP.NET MVC Routing is pretty flexible in itself and as demoed in Friendly URLs in ASP.NET Web Forms , we can mix and match old web forms style URLs with modern friendly URLs, even keeping both side by side. However, there are often quirks of implementation that need us to dig a l
Working with Spatial Data Part I – Geocoding Text-Based Spatial Data for Use In SSIS Packages
(Siddharth Mehta) Address information is one of the most common attributes of data stored in a business data repository. Examples of such data can be addresses of employees, store locations of retail chains, sales of a product etc. You may wonder about the last example and how sales of a product c
Cardinality Estimation for Multiple Predicates
(Paul White) Estimating the number of rows qualified by a single query predicate is often straightforward. When a predicate makes a simple comparison between a column and a scalar value, the chances are good that the cardinality estimator will be able to derive a good quality estimate from the stati
Transactional Replication – Find the Publisher
(Derik Hammer) I manage a moderately complicated topology that includes one-way transactional replication with push subscriptions to and from several database instances. Due to my day-to-day tasks I know this topology pretty well and often I simply know what my publications are, what articles they i
Treating DBA as a Management Discipline
(Craig S. Mullins) An oft-repeated story about database administration underscores both the necessity for database administration and the lack of understanding of a DBA’s function:
Adding a New Row In The Razor WebGrid
(Mike Brind) This article kind of follows on from the Inline Editing with the WebGrid post I published previously in that it offers a way for the user to add new records without leaving the confines of the WebGrid. The solution shares other similarities in that it relies on jQuery.
Install WebSphere MQ v7.5 on Red Hat Linux in under 1 minute with one click
(Roman Kharkovski) On the recent project of mine I had to install WebSphere MQ multiple times on multiple machines. In this post I would like to share script that I have built to automate the entire WMQ installation process on a freshly installed RHEL to about 60 seconds and only a single click. Sou
DB2 monitoring: Tracing SQL statements by using an activity event monitor
(Scott Walkty and Mike Springgay) This article describes a technique to easily trace (capture) the SQL statements that a client application executes. This technique uses monitoring features in the IBM DB2 for Linux, UNIX, and Windows software, Version 9.7 Fix Pack 4 and higher.