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

Meet Thomas Kejser in Aarhus

This is normally not a place where we advertise for events held by our friends, but today I’ll make an exception to that rule. Our friends at Orangeman has made a scoop, two that is actually .

In October, Orangeman is hosting two interesting courses here in Aarhus, the teacher… Read more

0 comments, 335 reads

Posted in SQL Server Notes from the Field on 6 September 2012

SQL Rally 2012 Nordic

The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that I’m talking about. If you haven’t booked your ticket yet, then it is about time.

SQLRally Nordic 2012 is taking place Monday, October 1st – Wednesday, October 3rd, at the… Read more

0 comments, 354 reads

Posted in SQL Server Notes from the Field on 26 June 2012

DBCC CHECKDB

Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s pretty simple to do, and it _could_ save you some big trouble later on.

What is it?

The command “DBCC CHECKDB(<db name>)” checks the logical and physical integrity of all… Read more

2 comments, 33,478 reads

Posted in SQL Server Notes from the Field on 29 May 2012

Backup compression using IBM TDP for SQL Server

If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in the lucky possition to be able to compress your SQL Server backups. Often I see installations of these versions, where compression is not enabled. Let me show you a couple… Read more

0 comments, 706 reads

Posted in SQL Server Notes from the Field on 15 May 2012

Troubleshooting Database mail

Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to do when everything looks fine, but no mail is flying through the system – what is wrong?.

After testing, if you are unable to receive notification emails,… Read more

0 comments, 1,156 reads

Posted in SQL Server Notes from the Field on 8 May 2012

How to Configure Database mail

In my daily job as a SQL Server consultant I go to a lot of places, many days on the road, and many nights at different hotels. All these things are a part of the job, so of course I am not complaining.

What some times can be a challenge… Read more

0 comments, 3,479 reads

Posted in SQL Server Notes from the Field on 1 May 2012

Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring versus the more traditional Failover Clustering. Both are features provided by SQL Server for achieving high availability, buth they both have pro’s and con’s that could make a decision hard.… Read more

0 comments, 1,444 reads

Posted in SQL Server Notes from the Field on 24 April 2012

Visualize Wait stats with Microsoft Excel

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected wait stats with Microsoft Excel, so this is what this blog post will be about.

The blog post from last week will be the basic setup for this one, so… Read more

0 comments, 581 reads

Posted in SQL Server Notes from the Field on 18 April 2012

Instance Wide Wait Stats

Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking sampling and other techniques. Today we are taking a few steps back, and demonstrate how you could start looking at performance problems on a system that you don’t know anything… Read more

1 comments, 1,518 reads

Posted in SQL Server Notes from the Field on 9 April 2012

Nifty queries using a Numbers helper table

(The complete usable code is in the very bottom of this blog post)

Some of you may have seen this “numbers table” technique in use before, but I thought I would share a few simpel examples to those of you that haven’t seen the light yet

Lets start with a… Read more

4 comments, 3,398 reads

Posted in SQL Server Notes from the Field on 4 April 2012

Debugging query timeouts by sampling blocking – part 2

In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every once in a while. I knew for certain, that the affected queries were waiting for 30 seconds for an intent exclusive lock on something, before a timeout occurs.

Our good… Read more

7 comments, 1,858 reads

Posted in SQL Server Notes from the Field on 15 March 2012

Debugging query timeouts with X-Events – part 1

I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No, I like hunting for SQL queries that are messy, or down right nasty. My latest hunting adventure was to find the root cause for intermittent query timeouts, that could happen… Read more

0 comments, 953 reads

Posted in SQL Server Notes from the Field on 10 March 2012

How to use Change Data Capture (CDC)

With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around with it before, but the other day I was asked if CDC might be used for a specific purpose. Because I had no previous experience using CDC, I had to… Read more

0 comments, 3,309 reads

Posted in SQL Server Notes from the Field on 5 March 2012

MERGE with OUTPUT clause

A few days back I was presented with a theoretical challenge, and now I thought I would share my solution with you. The challange was to keep track of changes on a table that we had only a readonly access to, and keep a history of the changes. Furthermore the… Read more

9 comments, 4,906 reads

Posted in SQL Server Notes from the Field on 21 February 2012

ANUG: Masters at Work

In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at work. The session was no surprise about SQL Server performance. If you missed the ANUG event, you now have the option to listen to an ANUGCast with Henrik Sjang Davidsen,… Read more

0 comments, 492 reads

Posted in SQL Server Notes from the Field on 14 February 2012

PIPE CLIP – (| CLIP)

The main focus of this blog is to write about SQL Server related stuff – but now and then in the past we have written a few blog posts which was not 100% SQL Server related – and that is exactly what I am going to do today.

A few… Read more

0 comments, 396 reads

Posted in SQL Server Notes from the Field on 7 February 2012

Meet the Geniiius Family

Over the next few weeks / months there will be plenty of opportunities to meet the Geniiius family, since we started the company we have not done many public presentations. This is something that we will start to do more of in the following months, and hopefully after the summer… Read more

0 comments, 694 reads

Posted in SQL Server Notes from the Field on 31 January 2012

Generate test data using DBGen

Over the last couple of months I have on several occasions found myself in need of test data for demos, blogposts etc. You all know AdventureWorks, which will work for a lot of demoing stuff. But the amount of data is limited, and if you are demoing stuff about performance,… Read more

2 comments, 1,979 reads

Posted in SQL Server Notes from the Field on 24 January 2012

TOP WITH TIES

I have been working with SQL Server for quite a few years now, and it still happens quite often that I discover new cool things to do in t-sql. My latest discovery is not a new feature at all, because it was introduced back in SQL Server 2005 – but… Read more

2 comments, 1,931 reads

Posted in SQL Server Notes from the Field on 17 January 2012

SQL Server 2012 FileTable – Part 2

In this weeks blog post we will have a look at how easy it is to combine FileTables and FullText Search. Last week we had a look at some of the basics of the new FileTable feature – if you missed out on last week blog post, you can read… Read more

2 comments, 1,793 reads

Posted in SQL Server Notes from the Field on 12 January 2012

Older posts