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

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, 55 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, 94 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, 99 reads

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

Test

0 comments, 193 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, 107 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, 122 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, 104 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, 125 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, 175 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, 119 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, 118 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, 117 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, 177 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, 161 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, 132 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, 174 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, 223 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, 193 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, 190 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, 246 reads

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

Older posts