(Craig S. Mullins) As you fight the daily fight to improve the performance of your operational databases have you ever stopped to consider how you would define database performance? Most organizations monitor and tune the performance of their IT infrastructure
Author: SSWUG Research
Clustering Factor Calculation Improvement Part III (Too Much Rope)
(Richard Foote) In my previous post, I discussed how for larger tables that really do have randomised data, not even setting the new TABLE_CACHED_BLOCKS to its 255 maximum value is going to make any real difference to the resultant Clustering Factor (CF) of an index. The 255 maximum value here prote
Java EE 7 Deployment Descriptors
(Antonio Goncalves) As you might know by now, Java EE 7 will be released in a few days. There are many new features and I will not cover these novelties now. I just want to mention that most of the XML deployment descriptor namespaces have been updated.
SSWUGtv News: Braille smartphones, Tetris Therapy, and the value of a Facebook Like!
Video Programming for IT Professionals
Comparing SQL Server and Oracle datatypes
(Ben Snaidero) When I first started with SQL Server, as initially I worked exclusively with Oracle databases, I found myself constantly thinking in terms of Oracle datatypes and having to look up what the equivalent was in SQL Server. Now that I am primarily a SQL Server DBA I find that the opposite
TSQL Recursive Split Function
(Shahriar Iqbal Chowdhury/Galib) In my last post I showed how to split a string in TSQL. Problem with that splitting is it can split a string if resultant split count is
Schema replication with IBM InfoSphere Data Replication, Part 1: Uni-directional schema subscriptions in DB2 for Linux, UNIX, and Windows 10.1
(Olaf Stephan and Christian Lenke) IBM InfoSphere Data Replication allows the synchronization of data between two or more database management systems either on the same or on different operational platforms. Many different usage scenarios exist. Starting in Version 10.1 of IBM InfoSphere Data Replic
SharePoint 2010 Ribbon CSS Classes Explained
(Benjamin Niaulin) There are many classes with names like ms-cui-tts which mean nothing to me when I look at them for the first time. That’s why I decided to show you the classes from my perspective.
A Photo Stream For the Cloud using ASP.NET MVC and Azure Blob Storage
(Suprotim Agarwal) In this article, we will use a bunch of familiar technologies to build a nice little image hosting application. We will build an ASP.NET MVC app that uses Azure Blob Storage for hosting the images. The MVC app can be easily hosted on Azure Website (not demoed here). Idea is to see
Getting started with replication from MySQL to MongoDB
(Giuseppe Maxia) As you probably know, Tungsten Replicator can replicate data from MySQL to MongoDB. The installation is relatively simple and, once done, replication works very well. There was a bug in the installation procedure recently, and as I was testing that the breakage has been fixed, I wan