Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 244 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, 230 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, 393 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, 218 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, 340 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, 269 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, 1,159 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, 394 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,938 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, 10,557 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, 545 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, 475 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,609 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, 525 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, 2,047 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, 633 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, 421 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, 421 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, 345 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, 7,705 reads

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

Newer posts

Older posts