SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

David is delivering his Microsoft Azure for the SQL DBA talk this weekend in SQL Saturday Denmark. Go and see him if you attending the event - you can find his session in the schedule

David has updated his eBook Putting Your Head in the Cloud: An Introduction to…

Read more

0 comments, 156 reads

Posted in The SQL DBA in the UK on 5 October 2017

Kerberos Explained - Taming the Beast: Kerberos for the SQL Server DBA

David has a talk that he delivers at SQL Saturdays, all about Kerberos authentication.  What it is, how it works and the impact it can have on databases administrators if things sometime go awry with what is needed for it function correctly.

The talk  is called  “Taming the Beast: Kerberos…

Read more

0 comments, 140 reads

Posted in The SQL DBA in the UK on 4 September 2017

New in SQL Server 2017: Graph Databases

David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you can watch below, David provides an excellent introduction into SQL Server 2017 Graph Databases. In his presentation he looks at Tennis results at tournaments for  his favourite player "The Fed"…

Read more

4 comments, 2,166 reads

Posted in The SQL DBA in the UK on 21 August 2017

SQL Server Express v SQL Server Developer Edition

SQL Server Express v  SQL Server Developer Edition

Over the weekend I received the following in an email from Ali Ahmad who asked me some questions about learning SQL Server. We exchanged a couple of emails so I have boiled this down to the most salient points.


Goal: I…

Read more

0 comments, 276 reads

Posted in The SQL DBA in the UK on 1 August 2017

Video Tutorial: Creating a SQL Server Databases

In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll also discuss some of the database options you can set when creating a database. We will look at creating database objects such as tables, indexes and stored procedures in a…

Read more

0 comments, 189 reads

Posted in The SQL DBA in the UK on 31 July 2017

SQL Server Management Studio: Video Tutorial

SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server. In this short tutorial we look at how you can download install and connect to a SQL Server instance and have a quick look at object explorer and some of…

Read more

2 comments, 222 reads

Posted in The SQL DBA in the UK on 25 July 2017

Installing SQL Server: Video Tutorial

In this video I talk you through installing SQL Server 2017 RC1 on Windows Server 2016 virtual machine. It’s a nice simple process.

If you need help with SQL Server check out our SQL Server Consultingpage

Read more

1 comments, 233 reads

Posted in The SQL DBA in the UK on 24 July 2017

Building Always On Availability Groups - Part 1


By David Postlethwaite

Ensuring that your databases can survive a major outage such as a server failure and can continue to work is an important task of being a DBA.
Database Mirroring was introduced in SQL 2005 and was quite straight forward to setup.
Mirroring only allowed for one…

Read more

5 comments, 1,549 reads

Posted in The SQL DBA in the UK on 3 July 2017

Dynamic Data Masking

By David Postlethwaite


Dynamic data masking is a really useful new tool in SQL Server 2016. Keeping data safe is one of the most important tasks that a company has; this goes further than just making sure that users can only see their own data and hackers can’t get…

Read more

0 comments, 539 reads

Posted in The SQL DBA in the UK on 9 May 2017

Always Encrypted

By David Postlethwaite

Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database. Here you can encrypt columns in a table with a master key and a certificate so that they will appear as encrypted strings to those who don’t have the…

Read more

1 comments, 2,031 reads

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

2 Great Courses For Databases Professionals - Deal Of the Week

I received  the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education Center this May. There are 2 Great  Courses For Databases Professionals.  Aside from the SrumMaster course which is priced separately you can get the courses listed for £750 plus…

Read more

0 comments, 448 reads

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

What is SQL Server?

I’ve been playing around with YouTube, making some tutorial videos on SQL Server and it’s been a fun process so far. For my first video I decided to start at the beginning – This video looks at what SQL Server is? Basically what comes under the SQL Server umbrella? What…

Read more

0 comments, 357 reads

Posted in The SQL DBA in the UK on 20 April 2017

Gethyn Ellis:My SQL Server You Tube Channel

Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning on put lots of tutorials and how to videos on there. David P already has his own, where he records his SQL Saturday talks. Mine will be a little…

Read more

0 comments, 169 reads

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

UK Contracting: Brexit, Dividend Tax and IR35 Having a Huge Impact

At the end of March I wrote a couple of posts discussing the state of IT industry. It looked at how government changes to dividend tax and possibly the Brexit vote last year seemed to have an impact on small business creation in the UK in the period running from…

Read more

0 comments, 89 reads

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

An Introduction to Conatiners and Docker: Switch to Windows Containers

This is Chris Gibson's second post. This post follows on from his first post called: An Introduction to Containers and Docker. You can read all about Chris on our About Us Page


So far you have a fresh install of Docker for Windows, which is cool.  However, by…

Read more

0 comments, 606 reads

Posted in The SQL DBA in the UK on 23 March 2017

Dividend Tax Changes and Brexit – Damaging to UK IT company creation

In my previous post titled UK Budget 2017 –The Death Knell for Small Business? We scratched the surface in discussing how economic decisions made during political events like the budget, can impact on business creation and people’s wiliness to follow their ideas and dreams and start their own business. 2016…

Read more

1 comments, 1,599 reads

Posted in The SQL DBA in the UK on 22 March 2017

UK Budget 2017 – The Death Knell for Small Business?

Well I suspect not however I suspect it will likely have a major impact. What has this got to do with SQL and Data I hear you ask? I’m going to provide a little background first. Over the last week or so it has been an interesting political week here…

Read more

0 comments, 311 reads

Posted in The SQL DBA in the UK on 21 March 2017

An Introduction to SQL Server 2016 Query Store

By David Postlethwaite

David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this post has been scheduled to coincide with his talk

If you are at SQL Saturday Iceland today go and see his session.

There will be a series of…

Read more

0 comments, 474 reads

Posted in The SQL DBA in the UK on 18 March 2017

An Introduction to Containers and Docker

By Chris Gibson

This is the debut blog post  of  Chris Gibson. Chris is in expert in Microsoft  Windows and is turning his attention more and more to the Cloud. You can read more about Chris on the About Us Page


This introduction to Containers and Dockers…

Read more

0 comments, 1,207 reads

Posted in The SQL DBA in the UK on 16 March 2017

Do you need a degree to be DBA?

This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen many blogs and posts addressing this question. From recollection, most of the posts I read came down on the side of not needing a university or college education…

Read more

2 comments, 244 reads

Posted in The SQL DBA in the UK on 2 March 2017

Older posts