3,776 reputation
519
bio website
location Birmingham, United Kingdom
age 32
visits member for 2 years, 4 months
seen Nov 20 at 14:28

I am a SQL Server DBA for a global utilities company. I am MCP, MCDBA and MCITP certified and currently working towards my MCM.

In my spare time I like to write music and spend time with the family.


Nov
4
reviewed Approve Return rows one at a time from variable table
Sep
30
awarded  Explainer
Aug
4
awarded  Yearling
Jul
22
comment SQL Server 2000 : Upgrade from Personal Edition to Enterprise Edition
Sometimes you are bound by third parties, or corporate decision makers. We have some critical systems still running on DOS, why I hear you ask... well because they work. Sometimes you don't have a choice.
Jul
17
reviewed Approve Trouble quering a join in oracle sql
Jul
17
reviewed Approve How to import Sybase .db file into SQL Server database?
Jan
23
comment Why does SQL Server run a subquery for each row of the table it's qualifying?
What is the result of moving your sub-query from the where clause into the body of the query as a inner join? select a.month, count(*) from SubQueryTest a join (select max(year) as [year] from SubQueryTest b) as b on a.year = b.year group by a.month
Aug
4
awarded  Yearling
May
31
awarded  Revival
Mar
1
comment The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline
A quick google of your error message came up with this as the top hit: support.microsoft.com/kb/2008654
Mar
1
answered Message system - delete message, or flag for deletion?
Feb
28
revised Create procedure in else block on SQL Server
Added content based on edit.
Feb
27
comment Create procedure in else block on SQL Server
Hi @sharad thank you for your feedback, please could you explain why this is not helpful to you. I may be able to improve on the answer if you give more detail.
Feb
27
answered Create procedure in else block on SQL Server
Feb
27
answered Pervasive linked server provider missing
Feb
26
comment What are the best practices for backing up a secured SQL Server 2012?
Sorry, I am a little confused - in your question you say that it is secured with a 3rd party certificate then below you say SSL. Are you talking about database encryption or an encrypted transport layer? What exactly is secured with the certificate and how is that certificate used?
Feb
22
comment What are the best practices for backing up a secured SQL Server 2012?
I have updated the link for you now - sorry about that: msdn.microsoft.com/en-us/library/bb964742.aspx
Feb
22
comment How to include the value of the query parameter in the email body using sp_send_dbmail
Did the example I gave you work?
Feb
22
comment What are the best practices for backing up a secured SQL Server 2012?
Have you had a read through this? The only reason I ask is because if so then I probably wouldn't post an answer, and if you haven't I recommend that you do. technet.microsoft.com/en-us/library/bb964742.aspxb964742.aspx
Feb
22
answered How to include the value of the query parameter in the email body using sp_send_dbmail