SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Grant Fritchey

SQLServerCentral.com profile

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

<< Newer    Items 21 to 40 of 42    Older >>
 

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 | 11,273 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,685 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 | 263 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 | 353 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 | 333 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 | 471 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 | 814 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,100 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: Redgate | Category: books
Rating: |  Discuss |   Briefcase | 44,878 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,188 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,870 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,469 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,491 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,073 reads

The T-SQL Quiz

Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.   Read more...
By Grant Fritchey 2007/05/28 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 17,957 reads

Putting Unit Tests to Work

Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.   Read more...
Rating: |  Discuss |   Briefcase | 7,320 reads

Unit Testing With Visual Studio

Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.   Read more...
By Grant Fritchey 2006/11/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,079 reads

Unit Testing and Code Generation

One of the fundamental skills a developer needs is the ability to test their code. Most people don't really do a good job, partly because they don't have a good process and leave testing until the end. Grant Fritchey brings us a new method of unit testing T-SQL stored procedures that can help you build automated tests for your code.   Read more...
Rating: |  Discuss |   Briefcase | 17,141 reads

Outer Join Mystery

Working with outer joins can be tricky since the syntax doesn't always appear to make sense. Grant Fritchey brings us a great example of how this confusion can cause issues if you use the old style syntax.   Read more...
By Grant Fritchey 2006/05/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 15,133 reads

SQL Rescue Review

Having a good tool to read your SQL Server transaction log can be a lifesaver, or a job saver. RegGate Software, maker of a number of useful SQL Server utilities has a log reader and Grany Fritchey takes a look at this product and how it might work in your environment.   Read more...
By Grant Fritchey 2005/11/01 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 9,849 reads
<< Newer    Items 21 to 40 of 42    Older >>