Tag: dba

Oracle 12c – adaptive query optimization

Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution…

Read More >

Azure cli on Mac

Microsoft Azure has a really good, intuitive GUI interface where you can do a variety of tasks. But for me, as a DBA working most of my time in command line, sometimes it’s much easier to log on and run command from…

Read More >

Autoconfig in Oracle EBS R12.2

All seasoned Oracle Apps DBAs know that Autoconfig is the master utility that can configure the whole E-Business Suite Instance. In E-Business Suite releases 11i, 12.0 and 12.1 running Autoconfig recreated all the relevant configurations files used by Apache server….

Read More >

Log Buffer #436: a carnival of the vanities for DBAs

This Log Buffer Edition covers the top blog posts of the week from the Oracle, SQL Server and MySQL arenas.

Read More >

Log Buffer #434: a carnival of the vanities for DBAs

This Log Buffer Edition throws spotlight on some of the salient blog posts from Oracle, SQL Server and MySQL.

Read More >

Log Buffer #433: a carnival of the vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL blogs of the running week.

Read More >

Real Life DBA: finding errors in SQL server

I tend to spend time on a few different forums at times, mostly the StackExchange network, and find folks asking questions about various errors seen in the error log of an SQL Server instance. Most DBAs are aware that errors…

Read More >

Log Buffer #431: a carnival of the vanities for DBAs

This Log buffer edition covers Oracle, SQL Server and MySQL blog posts about new features, tips, tricks and best practices.

Read More >

Pillars of PowerShell: SQL server – part 1

Introduction This is the sixth and final post in the series on the Pillars of PowerShell, at least part one of the final post. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS PowerShell + SQL Server…

Read More >

Log Buffer #429: a carnival of the vanities for DBAs

This Log Buffer Edition gathers a wide sample of blogs and then purifies the best ones from Oracle, SQL Server and MySQL.

Read More >
Page 3 of 41234