341 reputation
17
bio website numbersforletters.com
location Dallas, TX
age 38
visits member for 4 years, 3 months
seen Oct 2 at 14:40

Tech, Music, Games.

  • SQL Server 2005-2012 (Microsoft employee)
  • Sonar X1, X2
  • Reason 6
  • Ableton Live

Jun
28
comment Is Sql Azure useful without windows azure?
Another consideration is that SQL Azure performance is very different than SQL On-premise performance. Specifically in terms of connectivity and scaling options. As such the application will have to be built to specifically address these issues. It is very common to see an app that will work great on premise have problems with connection timeouts and throttling. More info: social.technet.microsoft.com/wiki/contents/articles/…
Apr
26
comment MSSQL Datafile on DFSR
Can't agree enough. Native SQL Backups are what you need to be doing. support.microsoft.com/kb/2027537
Apr
24
comment Windows Server 2003 Restarts after bootscreen
Can you provide screenshot that includes entire message. It's cut off on the left side of the screen.
Apr
8
comment Migrating data from SQLEXPRESS local DB to SQL Azure
have you been able to do any further tests on your issue?
Apr
8
comment Previously I was able to remote into my azure virtual machine (windows server 2008r2) but now I get remote logins are currently disabled
good to hear you figured it out.
Apr
4
comment Azure Cent OS Unmounts my data Drive
It's possible that the host server may have been updated which would prompt an update. The best way make sure you're application stays online if/when this happens would be to implement the availability sets.
Apr
4
comment Previously I was able to remote into my azure virtual machine (windows server 2008r2) but now I get remote logins are currently disabled
What is the status of the VM in the Azure dashboard? If you restart/resize the VM does the problem still persist?
Mar
28
comment SQL Server ODBC Connection via Command Line
Glad the answer worked for you. Please indicate it was the answer.
Mar
18
comment Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication
A few other question: What version of SQL Server are you using? How is Ready-Roll making the change (TSQL? RMO?)
Mar
8
comment MS SQL Start Mirroring Error
Just updated the answer.
Mar
7
comment SQL 2005 replication not working
Is this transactional replication?
Mar
7
comment SQL 2008 R2 Clustering AND DB Mirroring (Async)
What was the error message you received on the mirror server when trying to connect? These would likely be in the SQL Server error logs on the mirror server.
Mar
7
comment MS SQL Start Mirroring Error
Based on your description above it sounds like you're using SQL Authentication to connect to the instance. Is the SQL Server service accounts running under a domain account or a built-in account (i.e. Local System, Local Service, etc)?
Mar
7
comment MS SQL Start Mirroring Error
Yeah - mirroring can be kind of a nightmare to get setup. Have you tried dropping and recreating the endpoints?
Sep
5
comment SQL - an error occurred during the pre-login handshake
Also if you look in the SQL error logs you can also wee what port it is listening on: 2012-09-04 09:12:58.74 Server Server is listening on [ 127.0.0.1 <ipv4> 64746].
Oct
14
comment Implementing dual control SQL updates in SQL Server
Agreed. Let your app do that.
Oct
14
comment How do you verify a job candidates resume?
At this point in our technical history the ability to memorize and recall arbitrary technical information is worthless. Understanding how find the technica linformation you need and how it all fits together will always be more marketable than surviving technical gauntlets.
Oct
8
comment What is the best way to copy large files from my workstation to a Windows Server based EC2 instance?
Thanks! Let me know if it works for you CLJ.
Oct
6
comment What is the best way to copy large files from my workstation to a Windows Server based EC2 instance?
If you're connecting via RDP you should be able to do some of the copying via command line which would at least free up your clipboard.
Oct
6
comment MS10-070 update for 2003 R2 SP1
Jon - my original wording was something along the lines of "Looksl ike you might be in the unenviable position of asking your client ot update their server". Maybe you could recommend hacking their project up in Perl. ;)