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

Win a Free Copy of my Book - Getting Started with SQL Server 2014 Administration

Readers of my blog would be pleased to know that I have teamed up with Packt Publishing and we are organizing a Giveaway for you to celebrate the release of my book and two lucky winners stand a chance to win an e-copy of Getting Started with SQL Server 2014… Read more

0 comments, 142 reads

Posted in The SQL DBA in the UK on 12 June 2014

I’ve Written a Book…Getting Started with SQL Server 2014 Administration

That’s folks you heard it here first. Since the end of 2013 through to April this year I have been working a book called “Getting Started with SQL Server 2014 Administration” the book is pretty much a look at the new features that would interest the DBA working with the… Read more

0 comments, 1,563 reads

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

SSMS Add-ons

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.

SSMS is a fantastic tool but many people and companies have found ways to enhance it to make it even…

Read more

0 comments, 2,923 reads

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

SSMS Queries on Function Keys

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 you have simple queries or functions that you use regularly you can assign them to a…

Read more

0 comments, 199 reads

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

SQL Server Training – Spring 2014

I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA skills upgrade class in an onsite class to one of Learning Tree’s clients. For those of you that don’t know, a Learning Tree onsite is event is when Learning… Read more

0 comments, 164 reads

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

Central Management Studio CMS

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.

One of the subjects I covered was Registered Servers and the Central Management Studio
These are two…

Read more

0 comments, 1,120 reads

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

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, 155 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, 1,631 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, 164 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, 131 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, 140 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, 147 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, 1,004 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, 163 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, 221 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, 182 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, 211 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, 270 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, 338 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, 283 reads

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

Older posts