Reputation
3,926
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
5 19
Newest
 Explainer
Impact
~367k people reached

Mar
16
reviewed Approve Need help achieving HAProxy active/passive configuration for mysql
Mar
9
reviewed Approve PHPMyadmin transactions not commited
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?