Christoffer Hedgate

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.

2006-01-26

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

4.4 (5)

2005-12-23 (first published: )

34,382 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.

4.5 (4)

2005-07-13

16,511 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.

3 (3)

2005-01-20

10,905 reads

Blogs

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Read the latest Blogs

Forums

AWS instance storage

By Dhruva_51

We are planning to use one of AWS instance for sql server and wanted...

Insert New Rows in sql based on difference between 2 dates

By PSB

Hi,   I want to create a new records based on the difference between...

COHESITY for Backup/Restore?

By daniel.dolan

Any one have any experience with using Cohesity as the backup/restore platform instead of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers