Reputation
25,235
Next tag badge:
98/100 score
62/20 answers
Badges
3 30 62
Newest
 Good Answer
Impact
~2.1m people reached

Jun
18
comment Cannot access my database, it says database inaccessible
Try restarting management studio. If that doesn't work I'll need a screenshot to see what's going on.
Jun
18
comment Cannot access my database, it says database inaccessible
Are there any errors? Can you post a screenshot of Object Explorer? Are you sure you are connected to the correct instance of SQL Server?
Jun
16
awarded  Nice Answer
May
2
awarded  Yearling
May
1
awarded  Notable Question
Apr
17
awarded  Notable Question
Mar
21
awarded  Revival
Mar
19
answered Can't get AD inter-site replication to work over VPN
Mar
15
awarded  security
Feb
20
answered Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors
Dec
27
awarded  Nice Answer
Dec
26
comment How to protect SQL Server from Hackers
If someone is connecting to the SQL port from a public IP Address, then the firewall isn't configured correctly. If they are coming from an internal IP then you've got some other kind of problem. SQL by it self doesn't support certificates. You have to do this via AD and certificate mappings.
Dec
24
answered How to protect SQL Server from Hackers
Dec
5
comment Server Performance Issue - Server 2008, SQL 2008 and Hyper-V [screenshots]
Depends on how the queries are written in Linq. I've seen some truly horrible stuff out there with different columns in the where clause for different situations bloating the hell out of the plan cache. Also Linq tends to make the parameters which it uses the same size as the value, so when passing in "Bob" and "Fred" you get two plans because the parameters are different sizes.
Dec
5
comment Windows Azure Blob Storage Data Migration
Yep, just was announced in October or November.
Sep
3
comment Are there any naming conventions for services and their associated domain?
These days so little is directly accessible from the public internet that most of my clients are hosting everything from www using content redirection within their load balancers to route stuff to different servers so that everything is masked to the user.
Sep
3
answered SSIS/ETL jobs fail with network related errors, when network is OK
Sep
3
answered Are there any naming conventions for services and their associated domain?
Jul
31
comment What software should I use for fault tolerence/high availability for 2 servers
It really depends on what service you are trying to protect as to which solution you should be using. What are you trying to protect?
Jul
31
answered Connect over WiFi to SQL Server from another computer