This Log Buffer Edition throws spotlight on some of the salient blog posts from Oracle, SQL Server and MySQL.
- STANDARD date considerations in Oracle SQL and PL/SQL
- My good friend, Oracle icon Karen Morton passed away.
- Multiple invisible indexes on the same column in #Oracle 12c
- Little things worth knowing: Data Guard Broker Setup changes in 12c
- Things that are there but you cannot use
- Dynamic Grouping in SSRS Reports
- SQL 2014 Clustered Columnstore index rebuild and maintenance considerations
- SQL Server 2016 CTP2
- Azure SQL Database Security Features
- Visualize the timeline of your SQL jobs using Google graph and email
- Shinguz: Max_used_connections per user/account
- Generally in MySQL we send queries massaged to a point where optimizer doesn’t have to think about anything.
- Replication is the process that transfers data from an active master to a slave server, which reproduces the data stream to achieve, as best as possible, a faithful copy of the data in the master.
- Unknown column ‘smth’ in ‘field list’ -> Oldie but goodie error
- Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs
Learn more about Pythian’s expertise in Oracle , SQL Server & MySQL.
Want to talk with an expert? Schedule a call with our team to get the conversation started.