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

SQL 2014 CU5

By David Postlethwaite

If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited GUI support for SQL Azure databases. Right click gives you very few options and there’s no designer for tables, views or logins. You will have to brush up on…

Read more

0 comments, 83 reads

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

Mid-Week Update

Just a short mid-week update, David Postlethwaite has been selected to speak at SQL Saturday Vienna which is being held in Vienna at the end of February(28th Feb). David’s talk is titled   Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure.

There have a been couple of…

Read more

0 comments, 137 reads

Posted in The SQL DBA in the UK on 15 January 2015

Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure

David Postlethwaite will be speaking at this years SQL Saturday Vienna. The event will be held in Vienna on Saturday 28th February 2015.

You can read all about this specific event by visiting https://www.sqlsaturday.com/374/eventhome.aspx

David’s talk will be on cloud, this his abstract

Although Windows Azure and the concept of…

Read more

0 comments, 129 reads

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

David Postlethwaite - Exciting news.

By David Postlethwaite

I have been chosen to speak at SQL Saturday in Vienna, Austria  on 28th February.
The organisers have just moved the event to a larger venue to cope with the expected demand.

My talk is entitled Putting Your head in the Cloud– A Beginner’s Guide to SQL…

Read more

0 comments, 98 reads

Posted in The SQL DBA in the UK on 12 January 2015

Website Updated

Over the Christmas holiday period the gethynellis.com website has had a bit of revamp.

In terms of what has changed, some of the holding pages have been updated and also the look and feel of the site in the form of a new template. Most of this work has been… Read more

0 comments, 118 reads

Posted in The SQL DBA in the UK on 6 January 2015

New Learning Tree 1 Day SQL Server Training

Learning Tree has recently introduced some new 1 day virtual training events There is range of courses and subjects for you to choose from and you can find out more about these by following the link on the image below.

These are 1 day instructor led events that you will…

Read more

0 comments, 150 reads

Posted in The SQL DBA in the UK on 5 January 2015

E-Book Offer – Coming to an End

Back in December just before Christmas I wrote a post about a deal that Packt publishing has on its ebook range over the holiday period.

Until Tuesday the 6th Januray you can get can any ebook for $5…That works out about £3 in UK money.

This includes my book, Getting… Read more

0 comments, 110 reads

Posted in The SQL DBA in the UK on 2 January 2015

Happy New Year

Just short post from me and the pooches to wish you all a very happy new year.

Have a great one!

Geth

Read more

0 comments, 134 reads

Posted in The SQL DBA in the UK on 31 December 2014

Offer – Any e-book for $5

Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5 (£3.60 in British money).

This includes my book, Getting Started with SQL Server 2012 Administration 

The offer will run from Thursday 18th Dec 2014 to Tuesday 6th Jan 2015,… Read more

0 comments, 156 reads

Posted in The SQL DBA in the UK on 19 December 2014

SQL Bits – Europe’s largest SQL Conference

4th 7th March
ExCeL Centre in London, England

SQLBits have announced their dates for 2015.
I have been three times and it is an excellent opportunity to learn and meet fellow DBAs and developers.
This year it has expanded to FOUR days, two training days featuring industry experts and two…

Read more

0 comments, 965 reads

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

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, 245 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,746 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, 5,169 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, 351 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, 288 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,304 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, 294 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,770 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, 286 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, 247 reads

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

Older posts