Tag: DBA Lounge

Fahd Mirza, Pythian Database Consultant and Oracle ACE, presents this weeks Log Buffer Edition digging deep into the world of Oracle, SQL Server and MySQL to bring you some of the best blog posts around the web.

Extended support for SQL Server 2005 will come to an end April 2016. This webinar provides a live demo on how to plan and perform a SQL Server 2005 upgrade

Hello and welcome to episode number three of SQL On the Edge! In this episode we’re going to cover Azure SQL elastic database jobs. In the last few months, Microsoft has put a lot of effort in augmenting the elastic…

Hello and welcome to our second episode of SQL On The Edge! On this episode we’re going to focus on a new feature of SQL Server 2016 called Temporal Tables. What’s a Temporal table? Temporal tables allow us to go…

  Hello and welcome to my new video blog (Vlog) series SQL On The Edge! My goal with these videos is to provide short, concise demonstrations of the latest and greatest features regarding SQL Server, Azure SQL Database and other…

Last week I published a blog post titled “Are You Ready For the Leap Second?“, and by looking at the blog statistics I could tell that many of you read it, and that’s good, because you became aware of the…

If you’re not aware of what the leap second is look into it. The fact is, this year the last minute of June 30th will be one second longer and “June 30, 2015 23:59:60” will be a valid and correct time….

I worked on root cause analysis for a strange node reboot on client’s Oracle Database Appliance yesterday. The case was quite interesting from the perspective that none of the logs contained any information related to the cause of the reboot….

Using DBMS_REDEFINITION to reconfigure a table can be a simple way to modify table structure. But that is not always the case. Consider this example of what is necessary to modify a table when Spatial data is included in the table.

What’s the most elaborate thing you have done with DataPump? So there I was, given the requirement to export multiple partitions for multiple tables where each partition has its own dump file having the format “tablename_partitionanme.dmp”, pondering how this can…