(rahulsisondia) MySQL Enterprise Backup (MEB) is a highly efficient tool for taking backups of your MySQL databases. In the 3.11.0 release we are taking that one step further by introducing a new concept called “optimistic” backup. Optimistic backup leverages the patterns we saw frequently especiall
Other News
Back to School Means Conference Season for Me
(Chris Eaton) The kids are now back in school and the weather in Toronto is starting to get much cooler in the evening. That means one thing to me (no not time for turkey and pumpkin pie), it means it’s time to hit the road for conference season. Not including competitor’s conferences that I attend
Implementing ‘Dirty Reads’
(Troy Coleman) I was recently asked about “dirty reads.” This term refers to setting an application’s SELECT statement to avoid taking locks while reading and processing uncommitted data.
Feed InfoSphere Streams applications with live data from databases
(Frank Ketelaars and Alex Lavrov) This tutorial shows you how to connect IBM InfoSphere Data Replication Change Data Capture (CDC) as a near real-time data source for InfoSphere Streams. Walk through several integration options for a ready-to-use and custom user exit, then explore the pros and cons
30 SQL Developer Tips in 30 Days, Day 6: Try the Schema Browser
(Jeff Smith) I’m at a friend’s house, sans laptop, so today’s post will be short and sweet.
Azure Feature – SQL Data Sync
(YsFred4) I have been using Azure for many years and have a cloud service that supports my global prayer app named Thoughts and Prayers (WP, W8, iOS, Android). I created this years ago before Azure Mobile Services were created and made my own WCF service to use across all platforms.
Information Hiding in JavaScript
(Ronnie Mukherjee) A key concept in object-oriented programming is information hiding. It refers to the practice of declaring some parts of a class public, and others private, depending on what we want clients of the class to be able to see and do.
WPF: Convert User’s RGB Choices into a (Background) Color
(Ged Mead) Users aren’t usually interested in RGB values as such, but are often keen to choose their own colors. One popular way of letting them do this is to give them sliders that will alter the RGB value and apply the resulting color to an element.
SQL Server Memory Techniques
A number of database optimizations methods have been added to or enhanced in SQL Server or Windows. They all do basically the same thing. They reduce the time needed to access data. In memory databases are the latest SQL Server optimization allowing databases to exist completely in RAM. Very high performance can be obtained from this implementation. SSD has been […]
TSQL: Understanding How to Use the INSERT Statement to Populate Your Database Tables
(Greg Larsen) Before you can read data from your database you need to understand how to insert data into the tables in your database. There are a number of different ways to accomplish this. In this article I will be explore the methods you can use when inserting data into a database table using t