This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Oracle:
Upgrade Existing TDE to Use New Unified Key Management in 12c Upgraded Database (non-cdb)
Instrumentation … not just for debugging
12.2 Index Deferred Invalidation (Atomica)
Collation in 12cR2 – when AA equals Å (or not?)
…
[Read more]This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Oracle:
Upgrade Existing TDE to Use New Unified Key Management in 12c Upgraded Database (non-cdb)
Instrumentation … not just for debugging
12.2 Index Deferred Invalidation (Atomica)
Collation in 12cR2 – when AA equals Å (or not?)
…
[Read more]I have bumped the minor version to 4.1.2 with this release which incorporates various pull requests from contributors. Of note is support for ALTER statements in PHPSQLCreator, which is the components of PHP-SQL-Parser responsible for turning a parse tree back into an executable SQL statement, basically an "unparser".
I have bumped the minor version to 4.1.2 with this release which incorporates various pull requests from contributors. Of note is support for ALTER statements in PHPSQLCreator, which is the components of PHP-SQL-Parser responsible for turning a parse tree back into an executable SQL statement, basically an "unparser".
via GIPHY I was just responding to some Disqus comments on a recent blog post. Admittedly it had a provocative title Will SQL databases just die already. What do you think? Join 34,000 others and follow Sean Hull on twitter @hullsean. A reader pointed out that some No-SQL databases do support joins. Huh? My face … Continue reading A roughneck walk down database alley →
With tons of new No-SQL database offerings everyday, developers & architects have a lot of options. Cassandra, Mongodb, Couchdb, Dynamodb & Firebase to name a few. Join 33,000 others and follow Sean Hull on twitter @hullsean. What’s more in the data warehouse space, you have Hadoop, which can churn through terabytes of data and get … Continue reading Will SQL just die already? →
In this blog, I’ll go over my thoughts on what we can expect in the world of SQL databases.
After reading Baron’s prediction on databases, here:
https://www.xaprb.com/blog/defining-moments-in-database-history/
I want to provide my own view on what’s coming up next for SQL databases. I think we live in interesting times, when we can see the beginning of the next-generation of RDBMSs.
There are defining characteristics of such databases:
Introduction While doing my High-Performance Java Persistence training, I came to realize that it’s worth explaining how a relational database works, as otherwise, it is very difficult to grasp many transaction-related concepts like atomicity, durability, and checkpoints. In this post, I’m going to give a high-level explanation of how a relational database works internally while … Continue reading How does a relational database work →
Some databases (in particular MySQL and T-SQL databases like SQL Server and Sybase) support a very nice feature: They allow for running a "batch" of statements in a single statement. For instance, in SQL Server, you can do something like this: -- Statement #1 DECLARE @table AS TABLE (id INT); -- Statement #2 SELECT * … Continue reading How to Execute SQL Batches With JDBC and jOOQ →
Three ways to schedule a MySQL query
If you walk through any office you see people working in Excel.
With MySQL for Excel (https://www.mysql.com/why-mysql/windows/excel/)
you can already let them pull information from Excel themselves.
However, in some cases it saves a lot of time if they don’t have
to pull the information, but it’s pushed automatically.
Exception lists are the best examples of queries you want to push
to users. If you have a query with occasional results, you don’t
want to check for this every day. In this case you just want to
receive a mail if there are any results. Eg a list of stuck
invoices which can’t be processed automatically.
How can we do this?
1. Using the MySQL Event Scheduler
The MySQL Event scheduler can be used to run a query on a predefined schedule and output the results in CSV format. …
[Read more]