(Grahaeme Ross) When Microsoft introduced their ‘Always On’ technology, they made the statement in TechNet, which our team has since had confirmed, that they cannot support distributed or cross-database transactions (CDT) with Always-On Availability Groups because they cannot guarantee data in such
Author: SSWUG Research
SQL Server Min Max Column Normalization for Data Mining
(Dallas Snider) In data mining, we often need to perform min-max normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms.
Finding Scalar Aggregate Indexed Views in Your Database
(Michael J. Swart) Fellow MVP Paul White recently blogged about a SQL Server bug. His blog post is called An Indexed View Bug with Scalar Aggregates
In-Memory OLTP: Part 1 – Introduction
(DBAFromTheCold) In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly? If you’re a DBA with a few years experience under your belt and are looking to get into this new feature but don’t have the time to sit and read the various technical arti
Proposal to deprecate ‘compatibility’ SQL Modes
(Morgan Tocker) In the MySQL team, we are currently discussing deprecating several of the SQL mode options which are used by mysqldump to change the output format. From the mysqldump command:
Re-Creating Datafiles When Backups Are Unavailable
(Andrew Reid) I found an old copy of the Oracle 9i User-Managed Backup and Recovery Guide and read the following:
Background REST Service Access with A-Team Mobile Persistence Accelerator
(Andrejus Baranovskis) REST service transfers light data, but service execution time could bring significant delay to the enterprise mobile application. I have already introduced you to the A-Team Mobile Persistence Accelerator (AMPA) in previous post – REST Service Access with A-Team Mobile Persist
OBIEE 11g dashboard pages outside of a dashboard
(Vishal Pathak) We had a strange requirement. The user did not want the dashboard to be published and he hated the fact that he had to expand the dashboard to see the pages in it.Since the requirement is strange so will be the solution.
Use this HTML5 video player sample for your hackathon projects
(Dave Voyles) Last week Microsoft announced the new Azure Media Services video player. Here’s the biggest selling point for me:
Enlarge Image Using jQuery
(Rahul Saxena) This article shows how to show images in a data list from a directory and on the click of an image how to enlarge that image using JQuery.