This Log Buffer edition sheds light on the ongoing innovations and updates in the SQL Server, MySQL and Oracle realms.
Oracle:
- Warning: standby redo logs not configured for thread – BUG
- SLOB 2.3 is soon to be released. This version has a lot of new, important features but also a significant amount of tuning in the data loading kit.
- Even in the highly volatile world of JavaScript frameworks, AngularJS is still very clearly leading the pack.
- Are you Ready for the Leap Second?
- Responsive UI is a big deal nowadays, when enterprise applications should run on different platforms and devices.
SQL Server:
- Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing.
- Retrieving a Binary File from Your Database.
- This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.
- The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data.
- Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008.
MySQL:
- Developer Studio.. JavaScript.. ClusterControl DSL.. database clusters.. huh? what the heck is going on here?
- Percona XtraBackup 2.2.11 is now available
- Are your databases more costly than they need to be? If you’re not sure, this webinar will show you how to find out, quickly and easily, with KPIs that indicate overprovisioning or opportunity for driving more efficiency from your databases.
- MySQL Incremental Backup – Point In Time Backup and Recovery of InnoDB and MyIsam Databases
- MySQL 5.7 key features.
Learn more about Pythian’s expertise in Oracle , SQL Server and MySQL.
No comments