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

Archives: June 2010

DB2 – Create a Database

OK for my next DB2 trick and remaining off the path of the righteous for the time being we will look at creating a DB2 database. I assume that you have the DB2 RDBMS software installed, you can get a free 'community' copy of the express edition, follow this link… Read more

2 comments, 1,729 reads

Posted in The SQL DBA in the UK on 30 June 2010

DB2 Editions

This is a little bit off topic for me but on Friday I was asked to look at a DB2 instance and sort out some issues with the CPU maxing out. Make no mistake I’m no DB2 expert, but I have done some small pieces of work on it previously,… Read more

2 comments, 273 reads

Posted in The SQL DBA in the UK on 28 June 2010

Lock Pages in Memory

It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging out SQL Server memory.

how do you do this?

Well, the answer is straight forward...If you have SQL Server Enterprise Edition:

You allocate the service account running SQL Server the… Read more

5 comments, 4,691 reads

Posted in The SQL DBA in the UK on 25 June 2010

24 Hours of PASS

On the 19th/20th May (last month) the Professional Association of SQL Server (PASS) held its second 24 hours of PASS event . '24 hours of PASS' consists of 24 individual hour long meetings/presentations/training session all with a SQL Server 2008 R2 theme, held online and delivered by some of the… Read more

0 comments, 238 reads

Posted in The SQL DBA in the UK on 23 June 2010

Windows 2008 R2 Install Error - Using VMWare Workstation

Recently I was installing Windows Server 2008 R2 Enterprise Edition onto a virtual machine (VM) I was setting up to carry out some testing when I encountered the following error:

"The unattended answer file contains an invalid product key. Either remove the invalid key or provide a valid product key… Read more

0 comments, 1,101 reads

Posted in The SQL DBA in the UK on 22 June 2010

Football Update

Well the World Cup is now half way through, 32 games played, 32 games to go. The talk here in the UK has focused around England their poor start. Two games played, one goal scored, one goal conceded, two draws, no wins, no losses, and they seem to lurch from… Read more

4 comments, 201 reads

Posted in The SQL DBA in the UK on 21 June 2010

SQL Server MasterClass

This Thursday gone, (June 18th) I went to a hotel near Heathrow airport in London for what was titled a “SQL Server MasterClass” and I was not disappointed.

I have attended several taught MCP SQL Server training courses over the years and several conferences including SQL Bits and this MasterClass… Read more

2 comments, 348 reads

Posted in The SQL DBA in the UK on 21 June 2010

Finding Duplicates

This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a table. I needed to identify some duplicate records for a supplier recently and I wanted to make some notes on what I did for future reference.


 

First I will create…

Read more

0 comments, 495 reads

Posted in The SQL DBA in the UK on 18 June 2010

The Football World Cup

This day only comes around once in every four years, we've all been waiting for it for months. It's been in the news and media, there has been a great deal written about qualification, preparation and selection and now with all that done and dusted its finally arrived...The start of… Read more

2 comments, 219 reads

Posted in The SQL DBA in the UK on 11 June 2010

SSMS 2008 and changing a SQL 2005 SA password.

You can probably tell from some of my more recent posts that I have been doing some work lately on SQL Server 2008. I have also recently (the last two months) upgraded my work desktop to Windows 7. As a result of this of this, and the continued migration away… Read more

1 comments, 938 reads

Posted in The SQL DBA in the UK on 9 June 2010

T-SQL Tuesday #007 - Policy Based Management

It's that time of the month again, time for the next round of T-SQL Tuesday posts. This month is being hosted by Jorge Segarra (Blog | Twitter) and we are blogging about new features in SQL Server 2008 and SQL Server 2008 R2. Plenty of scope then as… Read more

1 comments, 465 reads

Posted in The SQL DBA in the UK on 8 June 2010

Cannot Connect to SQL Server

I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to connect to said instance using Management studio on my desktop i received the following error message:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The… Read more

1 comments, 289 reads

Posted in The SQL DBA in the UK on 7 June 2010

SQL Server 2008 Installation Fails to Start

Recently I have been installing a new SQL Server 2008 instance on Vmware vSphere based  virtual server, the OS was Windows 2008 R2. I have done this several times before and I don't recall ever getting this issue. Seeing as it took me a short while to figure out what… Read more

0 comments, 630 reads

Posted in The SQL DBA in the UK on 4 June 2010

Weekly Update - Internet Issues

I haven’t written anything technical or SQL Server related for that matter on my blog for a few of weeks. Mainly because I spent a couple of  weeks in Florida celebrating my birthday. I did take my laptop on my holidays mainly because we booked everything flight, car, hotel etc… Read more

2 comments, 218 reads

Posted in The SQL DBA in the UK on 3 June 2010

Test Post

Test Post - This will be deleted

Read more

0 comments, 284 reads

Posted in The SQL DBA in the UK on 2 June 2010