(Jeremy Kadlec) In our SQL Server environment we have a mix of SQL Server and Windows versions not to mention a mix of applications, hardware and server locations (on site, off site, in the cloud, etc.). This makes management, disaster recovery, high availability, etc. very difficult with 24×7 dem
Other News
Tweaked bind variable script
(Bobby Durrett) I modified the bind variable extraction script that I normally use to make it more helpful to me.
Understanding Flash: Garbage Collection Matters
(flashdba) In the last post in this series I discussed some of the various tasks that need to be performed by the flash translation layer – the layer of abstraction that sits between us and the raw NAND flash on which we desire to store our data. One of those tasks is the infamous garbage collection
Using a Translatable String as the Default Value for a Bind Variable
(Duncan Mills) I’ve just been looking at a scenario where we needed to populate an ADFBC query bind variable using a predefined value. Now that in itself is not difficult – the bind variable definition takes a default value exactly for this, however, in this case the value supplied as the default ne
Visualizing the impact of ordered vs. random index insertion in InnoDB
(Jeremy Cole) Many DBAs know that building indexes in “random” order (or really any order that greatly differs from ordered by key) can be much less efficient. However, it’s often hard to really understand why that is.
Removing Rows with the DELETE Statement in SQL Server
(Greg Larsen) In my last two articles I discuss using the INSERT and UPDATE statement. These two commands added new rows and modified existing rows. In this article I will explore how to remove rows from a table using the DELETE statement.
Protecting Your Data
How important is the protection of your data? What would happen to your business if something happened to your data? Is this a key consideration in your system designs, or simply an afterthought when you have time to get around to it? When I am thinking of data protection there are a lot of factors to be considered. The first […]
XML and .NET
(Arkadeep De) In this post I will discuss about the term XML – Extensible Markup Language is a markup language like HTML designed for describing data as a database.
What is dashDB and how can you get your hands on it?
(Susan Visser) There were many exciting announcements that took place at the IBM Insight Conference the week of October 27, 2014. The one that I want to talk about today is dashDB.
Transaction Retry Is Available On Multi-Threaded Slave
(Libing.Song) I am happy to announce that slave_transaction_retries is available on multi-threaded slave now. You will no longer see the warning that slave_transaction_retries is not supported by multi-threaded slave since MySQL-5.7.5.