ALL POSTS

Deduping 100 Gigs Worth of Files? Gimme 5 Minutes…

Shortly before the Holidays, I became aware of the Dallas/Fort Worth Perl Mongers Winter Hackaton Contest. The challenge was simple enough: Here’s a directory structure filled with 100G worth of files, go and find all the duplicate files in there, as fast as you can. You know me: can’t resist a contest. But since I…

A New Year, a New Dancecard

First things first: Happy New Year y’all! Health, happiness, and all that jazz to each and everyone of youses! So the Holidays are over — or almost over, if you are one of the few lucky souls. Which means that we have to get back into the saddle. Considering that, ahem, some of us have…

Disabling Triggers in Oracle 11.2.0.4

Yes you can still disable triggers per-session in Oracle 11.2.0.4, but you have to have a GoldenGate license, set the enable_goldengate_replication parameter, use a program name that starts with replicat, and set your module to OGG.

Statistics gathering and SQL Tuning Advisor

Our monitoring software found a long running job on one of our client’s databases. The job was an Oracle’s auto task running statistics gathering for more than 3 hours. I was curious to know why it took so long and used a query to ASH to find out the most common SQL during the job…

SQL Server 2014 CTP2 – Memory Optimization Advisor

Today I am going to discuss one of the amazing new features, Memory Optimization Advisor of SQL Server 2014 CTP2. I discussed architectural details of SQL Server 2014 In-Memory Optimizer in my last blog post here. We will discuss Memory Optimization Advisor implementation with a demo in this blog post. This tool helps customers in migrating…

Page 7 of 240« First...56789...203040...Last »