Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!

This year its in York (Sept 30th till October 2nd).

SQLBits is the largest SQL Server conference held in Europe, and well worth attending !

After the success of last years event in my home country, this year… Read more

 Log Shipping  By Abi  Chapagai (Revised)

In SQL Server, transaction log provides an ability to recover a database to a point in time. Log shipping is a process of copying the transaction log back up from a source server to a destination server and restore on the destination server.  The… Read more

Introduction 

Replication is the process of copying data between two databases on the same server or different servers on the same database. This is one of the methods to maintain the redundant database site for disaster recovery purpose.  Replication methodology maintains copies of main database from the primary server on… Read more

With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority of cases).

The SQL optimiser struggles when dealing with cursor ridden statements, when a FETCH command is executed, its moreorless the same as an extra SELECT command being executed.

Sometimes… Read more

My first guest editorial published !

http://www.sqlservercentral.com/articles/Editorial/70725/

Would appreciate any comments you have.

Read more

This is something we had to do again recently and its improved our performance and query speeds on one particular system. This information is readily available from various sources and blogs, I just wanted to re-blog and ensure we’re all aware of the benefits gained from using AWE !

Enabling… Read more

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another.

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more

Looking through some of my databases this past week, theres a lot of data there which over time has become redundant and rarely (if ever) used.

So I thought why don’t I just bin it ? I got backups, I could even ship it out to an archived version of… Read more

I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have all helped me in some way or another. 

In this series of blog posts, I hope to share a mixture of them with you – some may be… Read more