(Tim Wiseman) SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider?
Author: SSWUG Research
Migrating enterprise applications from JDBC WebSphere Business Integration Adapter to JDBC JCA-compliant WebSphere Adapter
(Vinod A. Valecha) The article describes migrating enterprise applications from WebSphere Business Integration JDBC Adapter to a J2EE Connector Architecture (JCA) compliant WebSphere JDBC adapter. This migration topic is important because support for WebSphere Business Integration Adapters ends by A
Understand Jquey ajax function : Call method in WCF service
(Sourav Kayal) Welcome to “Understand Jquey ajax function” article series. In this article series we are learning to consume various C# methods using Jquery ajax function. In previous two articles we have learned to consume code-behind C# method and Web Service method using JQuery ajax function. You
Now(), The Formula Engine Cache And The Where Clause
(Chris Webb) Back in 2009 I blogged about how the use of the Now() function inside calculated members prevents the results of those calculations being cached for longer than the lifetime of a query.
SSRS Map Layers Parameter
(Mike Davis) With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter to the property on the tile layer with these three types.
Automated Permissions Auditing With Powershell and T-SQL: Part 1
(Tracy McKibben) A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly audits. In my environment, it’s not important to know who has access to specific tables or other objects, but we are interested in knowing who has some form o
Locating Instances of a Word or Expression within a MySQL Database
(Rob Gravelle) Ever have one of those times that you need to find a word or phrase in the database, but you have no idea what table it might be in? If not, you are one lucky DBA! Most of us have to take care of a database that we don’t know like the back of our hand at some […]
ADO.NET: Parameterized Query – Adding a User Selected filter
(Ged Mead) In this series of posts, I’ve been moving along in very small steps to demonstrate ways you can display and work with data from a database in Windows Forms. These early steps make use of wizards and tools that are provided in Visual Studio to help newcomers to this very complex and often
Better Enterprise Data Grids with Backgrid
(Nick Martin and Jeff Meyers) The two potential problems we’re going to set out to solve with Backbone today are pretty common ones – either getting an older grid view to start performing better, or bringing something new to your client’s newfound Web 2.0 expectations.
DB2 LUW Advanced topics training – February 4-6, 2014
This training will bring you up-to-date with the latest developments in DB2 LUW. We will also review the pros and cons of many issues and provide input for your strategy regarding upgrading and tuning. Bring your questions and share your experiences! If you are looking for DB2 LUW training beyond th