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

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.

Question:


Goal: I…

Read more

0 comments, 170 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, 122 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, 157 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, 202 reads

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

Building Always On Availability Groups - Part 1

Introduction

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,422 reads

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

Dynamic Data Masking

By David Postlethwaite


Introduction


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, 494 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, 1,689 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, 413 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, 297 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, 145 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, 63 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


Introduction

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

Read more

0 comments, 498 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,547 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, 266 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, 414 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



Introduction 

This introduction to Containers and Dockers…

Read more

0 comments, 1,155 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, 216 reads

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

Permanent Employment v Contracting: How the figures stack up

In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over at BrentOzar.com collected and made available back in January 2017. The data is very interesting and in my first post on this topic over the learning Tree blog, we…

Read more

0 comments, 3,182 reads

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

Valentine's day love from Learning Tree...

The latest course offer is in from Learning Tree!! And It's Valentine's Day!
Learning Tree are showing you the love with some great courses on offer for £750 plus VAT

Why don't you get your boss to treat you to training the spring.

Blow away the cobwebs and learn something…

Read more

0 comments, 210 reads

Posted in The SQL DBA in the UK on 14 February 2017

SQL Server 2008 RTM - Maintenance Plans need Integration Services installed

The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not go into here I have been building some SQL Server 2008 instances. This is because of a large SQL Server migration project that I’m working on for a client. The…

Read more

2 comments, 373 reads

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

Older posts