Chris McGowan

All authors

Baseline SQL Server with SQL Sentry Performance Advisor

by Chris McGowan

SQL Server 365

Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...

2013-06-24

2,899 reads

Dedicated Administrator Connection (DAC)

by Chris McGowan

SQL Server 365

We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources...

2013-05-29 (first published: 2013-05-23)

4,069 reads

Object Qualification

by Chris McGowan

SQL Server 365

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...

2013-05-22 (first published: 2013-05-15)

2,759 reads

DTA and Hypothetical Indexes

by Chris McGowan

SQL Server 365

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...

2013-05-15 (first published: 2013-05-09)

11,443 reads

Discuss

SQL Server Hardware and Acronyms

by Chris McGowan

SQL Server 365

Over the weekend I finished reading yet another Red Gate book, this one was SQL Server Hardware by Glenn Berry...

2013-05-07

918 reads

Index Tuning

by Chris McGowan

SQL Server 365

This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using...

2013-03-21 (first published: 2013-03-14)

3,626 reads

Cost Threshold for Parallelism

by Chris McGowan

SQL Server 365

Parallelism, where to start? Well let’s start right at the beginning shall we with the question, what is parallelism? Simply...

2013-02-26

3,517 reads

Fun with dates

by Chris McGowan

SQL Server 365

Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...

2013-02-17

791 reads

T-SQL Gotcha

by Chris McGowan

SQL Server 365

I came across an interesting issue a few days ago that I thought I would blog about. The issue is...

2013-02-15

1,598 reads

Script Replication with PowerShell

by Chris McGowan

SQL Server 365

I promised you some PowerShell scripts this year and this post is the first one. I can see the value...

2013-02-14

6,784 reads

All authors

Chris McGowan

Baseline SQL Server with SQL Sentry Performance Advisor

Dedicated Administrator Connection (DAC)

Object Qualification

DTA and Hypothetical Indexes

SQL Server Hardware and Acronyms

Index Tuning

Cost Threshold for Parallelism

Fun with dates

T-SQL Gotcha

Script Replication with PowerShell

Blogs

PlanTrace Now Supports PostgreSQL

A New Word: the Kinder Surprise

Crash-Consistent Snapshot Cloning - Hyper-V Edition

Forums

BCA KCU WAHID HASYIM Tlp/WA.(+62 821°3111°179

BCA KCP Yos Sudarso Tlp/WA.(+62 821°3111°179

BCA KCP Cempaka Putih Raya Tlp/WA.(+62 821°3111°179

Question of the Day

SSoL Support on the OS