Oracle Database 18c XE now under the Oracle Free Use Terms and Conditions license

Today we announce the availability of Oracle Database 18c XE for Linux under the Oracle Free Use Terms and Conditions license. This new license is part of the XE RPM installer file and will be installed alongside Oracle Database 18c XE.

blogs.oracle.com

18th Mar 2020

Back To The Database - Prologue: What's Old Is New Again

We’re starting to see some influencers and larger organizations scale back from an “all in” and “by the book” stance on microservices and advocate for a more sensible and logical approach in 2020. There’s nothing wrong with the microservice pattern when used appropriately.

blogs.oracle.com

17th Mar 2020

Evaluating Hbase and Aerospike Solutions for Real-time System of Record

Legacy platforms often cannot meet real-time demands needed for innovation: slower response times cost the business and its customers which leads to bad user experiences.

db-engines.com

17th Mar 2020

Why Index Tuning Is An Iterative Process

For many people, index tuning means occasionally adding an index when there’s a report about a slow query. Those indexes might come from a query plan, or from the missing index DMVs, where SQL Server stores every complaint the optimizer files when it thinks an index might make a query better.

erikdarlingdata.com

17th Mar 2020

YugabyteDB Engineering Update – March 17, 2020

We are excited to announce that YugabyteDB 2.1.2 is GA! You can read the official release notes here. This release shipped with over 30 new enhancements and fixes.

blog.yugabyte.com

17th Mar 2020

A Practical Guide to Data Obfuscation

In this article, see a practical guide to data obfuscation, data governance for the cloud, the cost of flexibility, and more.

dzone.com

17th Mar 2020

Back To The Database - Part 1: Preparing To Persist Data From A Stream

In my last post, I talked about some of the reasons why it makes sense to take advantage of the power of our RDBMS to handle our data instead of manually implementing solutions in our application code.

blogs.oracle.com

17th Mar 2020

Using SQL Server on Azure Virtual Machines to ease your way into the cloud

When it comes to migrating applications to Azure, there are a number of paths available. But if you’re migrating on-premises apps or running applications that require OS-level access, depending on the choices you make, you may be looking at a major rewrite.

sqlservercentral.com

17th Mar 2020

How to get started with Elasticsearch Service on AWS GovCloud

We’re happy to announce the beta availability of our new government region, AWS GovCloud (US East), for the Elasticsearch Service on Elastic Cloud.

elastic.co

17th Mar 2020

Free Fundamentals of Query Tuning Week: Part 2, How to Find the Right Queries to Tune

Well, it turns out that toilet paper doesn’t cure the coronavirus, so during the quarantines, I’m giving away free training. Yesterday, I kicked off the Fundamentals of Query Tuning class with the first module, building a query plan.

brentozar.com

16th Mar 2020

Writing a data loader for database benchmarks

A task that I've done many times in my career in databases is to load data into a database as a first step in some benchmark. To do it efficiently you want to use multiple threads.

openlife.cc

16th Mar 2020

How to Install and Configure MaxScale for MariaDB

There are different reasons for adding a load balancer between your application and your database.

severalnines.com

16th Mar 2020

Monitoring Kubernetes with Grafana and InfluxDB

Most software architects and developers know that they need to monitor their systems. What often prevents them from implementing an effective monitoring solution is the plethora of choices they face.

logz.io

16th Mar 2020

Connecting to a MySQL Database in .NET

.NET is great and provides a ton of tools for working with databases and data sources. There are times though that a data source may not be inherently supported. In a case such as MySQL you may not see the MySQL connection options when creating binding sources or data sources for your project.

databasejournal.com

16th Mar 2020

Getting storage engines ready for fast storage devices — The MongoDB Engineering Journal

Subsequent accesses to the same virtual page may or may not require operating system involvement, depending on the following: If the physical page containing the file data is still in the buffer cache and the page table entry is in the TLB, operating system involvement is NOT necessary, and the data

engineering.mongodb.com

16th Mar 2020

CREATE VIEW SQL: Inserting data through views in SQL Server

This is the third article in a series of learning the CREATE VIEW SQL statement. So far, I’d say that we’re comfortable and familiar with the syntax, and we’ve learned how to create and modify views.

sqlshack.com

16th Mar 2020

Monitoring activities using sp_WhoIsActive in SQL Server

In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.

sqlshack.com

16th Mar 2020

MySQL 5.6 End of Life is February 2021

You will be hearing a lot from me and others about the product end of life (EOL) of MySQL version 5.6 which will be February 2021. While MySQL 8.0 is a vast leap forward over previous versions and MySQL 5.7 is fantastic, there are a lot of software still running and still dependent on MySQL 5.6.

elephantdolphin.blogspot.com

16th Mar 2020

Utilizing Multiple Disks to Speed Up Couchbase Analytics Queries

In this article, we perform a couple of experiments on different instances in the cloud to show how to properly set up up multiple "Analytics Disk Paths." Typical ad-hoc analytical queries have to process much more data than can fit in memory. Consequently, those queries tend to be I/O bound.

dzone.com

16th Mar 2020

Using MySQL Enterprise Audit Filtering for only Insert/Update/ Delete statements for allUsers

How to Audit only DML Actions ? Step by step to Enable Fine Grained MySQL Auditing for Insert/Update/Delete Queries for all Users. B...

chandanmysqltricks.blogspot.com

16th Mar 2020

Free Fundamentals of Query Tuning Week: Part 1, Building a Query Plan

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Saturday presentations.

brentozar.com

16th Mar 2020

MySQL & Dockers...a simple set up

MySQL & Dockers... are not new concepts, people have been moving to Dockers for some time now. For someone who is just moving to this for development, it can have a few hurdles.

anothermysqldba.blogspot.com

16th Mar 2020

Attaching / restoring databases inside a container

I'll get this out of the way first: I'm a Mac guy. If you're not using a Mac, probably the end of this post is the only thing of interest.

sqlblog.org

16th Mar 2020

Security Bulletin: IBM® Db2® is vulnerable to denial of service (CVE-2020-4135).

Db2 is vulnerable to a denial of service. Db2 could allow an attacker to send specially crafted packets to the Db2 server to cause excessive memory usage and cause Db2 to terminate abnormally.

ibm.com

15th Mar 2020

RAC DB upgrade from 11.2.0.4 to 12.1.0.2 ASM prerequisites fail with DUBA

A 3 node Oracle extended RAC has been successfully upgrade from 11.2.0.1 to 12.1.0.2 just last week. As part of the upgrade planning, we started off with GRID home upgrade process from 11.2.0.4 to 12.1.0.2, followed by DB upgrade from 11.2.0.1 to 11.2.0.4 and finally DB upgrade to 12.1.0.2.

jaffardba.blogspot.com

15th Mar 2020

Ways to Compute Pi in SQL

In celebration of Pi Day, I asked MemSQL’s Engineering team to come up with clever ways to compute pi in SQL.

memsql.com

15th Mar 2020

SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?

One of my clients contacted me and asked me the reason for this message? And my first reaction was, did you keep the database in very cold weather? It might be freezing over there and that’s why SQL is saying: “I/O is frozen on database” and “I/O was resumed on database”? Did you check

blog.sqlauthority.com

14th Mar 2020

Critical Patches Issued for Microsoft Products, February 11, 2020 (Updated 11th March)

Multiple vulnerabilities have been discovered in Microsoft products, the most severe of which could allow for remote code execution. Successful exploitation of the most severe of these vulnerabilities could result in an attacker gaining the same privileges as the logged on user.

cisecurity.org

First 164 165 166 167 Last