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

SQL Bits 7 – Registration is Open !

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

0 comments, 586 reads

Posted in DatabaseExpertise.com on 29 July 2010

Log Shipping By Abi Chapagai (Revised)

 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

2 comments, 1,116 reads

Posted in DatabaseExpertise.com on 29 July 2010

SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai

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

3 comments, 23,784 reads

Posted in DatabaseExpertise.com on 28 July 2010

Curb those Cursors !

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

5 comments, 268 reads

Posted in DatabaseExpertise.com on 15 July 2010

“One of the Pack to Top Dog”

My first guest editorial published !

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

Would appreciate any comments you have.

Read more

0 comments, 175 reads

Posted in DatabaseExpertise.com on 15 July 2010

Enabling Memory Support for over 4GB of Physical Memory

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

1 comments, 399 reads

Posted in DatabaseExpertise.com on 12 July 2010

Mix & Match – Day 4

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

0 comments, 125 reads

Posted in DatabaseExpertise.com on 12 July 2010

Mix & Match – Day 3

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

0 comments, 125 reads

Posted in DatabaseExpertise.com on 8 July 2010

Mix & Match – Day 2

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

0 comments, 152 reads

Posted in DatabaseExpertise.com on 6 July 2010

Bin the unwanted to reap the rewards !

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

0 comments, 120 reads

Posted in DatabaseExpertise.com on 4 July 2010

Mix & Match – Day 1

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

0 comments, 160 reads

Posted in DatabaseExpertise.com on 4 July 2010

SQL Server 2008 R2 RTM CU2 released.

Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 2. It became available for download today, and you can request it here. It includes 18 fixes, (mostly for SSAS and SSRS)

Read more

1 comments, 243 reads

Posted in DatabaseExpertise.com on 23 June 2010

SQL Server DBA – Interview Questions

Has anyone got any good Senior DBA interview questions ?

Read more

6 comments, 991 reads

Posted in DatabaseExpertise.com on 21 June 2010

SQL Server MasterClass Event Review

I often begrudge a 5am start to travel anywhere, let alone to SQL events but this was a trip definitely worth making.

 SQL Server MasterClass presented by Kimberly L. Tripp (Click here for Blog)  & Paul S. Randal (Click here for Blog) – MasterClass was a… Read more

1 comments, 199 reads

Posted in DatabaseExpertise.com on 19 June 2010

Daily SQL Server 2008 New Feature – Day 24

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Wednesday 16th June… Read more

0 comments, 148 reads

Posted in DatabaseExpertise.com on 16 June 2010

Daily SQL Server 2008 New Features – Day 23

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Tuesday 15th June… Read more

0 comments, 134 reads

Posted in DatabaseExpertise.com on 15 June 2010

Daily SQL Server 2008 New Feature – Day 22

 Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Monday 14th… Read more

2 comments, 165 reads

Posted in DatabaseExpertise.com on 14 June 2010

Hello World Cup !

As the World Cup dawns on us – I was just wondering how many nationalities this site attracts ??

Do we have representatives from every World Cup country ??

By the way, I’m Welsh so this excludes me !

If you’re into football enjoy the tournament – if you’re not… Read more

2 comments, 153 reads

Posted in DatabaseExpertise.com on 11 June 2010

Daily SQL Server 2008 New Feature – Day 21

 Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Friday 11th… Read more

0 comments, 176 reads

Posted in DatabaseExpertise.com on 11 June 2010

Daily SQL Server 2008 New Feature – Day 20

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Thursday June… Read more

0 comments, 156 reads

Posted in DatabaseExpertise.com on 10 June 2010

Newer posts

Older posts