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

SQL Server 2016 RC0–Management Studio install option has disappeared

If you are trying to install SQL Server 2016 RC0 – which I’m sure you are all doing looking at the new features that are coming our way soon and wondering how all this cloud stuff passed you by? You might be also be sat there wondering where has the…

Read more

0 comments, 249 reads

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

Creating a Domain Controller

The following is a short guide for promoting a Windows Server 2012 Machine to be a domain controller. This assumes that there is no existing forest or domain. My reason for doing this is to create a test enviornment using virtual machines on Oracle Virtual Box. I'm planning to setup…

Read more

0 comments, 187 reads

Posted in The SQL DBA in the UK on 15 March 2016

SQL Server on Linux

When I started working with SQL Server many years ago, SQL Server on Linux was a regular April fool’s day joke that bloggers used to write about.

With the ever changing SQL Server database engine or just data platform these days. The integration of R and Polybase planned for SQL…

Read more

0 comments, 162 reads

Posted in The SQL DBA in the UK on 8 March 2016

Spring Training: Developing SQL Queries for SQL Server

Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries for SQL Server course in Learning Tree’s London Education Centre.

It’s a four day course starting on Tuesday 19th April and will complete on Friday 22nd April.

Its a really… Read more

0 comments, 199 reads

Posted in The SQL DBA in the UK on 9 February 2016

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career as a data professional using Microsoft's SQL Server data platform could use to learn all about the product. This made me think I about…

Read more

0 comments, 254 reads

Posted in The SQL DBA in the UK on 8 February 2016

Its been a busy start to the year

Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses in Alexandria - a suberb of DC, followed by the same course running again in London a week later. This  was followed by a SQL Server 2012 skills upgrade course

Read more

0 comments, 217 reads

Posted in The SQL DBA in the UK on 5 February 2016

Powerful SQL Queries for SQL Server

New Year, new powerful SQL queries!

Start the New Year off with some great Transact-SQL training and join me for Learning Tree's Powerful  SQL Queries for SQL Server  one day online training course running on the 14th January.

You will learn:

• Maximize the potential of SQL to formulate complex…

Read more

0 comments, 211 reads

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

Most Read: My Top 5 SQL Server Articles and Blogs

There has been some really useful blogs and articles posted over the last week or so, this is my top 5 in no particular order

  • Interesting post here from BrentOzar.com looking at the statistics on the uptake of SQL Server 2014 and the reluctance of businesses to move from older…

Read more

0 comments, 272 reads

Posted in The SQL DBA in the UK on 22 September 2015

Free SQL Azure eBook

As this blog post is being published David will be delivering his “Putting his Head in the Cloud – Working with SQL Azure” talk at SQL Saturday in Denmark.

In preparation for his talk David has and over the last six to seven months been working on an eBook which…

Read more

0 comments, 310 reads

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

SQL Saturday #413 Denmark 2015

David Postlethwaite will be giving his SQL Azure “Putting your head in the clouds – Working with SQL Azure” at SQL Saturday Denmark on the 19th of September

The abstract for David’s session is

“You've learnt the basics of cloud computing and taken a tour of Microsoft Azure. It's now…

Read more

0 comments, 283 reads

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

Kerberos Configuration Manager for SQL Server v3

By David Postlethwaite

I’m speaking about Kerberos for the SQL DBA at SQL Saturdays in Oslo, Gothenburg and Utrecht in September 2015.
Kerberos is one of those things that can drive you nuts and it’s easy to get it wrong.


If you are not aware Microsoft have produced a program… Read more

0 comments, 918 reads

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

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, 339 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, 401 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, 5,380 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, 307 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, 336 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, 262 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, 301 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, 349 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, 351 reads

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

Newer posts

Older posts