This post will show how to use Connector/NET and Windows Store Apps in Windows 8 to connect and retrieve data from a MySql Server database.

Does size matter? This question has been teasing mankind since the beginning. But now, due to improvements in technology, size doesn’t really matter. Databases now have the features to tackle all data: big, medium, small, or very small. This Log Buffer Edition is here once again to bring you your data news of all sizes.

Oracle:

Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.

Niall installs …

We know very well that database technologies need a blog presence, and how to best offer that blogging experience — without the danger of boredom — is something tons of Oracle, SQL Server, and MySQL bloggers continue to show through Log Buffer. Enjoy!

Oracle:

Various approaches exist to organize your groovy scripts and package up utilities.

Oracle Certification announces the release of the new Oracle Linux 6 certification paths.

Designed for the Cloud, the new multitenant architecture of Oracle Database 12c now enables customers to greatly simplify and accelerate database consolidation by …

Looking at the committers/authors of patches in the bzr tree for MariaDB 5.5.31.

Non Oracle Contributors:

1. Alexander Barkov
2. Alexey Botchkov
3. Elena Stepanova
4. Igor Babaev
5. knielsen
6. Michael Widenius
7. sanja
8. Sergei Golubchik
9. Sergey Petrunya
10. timour
11. Vladislav Vaintroub

Oracle (as they pull Oracle changes):

1. Aditya A
2. Akhila Maddukuri
3. Alexander Nozdrin
4. Anirudh Mangipudi
5. Annamalai Gurusami
6. Astha Pareek
7. Balasubramanian Kandasamy
8. Chaithra Gopalareddy
9. Daniel Fischer
10. Gleb Shchepa
11. Harin Vadodaria
12. Hery Ramilison
13. Igor Solodovnikov
14. Inaam Rana
15. Jon Olav Hauglid
16. kevin.lewis
17. Krunal …

More and more blogs are springing up to cover database technologies. This ethereal Log Buffer Edition yet again cherishes this spectacular growth and offers a few links from the Oracle, SQL Server, and MySQL arenas.

Oracle:

Are Oracle enqueue rules leading to deadlock changes again in 12.1? Charles Hooper asks.

James Morle writes about optimal Oracle configuration for efficient table scanning.

Richard Foote writes a quick post on the reuse of empty leaf blocks in index.

…

Good news everyone! I recently presented a webinar: Percona Server 5.6: Enterprise Grade MySQL. It was also recorded so you can watch along or view the slide deck. As with all my talks, I am not simply reading the slides so it really is worth to listen to the audio rather than just glance through the slide deck.

There were a number of great questions asked which I’ll answer below:

Q: How does Stewart feel about this version of 5.6 taking into consideration “Stewart’s .20 rule?” (ref 2013 Percona Live Conference).

A: For those who aren’t familiar with it, I have a rule which I call “Stewart’s dot twenty rule” which I’ve posted a few times about on my personal blog. It …

Windows 8 has ushered in the era of Windows Store apps and touch in a Windows OS.  Windows Store apps can be written in a multitude of languages including all .NET languages, Javascript, HTML, and C/C++.  We want to make it easy to write Windows Store apps that connect to the MySQL database.  To that end, we have included Windows Store compatibility in our recent Connector/Net 6.7 release.

 This is done by providing a separate assembly that exposes some of the functionality of the standard Connector/Net provider.   Some of the areas of functionality that is limited or missing as compared to stock Connector/Net are:

• SSL connections or Windows authentication is not supported
• MySQLDataAdapter objects are not supported. All access should be through MySQLCommand and MySQLDataReader.
• Only TCP connections are supported
• Tracing is not supported
• GetSchema methods …

This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively)Dogma (some use the "Pattern-Pattern", i.e. the … Continue reading 10 Common Mistakes Java Developers Make when Writing SQL →

This Log Buffer Edition marvels at the ease, simplicity, and power of the database bloggers as they go about their adventures in the realms of Oracle, SQL Server, and MySQL.

Oracle:

The new Oracle Database 12c’s “Implicit Result Sets” (IRS) feature allows query results to be returned from a stored PL/SQL procedure (or a PL/SQL anonymous block) without requiring a special PHP code.

Ranka has been spending a lot of time on big data and its application, architecture, and processes.

Kashif Manzoor tells us how to use the new Clone Log Parser utility in Oracle E-Business Suite.

…

In this Log Buffer, you have naan bread, two types of roti, pasta, Karachi biryani, Chiken Tandoori, Beef tikka, eggplant masala, mixed pickles, French pastry with some elixir to wash all of it down. Yes, once again, this edition of Log Buffer contains numerous flavors from Oracle, SQL Server and MySQL.

Oracle:

Sometimes it’s the little differences that make something really cool, and Martin was wondering why this hasn’t made it into the Oracle dictionary before.

Oracle introduced a new feature for DataGuard called Far Sync. This configuration is designed to support synchronous redo transport between primary and standby database, which are far apart.

There are a few …