This Log Buffer edition sheds light on the ongoing innovations and updates in the SQL Server, MySQL and Oracle realms.
- 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.
- Are you Ready for the Leap Second?
- Responsive UI is a big deal nowadays, when enterprise applications should run on different platforms and devices.
- 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.
- 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.
Interested in working with Fahd? Schedule a tech call.