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

Azure SQL Elastic Pools

In this video  tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to share compute power between different Azure databases.  This can be particularly useful if you have databases with differing or varying performance requirements.

With Azure SQL Database you can allocate  DTUs…

Read more

0 comments, 124 reads

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

Renaming a local windows login after SQL Server Computer Name Change

I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server was running the Database Engine, Reporting Services and Integration Services

I actually run through a blog post I wrote the best of 8 years ago titled Renaming a Standalone Instance…

Read more

0 comments, 1,074 reads

Posted in The SQL DBA in the UK on 15 January 2018

SCOM: SQL Instance and Databases exclusion

This  post is by Chris Gibson

I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM environment.  These databases are created during a backup process and are always named “_Clone”.  I’d previously excluded SQL Express instances by their name (Maps, Live, MSEE) and…

Read more

1 comments, 271 reads

Posted in The SQL DBA in the UK on 10 January 2018

Patching your SQL Servers - Meltdown and Spectre

The latest security issue with the name "Meltdown and Spectre" affecting Intel processors  was made public last week. This security issue affects a lot of systems and Operating Systems it is not a Microsoft specific issue. I think I read somewhere that ALL Mac devices are affected. Whilst details…

Read more

0 comments, 289 reads

Posted in The SQL DBA in the UK on 8 January 2018

What is the oldest version of SQL Server you are running?

I have a  twitter poll running asking "What is the oldest version of SQL Server you are running?", to use as evidence in a talk I have planned for later in the year. 



I’d like to know what is the oldest version of SQL Server  you have running in a…

Read more

0 comments, 216 reads

Posted in The SQL DBA in the UK on 3 January 2018

New Year: 2017 Year in Review

Welcome to gethynellis.com and our final post of the year.



SQL Server 2017 - In Review


It’s the end of what has been interesting  and successful year here gethynellis.com on both the SQL Server consulting and SQL Server training side of the business.


-->
On the consulting front we…

Read more

0 comments, 213 reads

Posted in The SQL DBA in the UK on 30 December 2017

Server Roles and Azure Active Directory in an Azure SQL Database

This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login a server roles and how to give an Azure Active Directory user permissions to an Azure SQL database.




You can download the free ebook: Putting Your Head in the Cloud:…

Read more

0 comments, 257 reads

Posted in The SQL DBA in the UK on 29 November 2017

An Introduction to Azure SQL Databases

This David's SQL Server Saturday talk titled an introduction to Azure SQL Databases


It does pretty much what is says on the tin. it gives an Introduction to Cloud Computing and Azure SQL Databases

Read more

0 comments, 1,843 reads

Posted in The SQL DBA in the UK on 28 November 2017

Monitoring and Alerts with Azure SQl Database

Continuing with the Azure SQL Database theme, in this short video David demonstrates how to setup alerts for an Azure SQL database and build a dashboard to monitor the metrics of your Azure SQL database




You can download the free ebook: Putting Your Head in the Cloud: An Introduction to…

Read more

0 comments, 1,008 reads

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

SOS - Save Our Souls or SQL Operations Manager

On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry! Well I asked myself the same question and did some digging.



SQL Operations Studio a client tool for working with SQL Server... It was announced at the PASS summit last…

Read more

0 comments, 303 reads

Posted in The SQL DBA in the UK on 17 November 2017

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database?


If you work in a hybrid environment with some databases stored on your on premises SQL Server instances and you also have deployed some databases to Azure SQL Database, maybe you have archived a bunch of data up…

Read more

0 comments, 428 reads

Posted in The SQL DBA in the UK on 15 November 2017

Connecting to an Azure SQL Databases

Connecting to an Azure SQL Databases is pretty simple and straight forward,as long as you know what you need in order to safely and securly establish a connection.

In this short introductory video david shows you what you need to do,such as

  • Setting firewall rules 
  • Finding the connection string needed…

Read more

1 comments, 213 reads

Posted in The SQL DBA in the UK on 8 November 2017

Configuring Azure Data Sync

In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an "On premises" SQL server.

As the name suggests the Azure Data Sync tool allows you to synchronise data between Azure SQL databases and other databases both on Premises and in…

Read more

1 comments, 1,101 reads

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

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, 258 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, 217 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,329 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.

Question:


Goal: I…

Read more

0 comments, 1,498 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, 295 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, 307 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, 297 reads

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

Older posts