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

SSMS Auto Recovery

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

SQL Server Management Studio will autosave your unsaved query every few minutes so if if your pc…

Read more

0 comments, 56 reads

Posted in The SQL DBA in the UK on 17 April 2014

From where does SSMS get its database defaults?

We can create a database simply by typing in the command

create database DB1 



We don’t have to provide any other parameters for SSMS to be able to create the database

My Question is from where does SQL get the default values when we create a database without any options?

Read more

0 comments, 148 reads

Posted in The SQL DBA in the UK on 16 April 2014

Missing Database Owner

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

A scenario
A DBA creates a new database and by doing so he become the owner of…

Read more

0 comments, 78 reads

Posted in The SQL DBA in the UK on 14 April 2014

Alter Table Not Permitted

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

You may have come across this error message when using SQL Server Management Studio

It’s new in…

Read more

0 comments, 70 reads

Posted in The SQL DBA in the UK on 10 April 2014

Dedicated Administrator Connection

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

If a SQL instance isn’t responding or you can’t login for some reason then SSMS has a…

Read more

0 comments, 87 reads

Posted in The SQL DBA in the UK on 9 April 2014

SQL Saturday Exeter

A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time, my friend, colleague and fellow contributor to this blog, David Postlethwaite was making his full speaking debut delivering a session entitle “Real DBAs Don’t need a GUI” it was a… Read more

0 comments, 76 reads

Posted in The SQL DBA in the UK on 7 April 2014

SQL Server 2012 and Virtual Service Accounts

This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the default account for the SQL services has changed from that used in previous versions. With SQL 2005 and 2008 the default account for SQL service and SQL Agent service…

Read more

0 comments, 295 reads

Posted in The SQL DBA in the UK on 13 January 2014

SQL Server Training in London this Christmas

If you are thinking of upgrading to SQL Server 2012 in the near future then why not join me in London this December, Wednesday 18th to Friday  20th December at Learning Tree’s London Education Centre (LEC) which is based at Euston House on Eversholt.

You can read more about the… Read more

0 comments, 111 reads

Posted in The SQL DBA in the UK on 9 December 2013

Superfast Broadband – can be a drawn out slow and frustrating process

I’m writing this blog post to simply to vent some frustration. I live in Wales’ third largest city, Newport and for some obscure unbelievable reason I am unable to get high speed internet. BT’s online speed check currently tells me the very best I can hope for is…

I never… Read more

0 comments, 148 reads

Posted in The SQL DBA in the UK on 6 December 2013

Test Post – Please ignore

I’m just testng out my new laptop making sure things are working as they should

Read more

0 comments, 128 reads

Posted in The SQL DBA in the UK on 18 November 2013

SQL Server Training Events–November and December 2013

I’m in New York City this week delivering a SQL Server Virtualization and Consolidation 3 days course for Learning Tree. You might be a little too late to join me at that event but I have two more course scheduled this year

At the end of November 27th-30th I’m teaching… Read more

0 comments, 151 reads

Posted in The SQL DBA in the UK on 29 October 2013

Job: SQL Server DBA (Permanent UK)

A client of mine are looking for a good SQL Server DBA on a permanent basis, the location is flexible with offices in the South West and South London. The role offers a competitive package with excellent benefits, they are a great company to work for. If you have some… Read more

0 comments, 226 reads

Posted in The SQL DBA in the UK on 5 September 2013

SQL Saturday #200 - Philadelphia

If you read my post from yesterday you will know I will be spending some time on the US east coast at the end of May.Last week my friend and fellow Learning Tree instructor Sharon Dooley asked me if I would like to attend SQL Saturday #200 in Philadelphia which… Read more

0 comments, 284 reads

Posted in The SQL DBA in the UK on 8 May 2013

SQL Server Travels–May 2013

 

At the end of this month of May, I will be teaching Learning Tree’s 3 day SQL Server Virtualization course at Learning Tree’s Washington DC’s Rockville education centre. The course will run from Wednesday 29th May through to Friday 31st May. You can enrol for this course by following… Read more

0 comments, 237 reads

Posted in The SQL DBA in the UK on 7 May 2013

SQL Server Training in the Summer Time

Its been a long winter so far this weekend has seen the first signs of spring here in South Wales, the Sun has been out nearly all weekend. The temperatures have been in double figures most of the time and I even got to cut the grass and fix so… Read more

0 comments, 263 reads

Posted in The SQL DBA in the UK on 22 April 2013

Friday Fun – Football Derbies

This is an off-topic post for a Friday. With Cardiff City reaching the premier league this week and all the joy that had brought Cardiff City fans throughout South Wales this week I thought this might make a nice change of topic and a bit of fan on a Friday.… Read more

0 comments, 257 reads

Posted in The SQL DBA in the UK on 19 April 2013

TSQL Tuesday #41–Presenting and Loving it?

Well sort of…it took a while.

I’d done some plays and singing at school but my mother made me practice and practice and practice and she  was always in the crowd to cheer me on so it was never that bad, if ever I forgot my lines my mother who… Read more

0 comments, 260 reads

Posted in The SQL DBA in the UK on 9 April 2013

@LearningTree: SQL Server High Availability

Learning Tree are offering their 3 day SQL Server High Availability course this April in London. Running between 17th and 19th of April and taught by Chris Radcliffe come and learn all about SQL Server high availability and get your hands dirty with

  • SQL Server Clustering
  • Database Mirroring
  • Availability Groups

Read more

0 comments, 378 reads

Posted in The SQL DBA in the UK on 28 March 2013

Slide Deck–SQL Saturday Exeter

In my session (An Introduction to SQL Server Virtualisation) at SQL Saturday Exeter I told the attendees that I would be making my slide deck available after the event. In my blog post early this week where I reviewed my day at SQL Saturday Exeter I also mentioned that I… Read more

1 comments, 342 reads

Posted in The SQL DBA in the UK on 13 March 2013

SQL Saturday Exeter - Review

This last weekend I attended my first SQL Server Saturday event. The event was held in The Jury’s Inn in Exeter and was superbly arranged and organised by Jonathan (b|t) and Annette (b) Alan and the great team of volunteers from the SQL South… Read more

1 comments, 302 reads

Posted in The SQL DBA in the UK on 11 March 2013

Older posts