(Kenneth Fisher) Have you ever needed to order by a calculated column? You might have written it something like this:
Author: SSWUG Research
3 Ways to Optimize for Paging in MySQL
(Sean Hull) Lots and lots of web applications need to page through information. From customer records, to the albums in your itunes collection. So as web developers and architects, it’s important that we do all this efficiently.
Lessons from RMAN restore and recovery
(Bobby Durrett) I was on call last week and had to recover a production database to a particular point in time to recover some data that was lost. I had to leave the production database intact but use a development server to restore a copy of production as of the needed date and time so the develop
Automate SQL Server Analysis Services Tasks with PowerShell – Part 2
(Daniel Calbimonte) In my last tip about PowerShell for SQL Server Analysis Services, we offered an introduction to PowerShell. In this second tip we will demonstrate how to do a few different discrete tasks including: creating a backup with the current date, using variables to specify the partition
MVC Basic Site: Step 4 – jqGrid Integration in MVC 4.0 using AJAX, JSON, jQuery, LINQ, and Serialization
(Raul Iloc) MVC Basic Site is intended to be a series of tutorial articles about the creation of a basic and extendable web site that uses ASP.NET MVC.
Hints and pointers for connector development in WebSphere Cast Iron Studio
(Bharathi Manian and Nagarjuna Surabathina) Learn how to easily configure the base orchestrations for connectors developed with the Connector Development Kit wizard in WebSphere Cast Iron Studio, and get tips on password and fault handling.
A Best Practice for Authenticating Users in ASP.NET MVC 4
(Peter Vogel) If your site has even one or two actions where access is restricted to particular users, the smart thing to do is to restrict access to all the actions on your site and then selectively permit access to those actions that all users are allowed to request. That way, an error of omission
How to know what is the installed SQLTXPLAIN version
(Carlos Sierra) Every so often I get this question: How do I know what is the version of SQLT installed on my database? You can execute one of the two queries below, connecting as a user with the SQLT_USER_ROLE or the DBA role.
Debugging obscure Postgres problems with strace
(Greg Sabino Mullane) One of the nice things about being a Postgres consultant is the sheer variety of interesting problems you get to solve. Here’s one that recently popped up, and a walkthrough of how I solved it.
SSWUGtv – Security Edition: What do your partners need to be thinking about when it comes to YOUR security?
Video Programming for IT Professionals