Meet Thomas Kejser in Aarhus

• by Geniiius

• SQL Server Notes from the Field

This is normally not a place where we advertise for events held by our friends, but today I’ll make an...

2012-09-06

737 reads

SQL Rally 2012 Nordic

• by Geniiius

• SQL Server Notes from the Field

The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...

2012-06-26

857 reads

DBCC CHECKDB

• by Geniiius

• SQL Server Notes from the Field

Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s...

2012-05-31 (first published: 2012-05-29)

118,624 reads

Backup compression using IBM TDP for SQL Server

• by Geniiius

• SQL Server Notes from the Field

If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in...

2012-05-15

1,769 reads

Troubleshooting Database mail

• by Geniiius

• SQL Server Notes from the Field

Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to...

2012-05-08

9,007 reads

Automatic page repair with SQL Server Mirroring

• by Geniiius

• SQL Server Notes from the Field

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...

2012-05-01 (first published: 2012-04-24)

3,119 reads

How to Configure Database mail

• by Geniiius

• SQL Server Notes from the Field

In my daily job as a SQL Server consultant I go to a lot of places, many days on the...

2012-05-01

7,746 reads

Visualize Wait stats with Microsoft Excel

• by Geniiius

• SQL Server Notes from the Field

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...

2012-04-18

1,141 reads

Instance Wide Wait Stats

• by Geniiius

• SQL Server Notes from the Field

Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking...

2012-04-11 (first published: 2012-04-09)

2,449 reads

Nifty queries using a Numbers helper table

• by Geniiius

• SQL Server Notes from the Field

(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...

2012-04-09 (first published: 2012-04-04)

4,486 reads