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

Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite

On the Database Scale page we can decide on the performance level that we want our database to have.
There are three performance levels Basic, Standard and Premium

  • Basic is best suited for a small size database, supporting one single operation at a time such as for…

Read more

0 comments, 131 reads

Posted in The SQL DBA in the UK on 28 May 2015

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite

Once you have created your database you can now start to manage and configure it.

There are six menus for a SQL Azure Database: -

  • Dashboard
  • Monitor
  • Scale
  • Configure
  • GEO-Replication
  • Auditing and Security
The Dashboard

The Dashboard gives an overview of the state of your Azure database.… Read more

0 comments, 122 reads

Posted in The SQL DBA in the UK on 26 May 2015

Creating an Azure SQL Database

By David Postlethwaite

Once you have logged in to the Azure Management Portal you can start to  create an Azure SQL Database.
Azure SQL Database is an example of Platform as a Service (PaaS), we don’t have to build a Windows server or install the SQL software or configure the…

Read more

0 comments, 4,799 reads

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

Getting Started with Microsoft Azure

By David Postlethwaite

The URL for Microsoft Azure is http://azure.microsoft.com.

Make sure you have an up to date browser because parts of this web site don’t work properly with Internet Explorer 8.The web site is full of articles, blogs and videos on Azure to help you get started and… Read more

0 comments, 135 reads

Posted in The SQL DBA in the UK on 19 May 2015

Putting Your Head in the Clouds - Microsoft Azure

By David Postlethwaite
Microsoft Azure

Let’s take a look at the Microsoft Cloud offering. Originally called Windows Azure it was renamed in March 2014 to Microsoft Azure to reflect Microsoft now offering more than just Windows. At the time of writing Azure is available in 141 countries, including China, and…

Read more

0 comments, 169 reads

Posted in The SQL DBA in the UK on 14 May 2015

Putting Your Head in the Clouds 3 – Cloud Service Offerings

By David Postlethwaite
Cloud Service Models
There are three main service models in the cloud. You will see these buzz words being used a lot in cloud discussions:
  • IaaS   - Infrastructure as a Service
  • PaaS  Platform as a Service
  • SaaS  Software as a Service
To get a better understanding what…

Read more

0 comments, 101 reads

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

Putting Your Head in the Clouds 2 –Advantages and Disadvantages of Cloud Solutions

By David Postlethwaite

If you are thinking about using Cloud Computing then it’s worth considering the pros and cons.

Advantages of the Cloud

Why would you want to use the cloud?

Quick Setup
You can provision a fully functioning database server in just a few minutes whereas on your premises…

Read more

0 comments, 156 reads

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

Putting Your Head in the Clouds 1 – An introduction to Cloud Computing

By David Postlethwaite
Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it is only relatively recently  that it has matured to the point where it is no longer just an interesting curiosity but a serious contender as a business solution.
Microsoft…

Read more

0 comments, 142 reads

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

SQL Server 2016 Preview...Coming this Summer

It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With it being a bank holiday in the UK … I missed it yesterday


Some the new features announced include :
Always Encrypted

Read more

0 comments, 163 reads

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

Windows Temporary Profile

Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc you get the message that you have been logged in with a temporary profile.
Well that was what happened to me Friday evening. My heart sank. Have I lost all…

Read more

0 comments, 128 reads

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

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, 164 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, 158 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, 157 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, 125 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, 143 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, 190 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, 132 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, 164 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, 181 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,003 reads

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

Older posts