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

PASS Summit 2015

Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server...