I found a post of setting up database access in the following site and I responded there and I wanted to share with you all about the problem and the solution that I came with.

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/databaseloginconnection-3532715

Problem:
I have 2 database on a sql server name 1) Medical 2) Insurance.… Read more

Sorry guys, I’m off for a week in the sun – will return June 2nd with more SQL Server 2008 New Features.

In the meantime – any of you out there have any favorite features of your own  -please post !

Have a good week all !

http://databaseexpertise.com/category/sql-server/

Read more

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 21st May… Read more

Further to my post on May 18th regarding the above event – I have been able to secure a further £50 discount off usual ticket prices – its now only going to cost £149 – for what is truly going to be a great event, execellent value for money and… Read more

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 20th

Language… Read more

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 19th May… Read more

The top things YOU need to know about managing SQL Server – in one place, on one day – presented by two of the best SQL Server industry trainers!

 This one-day MasterClass will focus on many of the top issues companies face when implementing and maintaining a SQL Server-based solution.… Read more

 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 18th… Read more

 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 18th… Read more

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 17th May… Read more

 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 14th May… Read more

 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 13th May… Read more

by Abi Chapagai – Saturday, May 08, 2010

I have recently set up database mail in SQL Server 2008 in production SQL server Instance. I would like to share what I have learnt and how did I set up this powerful feature of sending notifications in SQL server 2008.

Introduction Read more

  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 12th May… Read more

 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 11th May… Read more

http://www.sqlservercentral.com/blogs/sqldbauk/archive/2010/04/29/when-was-sql-server-last-restarted_3F00_.aspx

A very good tip from the SQL DBA in the UK!

Read more

 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 10th May… Read more

Log Shipping Issue (encountered by Abi Chapagai May 7th)

 I had set up log shipping between two servers few weeks ago. Monitor server is the primary server in my set up.  Log shipping was running fine but when I checked the log shipping status today from the primary and secondary… Read more

Heres a thought

With all the monitoring tools and performance gauging software available on the market these days, will there ever come a day when DBAs, or certainly ‘teams’ of dedicated DBAs, become surplus to requirement ?

Has the role of a DBA changed significantly over the last 5 /… Read more

 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 7th May… Read more