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

Regular Columnist: Christoffer Hedgate

SQLServerCentral.com profile

I work in Lund, Sweden, at a company called Apptus Technologies. Apptus are specialized in database research and consulting, including development of search engines. Most of the time I work with SQL Server as an architect, administrator and developer, but I have also done some work with other DBMS such as Oracle and TimesTen. I also do some programming, mainly in Visual Basic, C# and Java (plus a couple of scripting languages). I am also the co-owner of sql.nu (http://www.sql.nu/) where you can find more articles from me.

   Items 1 to 20 of 20   
 

Dynamic Management Objects

These are not the DMO bits you are thinking of from SQL Server 2000. SQL Server 2005 introduces a new way of digging into the inner workings of the server with both Dynamic Management Views and Dynamic Management Functions. Longtime SQL Server guru Christoffer Hedgate looks at these new ways of understanding your server.   Read more...
By Christoffer Hedgate 2006/01/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,692 reads

A Report from the PASS Community Summit 2005

It just ended, but Chris Hedgate filed a report from the airplane as he sped home at 30,000ft across the Atlantic.   Read more...
By Christoffer Hedgate 2005/10/06 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,075 reads

CLR Integration

One of the more controversial new features in SQL Server 2005 is the inclusion of the Common Language Runtime (CLR) inside the server. Whether you agree this is a good idea or not, the very knowledgable Chris Hedgate brings us the first article in a series looking at how the CLR fits into your database server.   Read more...
By Christoffer Hedgate 2005/07/13 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 16,289 reads

How to use trace flags in SQL Server 2000

SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. There are a number of ways that they can be enabled and Chris Hedgate brings us a tutorial on their use and benefits.   Read more...
By Christoffer Hedgate 2007/06/21 (first published: 2005/05/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 25,033 reads

On the Trail of the ISO Week

Chris Hedgate, one of our regular SQL Server columnists, recently became intrigued by the way that SQL Server implements the week number. His concern was why SQL Server treats week 53 as week 1, which is not that way that ISO6801 sees it. Read about his investigation into the methods of implementing an algorithm to solve this problem.   Read more...
By Christoffer Hedgate 2005/01/20 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 10,819 reads

Moving System Databases - A Checklist

The default location for the SQL Server system databases doesn't always meet the standards of many organizations. Author Chris Hedgate has taken the time to put together a short checklist on how you can move the master, msdb, model, and tempdb databases easily.   Read more...
By Christoffer Hedgate 2004/11/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,645 reads

Fragmentation 101

Another article from our own Chris Hedgate! This one looks at the different types of fragmentation that can exist inside your SQL Server and some ways you can go about minimizing them.   Read more...
By Christoffer Hedgate 2006/01/06 (first published: 2004/05/10) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 47,820 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,344 reads

Worst Practice - Not Qualifying Objects With The Owner

Regular columnist Chris Hedgate follow up on Andy's recent article about Worst Practices with one of his own. This is worth passing on to your development team.   Read more...
By Christoffer Hedgate 2004/03/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 16,857 reads

Review of Lumigent Log Explorer v4

Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.   Read more...
By Christoffer Hedgate 2004/02/13 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 7,764 reads

SQL Injection!

Do your developers really understand how to prevent injection attacks? Or scarier still, how many know what an injection attack is? Chris has some great examples of how sql injection works and how to prevent it.   Read more...
By Christoffer Hedgate 2004/02/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 16,707 reads

Dealing With Changing Data

As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,421 reads

Indexed Views

Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.   Read more...
By Christoffer Hedgate 2003/12/02 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 12,144 reads

Review of SQLDiff by Lockwood

Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.   Read more...
By Christoffer Hedgate 2003/10/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,901 reads

Cluster That Index - Part 2

Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.   Read more...
By Christoffer Hedgate 2003/10/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 8,530 reads

SQL and Java Go on a Date

Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.   Read more...
By Christoffer Hedgate 2003/09/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,566 reads

Cluster That Index! Part Two

Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!   Read more...
By Christoffer Hedgate 2003/08/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 9,742 reads

Review of SQL Stripes

We asked Chris to take a look at SQL Stripes, and here are the results!  Read more...
By Christoffer Hedgate 2003/07/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,794 reads

Cluster That Index!

Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.   Read more...
By Christoffer Hedgate 2003/03/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,072 reads

Advice on using COUNT( )

In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).   Read more...
By Christoffer Hedgate 2002/09/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 13,062 reads
   Items 1 to 20 of 20