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

Putting your Head in the Clouds–An Introduction to Cloud Computing and Microsoft Azure

If you attended David’s session Putting your Head in the Clouds today at SQL Bits today you can download the create database script and his slide deck from the links below:


Also David mentioned his eBook in the talk today you can download that for free using the… Read more

0 comments, 158 reads

Posted in The SQL DBA in the UK on 7 May 2016

Go and See David’s Session at SQL Bits on Saturday

In yesterday’s blog about the latest version of David’s book on SQL Azure I mentioned David was delivering his SQL Azure talk  at SQLBITs tomorrow. So I thought I’d write a short post for a Friday encouraging you to go.


You will find David in Dome 8 at 2.30pm…

Read more

0 comments, 133 reads

Posted in The SQL DBA in the UK on 6 May 2016

Free eBook – Azure SQL Databases


PuttingYour Head In the Cloud An Introduction to Cloud Computing and Azure SQLDatabases by David Postlethwaite has been revised in readiness for David’s session at SQL Bits this coming Saturday


 

Since the publication of the first edition of this book last year, the Azure portal has changed significantly and…

Read more

0 comments, 167 reads

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

Word Wrap in SQL Server Management Studio

I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this…

“Can you get the text in management studio to word-wrap?”

Word-wrap is not on by default. You can see from the image  below we… Read more

0 comments, 203 reads

Posted in The SQL DBA in the UK on 4 May 2016

Word-wrap in SQL Server Management Studio

I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this…

“Can you get the text in management studio to word-wrap?”


Word-wrap is not on by default. You can see from the image  below…

Read more

0 comments, 1,981 reads

Posted in The SQL DBA in the UK on 4 May 2016

Weekly Round-up 30 April 2016


It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and a very enjoyable week it was too.  Couldn’t get tickets for the Raptors playoff game so I have to make do watching it on TV and treat myself to…

Read more

0 comments, 126 reads

Posted in The SQL DBA in the UK on 3 May 2016

Can’t RDP to Azure VM?

I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016 RC0 on it. For testing purposes. Looking at Stretch databases a new feature in SQL Server 2016

I run through the usual wizard to spin up a VM but I…

Read more

0 comments, 119 reads

Posted in The SQL DBA in the UK on 18 April 2016

Test

0 comments, 212 reads

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

Weekly Roundup–SQL Server and Related News

Happy Tuesday . Here's the latest technology based blogs and articles I have been reading this week. Mainly SQL Server themed but a couple of others in there for good measure.

SQL Server

Searching for a string in an Object definition in a database. That is find a reference to…

Read more

0 comments, 127 reads

Posted in The SQL DBA in the UK on 12 April 2016

SQL Server 2005 is Now Out of Support (12 April 2016)

SQL Server 2005 is now out of support. I remember going to a SQL Server 2005 launch event at the premises of Microsoft partner is South Wales back in the day.

It feels like the end of an era.

If you still have SQL Server 2005 instances and databases you… Read more

0 comments, 135 reads

Posted in The SQL DBA in the UK on 11 April 2016

TSQL– Search for Strings in Object Definitions

I have been  working nn an environment  that had multiple copies of a database on the same SQL server instance. In this case the SQL Server was acting as both a UAT and Training environment.
The application was supported by two databases. Each database had the need to reference objects…

Read more

0 comments, 121 reads

Posted in The SQL DBA in the UK on 6 April 2016

Weekly Roundup–SQL Server and Related News

Welcome to this weeks weekly round up of links, SQL Server and other news. Its been a busy week on the work front but still made time for some reading. The #Build2016 announcements were very interesting and the most interesting are included here.

David is currently in the process of… Read more

0 comments, 145 reads

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

SQL Server 2016 Azure Virtual Machines

With the release candidates coming thick and fast for SQL Server 2016 downloading, uninstalling the previous version and installing the latest can be a little bit tedious.
A less timing consuming option to trying the latest is to use Microsoft Azure. If you have an Azure subscription you can spin…

Read more

0 comments, 216 reads

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

SQL Server News–29th March 2016

This past weekend is one of my favourite holiday weekends - the 4 day Easter weekend :-)  Although I have had to work through most of it…With the holiday and the fact I've been busy with a new system go-live this post is slightly  late as a result.

On Thursday…

Read more

0 comments, 140 reads

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

SQLBITS 2016 Agenda has been Published

The agenda for this year’s SQLBITs has been published you can find it here  http://sqlbits.com/information/event15/Agenda.aspx?20160507

Our very own David Postlethwaite has been selected to give one of his talks.

Congratulations to David on getting selected to speak at the event.

The event takes place in Liverpool between 4th –…

Read more

0 comments, 132 reads

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

Weekly Round-up 21st March 2016


Here are some of the more interesting links that I have found this week

SQL Server

SQL Server 2016 RC1 has been released. https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/18/sql-server-2016-release-candidate-1-now-available/?utm_source=twitterfeed&utm_medium=twitter I've not had a chance to look at RC0 in too much detail yet. Although I did notice that Microsoft have split the SQL Server client…

Read more

0 comments, 132 reads

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

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, 215 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, 174 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, 147 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, 188 reads

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

Older posts