3,676 reputation
418
bio website
location Birmingham, United Kingdom
age 32
visits member for 1 year, 8 months
seen Jan 23 at 16:03

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.


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
Feb
22
comment How to include the value of the query parameter in the email body using sp_send_dbmail
Have you tried this? social.msdn.microsoft.com/Forums/en-US/transactsql/thread/…
Feb
22
comment SSMS 2008 Object exploer not showing
You should mark this as the answer for people in the future who experience the same issue. :-)
Feb
22
comment “The SELECT permission was denied” only for some of my tables
Are the statements run dynamically within the body of the procedures?
Feb
22
answered Microsoft Baseline Configuration Analyser on Production
Feb
22
answered Choosing the right algorithm in HashBytes function
Feb
22
comment Modify all tables in a database with a single command
No there is not a way to do what you want in a single command.