Reputation
24,735
Next tag badge:
96/100 score
62/20 answers
Badges
2 27 60
Newest
 Yearling
Impact
~1.8m people reached

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
Jul
29
comment Connecting Windows 7 client to NT4 server share in AD domain
Try disabling Kerberos?
Jul
26
comment SQL and Shadow Protect Server
There's no need to manually backup the SQL Server databases. This can all be automated from within SQL Server by setting up jobs within SQL Server to do the database backups while the database is online and running without any user impact.
Jul
15
comment Disable all installers, but still be able to install via intune
Some questions which will probably need to be asked... What version are the clients? Can they be domain joined? What version servers are you running? What rights do the users need (not want) to have?
Jul
15
comment Real trouble for opening port in SQL Server 2008
Can you screenshot and post the SQL Server config Manager, specifically Config Manager > SQL Server Network Configuration > Protocols for {instance name} > TCP/IP properties on the IP Addresses tab?
Jul
15
comment Real trouble for opening port in SQL Server 2008
Is it a named instance or the default instance?
Jul
15
answered Real trouble for opening port in SQL Server 2008