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

Archives: July 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, 195 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, 223 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, 236 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,562 reads

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