Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2010

When was SQL Server last restarted?

How do you tell when your SQL instance was lasted restarted?

I was reading a post by Joe Webb (Blog|Twitter) about a query he uses to to gather information about his clients SQL Server instance including how he find out when an instance of SQL Server… Read more

11 comments, 3,900 reads

Posted in The SQL DBA in the UK on 29 April 2010

SQL Server Connection Strings

The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string for your SQL Server servers and databases.  This tip was first showed to me by a friend of mine, Paul Blackwell, a while back and I wanted to share it… Read more

442 comments, 8,309 reads

Posted in The SQL DBA in the UK on 28 April 2010

SQL Server Replication Overview

For my next series of blog posts I intend to document and write about SQL Server replication. This is a pretty large topic and I make no claims to an expert in replication but over the last couple years I have been working with replication more and more and I… Read more

0 comments, 657 reads

Posted in The SQL DBA in the UK on 27 April 2010

Microsoft Teleconference – Ted Kummert (Senior VP) and Tom Casey (General Manager of BI)

Microsoft  held a big teleconference today, which I unfortunately got called away from a minutes into it. The call was basically the launch of SQL Server R2. There are numerous posts from floating around from some high profile community members:

Brent Ozar’s post is here

Mr Denny’s Post is here Read more

0 comments, 197 reads

Posted in The SQL DBA in the UK on 21 April 2010

Virtualisation – An Introduction

For the last two years or so, in one capacity or another I have been running SQL Server in virtual land and I wanted to start writing some blog posts on the subject .

I thought I would start providing  a definition of virtualisation and then I thought better of… Read more

0 comments, 236 reads

Posted in The SQL DBA in the UK on 21 April 2010

SQL Server 2008 R2 – Release Date

This is a very short post

I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release on 21st May 2010.

Read more

2 comments, 188 reads

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

Third Party Backup Tools – Redgate SQL Backup

To continue my little blog series on SQL Server backups, any series would not be complete without a look at some of the third party products that exist to supplement a backup plan with additional functionality not always offered in the native SQL Server backup.

My favourite tool and the… Read more

3 comments, 1,277 reads

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

T-SQL Tuesday #005 – Offloading Reporting (#TSQL2sDay)

Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things I have done in the past to offload reporting to another server to reduce the overhead of running reports against production OLTP databases.

A few years… Read more

1 comments, 218 reads

Posted in The SQL DBA in the UK on 13 April 2010

db_executor role

This process might not be granular enough for some but there is a nice simple way of creating a role in a SQL Server database  and granting it execute permissions on all stored procedures, then when you want to give someone execute permissions to all Stored Procedures you simply add… Read more

1 comments, 2,067 reads

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

Q1 - review

I didn’t post my professional goals for the year on my blog at the start of this year, my blog was new and I wasn’t sure that it was appropriate. Instead I made a written note in my paper based diary – I still keep one of those, not for… Read more

3 comments, 185 reads

Posted in The SQL DBA in the UK on 8 April 2010

Uninstall 64 bit and reinstall 32 bit SQL Server

For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard edition (Including Integration Services ) and re-install the 32 bit SQL Server standard edition.

The uninstall seemed to complete successfully so I went on my merry way and I attempted… Read more

0 comments, 682 reads

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

Differential Backups

My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log backups and a note on how to manage backup files. The next in my little series on  backups is a short post on differential backups in SQL Server. Read more

1 comments, 554 reads

Posted in The SQL DBA in the UK on 4 April 2010

Powershell – Useful Resources

One of my aims at the start of the year was to improve my Powershell and scripting skills. I run a few Google searches looking for resources and had plenty of results returned, but finding the ‘wheat from the chaff’ proved difficult. So I turned to twitter and asked the… Read more

0 comments, 573 reads

Posted in The SQL DBA in the UK on 1 April 2010