Tag: DBA Lounge

Is Oracle Smart Flash Cache a “SPOF”?

Maris Elsins, Lead Database Consultant at Pythian, Oracle ACE & OCM, explores whether the failure of a solid-state device used by Oracle Smart Flash Cache affects the availability of the database.

Read More >

Log Buffer #453: A Carnival of the Vanities for DBAs

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.

Read More >

The End of an Era – Preparing for a SQL Server 2005 Upgrade

SQL-Server-Upgrade-ignore

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

Read More >

SQL On The Edge #3 – Azure Elastic Database Jobs

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…

Read More >

SQL On The Edge #2 – SQL 2016 Temporal Tables

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…

Read More >

SQL On The Edge #1 – 2016 Installer

  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…

Read More >

Handling the Leap Second – Linux

Leap Second

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…

Read More >

Are you Ready for the Leap Second?

LeapSecond

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….

Read More >

Using the ILOM for Troubleshooting on ODA

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….

Read More >

Room for Improvement – Using DBMS_REDEFINITION with Spatial Data

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.

Read More >
Page 2 of 6012345...10...Last Page »