SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...

SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...

Webinar with PernixData – Tuesday at 1PM Pacific

Join PernixData and me tomorrow at 1PM Pacific for a webinar discussing an exciting technology from PernixData!
In-memory computing is gaining...

Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension

This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...

Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension

This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...

Know Before You GO – Target Settings

When adding a Target to a session, a configurable setting may or may not be obviously available for use with the Target. In and of itself, this can be...

Know Before You GO – Target Settings

The last few articles have covered various topics for the event_file and ring_buffer target. The topics range from basic queries in...