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

Archives: January 2012

Blogging: Starting a Blog

Following on from the first post in my blogging series Building a Blog I’m just going to take a  quick look at some of the blogging platforms you can choose to manage your blog. The most common platform that I have come across if WordPress. I haven’t really used… Read more

0 comments, 705 reads

Posted in The SQL DBA in the UK on 30 January 2012

Blogging: Building a Blog

I took an interest in building  a blog/website several years ago when I first started my company and working for myself. Over the years I have tried many different approaches and over the last few years I have settled on using my blog to build my brand.

More recently a… Read more

4 comments, 721 reads

Posted in The SQL DBA in the UK on 27 January 2012

Rename an Analysis Services Instance

This is just a short post for Friday. I have been working a fair amount with SSAS and the rest of the BI stack and recently  I was asked to install a default instance of SSAS on server that already had a named instance installed. I didn’t think this would… Read more

0 comments, 3,861 reads

Posted in The SQL DBA in the UK on 20 January 2012

Help JHD Help MND

My good friend Justin Hostettler-Davies (JHD) aka @JHDAVIES , the same JHD who recently scaled Kilimanjaro, is on the fund raising trail again.  I hope you can help him.

Justin with his mountain climbing experience behind him is continuing with his endurance events, he is running the London Marathon this… Read more

0 comments, 770 reads

Posted in The SQL DBA in the UK on 16 January 2012

Twitter, John, Building a Blog and #MEME15

I saw an interesting post this morning care of the micro-blogging/social networking site twitter that really got me thinking about blogging.

John Sansom (Blog|@JohnSansom) wrote a very interesting post participating I believe in the second assignment of meme15. Meme15 is a monthly blogging event created by… Read more

0 comments, 1,448 reads

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

How safe are your secrets?

We’ve all have service accounts, application accounts, sysadmin and domain admin accounts and other privileged shared accounts on our systems. These are all vital to the running of our applications and databases.
But do you keep them safe?
Are the passwords held somewhere secure, do you audit who looks them… Read more

0 comments, 626 reads

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

Morning Checks - Forewarned is forearmed

It’s always handy to know if there any problems with your servers before you get into work in the morning. This is why I wrote a program that goes round all our SQL instances at 7am and checks they are all up. If it doesn’t get a reply from one… Read more

0 comments, 645 reads

Posted in The SQL DBA in the UK on 9 January 2012

Are you allowed to use social networking at Work?

I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content and context of the article seem to imply that Council staff are wasting time surfing the internet and social networking sites like twitter and Facebook instead of working. In my… Read more

1 comments, 930 reads

Posted in The SQL DBA in the UK on 6 January 2012

2012: SQL Server, Olympics, Football and Darts

Today is the first day of 2012 and some commentators and bloggers in the SQL Server blog space use this time to write blog posts  about resolutions and goals  they have set themselves for the coming year. In other sphere’s especially the political blog space, bloggers see this as a… Read more

0 comments, 1,064 reads

Posted in The SQL DBA in the UK on 1 January 2012