Category Archives: Uncategorized

SQLd360 with the AWR Warehouse

-+*Mauro decided to give me another challenge-  run SQLd360 against the AWR Warehouse and let him know how it does straight “out of the box”.  It’s a simpler installation process than SQLTXPLAIN, you simply unzip and run, (no installat…

SQLTXPLAIN and the AWR Warehouse- Part II

-+*I finally have a moment to look into my “hacked” SQLT XPRECT/XTRACT runs and see if the changes I made were enough to run properly with the AWR Warehouse.
The answer is yes and no… and maybe “it depends”…
The Result…

Pillars of Powershell #2: Commanding

-+*Introduction
This is the second blog post as a continuance in the series on the Pillars of PowerShell. In the initial blog post we went over the various interfaces that can be used to work with PowerShell. In this blog post we are going to start out…

Pillars of PowerShell #1: Interacting

-+*Introduction
PowerShell is a tool that if adopted can be used to help automate and standardize processes in your Windows and SQL Server environment (among other things). This blog series is intended to show you some of the basics (not all of them) that…

PowerShell Script to Manipulate SQL Server Backup Files

-+*Scenario
I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:SQLBackup
If you are familiar with Ola’s backup scripts, you know the full pat…

SQL Server 2012 SP2 Cummulative Update 5

-+*Hey folks,
Microsoft released the 5th Cummulative Update for SQL Server 2012 SP2. This update package contains fixes for 27 different issues, distributed as follows:
 

 
One very important issue that was fixed on this CU release was KB30389…

Windows 10 : It’s like totally amazing and junk…

-+*I decided I wanted to play with the newly released Spartan browser on Windows 10. Spartan comes with Windows 10 (build 10049), which does not have an ISO download available at the moment. So instead, I downloaded the x64 ISO image of Windows 10 (buil…

switch user in Oracle

-+*Almost a decade ago I wrote about su in sqlplus. This 10gR2 “new” feature allows delegation à la sudo.
By checking the DBA_USERS in 12c I found PROXY_ONLY_CONNECT. According to Miguel Anjo, there is a secret syntax for allowing only the p…

Log Buffer #416, A Carnival of the Vanities for DBAs

-+*This log buffer edition sprouts from the beauty, glamour and intelligence of various blog posts from Oracle, SQL Server, and MySQL.
Oracle:
Oracle Exadata Performance: Latest Improvements and Less Known Features
Exadata Storage Index Min/Max Optimizati…

Ad: Trivadis DK Opening Event

-+*Trivadis, the company I work for, just opened a new branch in Denmark (the press release, in German, is available here). On the 14th of April (09:00-15:00) takes place, in the Oracle’s office in Ballerup, the opening event. Two colleagues of mine and…