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

Introducing SQL Server Reporting Services

In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up the SQL Server stack. One of those products and a key element of the SQL Server family is SQL Server Reporting Services (SSRS). SQL Server Reporting Services is Microsoft’s enterprise…

Read more

0 comments, 2,133 reads

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

BREXIT…IT professionals need a plan… much like the UK government

The events that have unfolded over the last few days since the shock result that the BRExit referendum delivered, has, quite rightly caused a huge amount of press coverage in the UK. The remain camp are very upset and angry at the result, mainly because they can see possible negative…

Read more

0 comments, 191 reads

Posted in The SQL DBA in the UK on 28 June 2016

IT Training: Super Duper Deal!!

In the wake of last week’s BREXIT vote and subsequent fallout, I decided to delay making this announcement until today. I wanted to ensure that this deal didn’t get lost in the shockwaves of the referendum result.

Gethynellis.com has been working in collaboration with Learning Tree since 2010 writing, developing…

Read more

0 comments, 123 reads

Posted in The SQL DBA in the UK on 27 June 2016

SQL Server 2016 RTM – Is Anyone Still Waiting for the First Service Pack?

Well most of the SQL Server news last week focused around the launch of SQL Server 2016. SQL Server RTM dropped on 1st June and a quick twitter poll, suggests that some  people at least will be deploying SQL Server 2016 in production before the end of the year.

  Read more

0 comments, 1,973 reads

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

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, 189 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, 175 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, 231 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, 258 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, 2,094 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, 150 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, 154 reads

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

Test

0 comments, 249 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, 165 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, 164 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, 142 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, 184 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, 317 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, 187 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, 157 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, 163 reads

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

Newer posts

Older posts