Archives: April 2010
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
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
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
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
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
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
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
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
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
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
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
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