208 blogs updated: 16 min. ago
SQL Server (46) PostgreSQL (57) MySQL (27) Oracle (73) Mishmash (5)
sysbench Histograms: A Helpful Feature Often Overlooked
In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked ...
21-09-2017 02:58:43 Percona MySQL
Quick Python script to backup remote directory using ftp
I looked around for some other ways to do this but decided to just code this up in Python. It connects to a remote Linux server using ftp an...
21-09-2017 02:50:28 Bobby Durrett Oracle
Geek City: Changing How To Change Your Database Properties — ALTER DATABASE
(This article was originally published at Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored ...
20-09-2017 21:29:23 Kalen Delaney SQL Server
Percona XtraDB Cluster 5.6.37-26.21 is Now Available
Percona announces the release of Percona XtraDB Cluster 5.6.37-26.21 on September 20, 2017. Binaries are available from the downloads sectio...
20-09-2017 20:19:51 Percona MySQL
Identifier Case Sensitivity
I last blogged about Postgres's handling of case sensitivity in 2012. A recent email thread requested that case sensitivity be configurable ...
20-09-2017 18:50:09 Bruce Momjian PostgreSQL
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, ... Continue reading
20-09-2017 16:10:40 Kenneth Fisher SQL Server
What Would You Put in SQL Server 2018?
If you were leading Microsoft's development programs, what would you add or change in SQL Server 2018? Forget licensing or pricing changes t...
20-09-2017 16:08:59 Brent Ozar SQL Server
More SQL Server Features that Time Forgot
SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use...
20-09-2017 13:24:25 Simple Talk SQL Server
#225: Tracking and Managing Your Postgres Connections
Postgres Weekly Issue 225 September 20, 2017 Is Your Postgres Query Starved for Memory? Learn how to check if your Postgres query is starved...
20-09-2017 13:22:12 Postgres Weekly PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.