Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Grant Fritchey

SQLServerCentral.com profile

   Items 1 to 20 of 28    Older >>
 

An Integrated Process for Software Delivery.

Developers, enamored of the integrated approach to Software Delivery, would like to be able to respond to business need in business time, adding functionality when the need is recognized, instead of 6-9 months later after it's gone through the sclerotic IT purchasing and configuration process.  Read more...
By Grant Fritchey 2014/03/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

The MCM Program is dead. Long live the MCMs!

Grant Fritchey on why he takes a dim view of most certifications, and why the MCM was different.  Read more...
By Grant Fritchey 2013/09/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 180 reads

SQL Server Execution Plans, Second Edition by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.  Read more...
By Grant Fritchey 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 13,460 reads

Webinar: Forgotten Rings and Other Monitoring Stories

In this session, Grant Fritchey, Microsoft MVP, drills down into a few of the more obscure monitoring metrics that can give you very precise information about exactly what's happening within your server. He'll also show you how you can use custom metrics to enable these metrics in Red Gate's SQL Monitor.  Read more...
By Steve Jones, Grant Fritchey 2012/10/29 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 139 reads

SSC Clinic: Finding the rogue query

When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.  Read more...
By Grant Fritchey 2012/09/13 | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 5,842 reads

Never, Ever Use Clustered Indexes

Today we have a guest editorial from Grant Fritchey that might surprise you. Today Grant talks about clustered indexes in your tables.  Read more...
By Grant Fritchey 2012/05/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 871 reads

Set Up And Schedule a Server Side Trace

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace  Read more...
By Grant Fritchey 2013/12/31 (first published: 2010/12/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,358 reads

The Red Gate Guide to SQL Server Team-based Development

This book shows how to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possible to "normal" development.  Read more...
By Grant Fritchey 2010/10/21 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 4,433 reads

Free Advice or Free Consulting

A guest editorial from Grant Fritchey today talks examines the free advice that is often given in the forums. It's not free consulting and you shouldn't expect that.  Read more...
By Grant Fritchey 2010/05/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 256 reads

Measures and Rules

Today we have a guest editorial from Grant Fritchey that discusses the idea of rules based on certain types of measurements. Are they worth following? Or do we need to develop our own measures.  Read more...
By Grant Fritchey 2010/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 343 reads

Be Prepared

Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.  Read more...
By Grant Fritchey 2010/01/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 330 reads

Great DBA’s in History

What great historical figures would make great DBAs? A guest editorial from Grant Fritchey examines the traits and characteristics we look for in this role and which famous people we might choose and why.  Read more...
By Grant Fritchey 2009/10/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 455 reads

Don't Build a Monitoring System

Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.  Read more...
By Grant Fritchey 2009/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 778 reads

Review of the Maxpedition Aggressor Tactical Attache

Need a new laptop bag? MVP Grant Fritchey brings us a review of a large and versatile brief case that's a little different than the rest.  Read more...
By Grant Fritchey 2009/07/24 | Source: SQLServerCentral.com | Category: laptop
Rating: |  Discuss |   Briefcase | 1,099 reads

SQL Server Execution Plans

Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.   Read more...
By Grant Fritchey 2009/02/10 | Source: Red-Gate | Category: books
Rating: |  Discuss |   Briefcase | 39,382 reads

Deploying Databases From Visual Studio Team System Database Edition

With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.  Read more...
By Grant Fritchey 2009/06/24 | Source: SQLServerCentral.com | Category: visual studio
Rating: |  Discuss |   Briefcase | 5,175 reads

How to Take Part in a Beta Test

A description of the things to avoid and do when involved with a beta test.  Read more...
By Grant Fritchey 2008/09/26 | Source: SQLServerCentral.com | Category: beta testing
Rating: |  Discuss |   Briefcase | 2,869 reads

Operations Manager Custom Collection

An overview of how to collect data from TSQL into Operations Manager Performance Rules.  Read more...
By Grant Fritchey 2008/06/05 | Source: SQLServerCentral.com | Category: operations manager
Rating: |  Discuss |   Briefcase | 6,297 reads

Virtualization for Database Development

The trials and tribulations of our first attempt using Virtual Servers  Read more...
By Grant Fritchey 2008/04/08 | Source: SQLServerCentral.com | Category: development process
Rating: |  Discuss |   Briefcase | 7,485 reads

Multi-Environment Deployments Using Team Edition for Database Professionals

In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.  Read more...
By Grant Fritchey 2008/01/24 | Source: SQLServerCentral.com | Category: dbpro
Rating: |  Discuss |   Briefcase | 3,063 reads
   Items 1 to 20 of 28    Older >>