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
Interested in working with Fahd? Schedule a tech call.