168 reputation
17
bio website maxvernon.tel
location Canada
age 45
visits member for 2 years, 1 month
seen Sep 26 at 19:38

Max Vernon is an independent consultant operating in the SQL Server and Microsoft.Net spaces. He has reasonable rates, and is open to engagements world-wide.

profile for Max Vernon on Stack Exchange, a network of free, community-driven Q&A sites
DBA.se all time rank

Join me on LinkedIn at http://www.linkedin.com/pub/max-vernon/23/a0/598
I'm on Twitter at: http://twitter.com/max_vernon
Check my Flickr photo stream: http://flickr.com/photos/max_vernon

My careers 2.0 profile is at http://careers.stackoverflow.com/maxvernon


Sep
13
comment Server 2012 closed ports issue
"Netstat -b" from an administrative cmd.exe prompt should show some exe listening on the desired port.
Sep
13
comment Server 2012 closed ports issue
It's a Windows box; have you tried restarting it? Sounds to me like nothing is listening on the port(s) in question.
Jun
24
comment Copying files with tilde has odd behaviour
Windows removes the tilde from the file name when looking to see if an existing file with that name already exists.
Oct
28
comment unable to join domain using virtualbox
What does ipconfig -all show? (on one of the VMs)
Oct
28
comment unable to join domain using virtualbox
Are all three VMs on the same physical machine?
Apr
30
comment SQL Server: Worse performance on a new server
Have you configured MAXDOP to the number of cores / CPU node? With the bigger machine, and the default MAXDOP setting of 0, parallelized queries will be much more parallel and will be consuming far memory instead of local memory. This has the potential to slow the new machine quite a lot. We talked about MAXDOP extensively over at dba.stackoverflow.com on this question: dba.stackexchange.com/questions/36522/…
Mar
28
comment Need some information about using SQL-Express 2012 with an OLD databse software
the .BAK files are SQL Server backups... you need to use SQL Server to RESTORE DATABASE on those files to restore the original .mdf and .ldf (if that is necessary)
Mar
28
comment Need some information about using SQL-Express 2012 with an OLD databse software
and clearly they don't have a backup of the entire system from before the virus infection?
Mar
27
comment Unable to connect to the Logical Disk Manager service
I looked at the GUID in DuckDuckGo.com and found these possible causes and resolutions: bit.ly/XHxhwE
Mar
12
comment Configuring VPN on Windows Server 2008 with no DHCP
turn off outside access to your SQL Server immediately unless you are 100% certain you can afford to lose everything on the server. All it takes is one mistake on your behalf and you will regret ever opening that can of worms. For the VPN, you can configure a static range of IPs to be handed out by the Server.
Mar
12
comment SQL Server ODBC Connection via Command Line
I don't understand the "remotely via command line" bit. Are you saying you want to connect to a machine and use cmd.exe to create a text file that contains an ODBC connection string?
Oct
2
comment PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM
The only way this is related to DBA.SE is because it's a vm hosting a SQL Server. The question is entirely unrelated to SQL Server, or databases in general. The question ONLY relates to how to look at Windows Performance Monitor.
Oct
2
comment PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM
I've flagged this to be moved to ServerFault.se
Sep
4
comment What is the default RAID-50 stripe size on a Dell EqualLogic PS6510?
I've looked at Dell's support site, and have looked at the online help for the SAN itself, no luck. We have a question in to Dell, and are waiting for an answer now.
Sep
4
comment What is the default RAID-50 stripe size on a Dell EqualLogic PS6510?
That's been my experience too; no definitive answers!
Sep
4
comment What is the default RAID-50 stripe size on a Dell EqualLogic PS6510?
Thanks for that constructive help. It's unfortunately a bit late to change to RAID 10 now, without reformatting the entire SAN. Besides that, RAID 50 provides higher data capacity than RAID 10.
Sep
4
comment What is the default RAID-50 stripe size on a Dell EqualLogic PS6510?
Because it provides the RAID characteristics we identified as important at install.
Aug
31
comment How do I redirect output to a single line in Bash?
You should attempt to ask an actual question in the title of your post since that will get you a lot more attention...
Aug
31
comment NMap route determination on Windows 7 x64
See nmap.org/book/man-bugs.html for details on how to determine if the problem is a bug with nmap.
Aug
30
comment SQL - an error occurred during the pre-login handshake
What version of SQL Server is this? How are you attempting to connect to the SQL machine; using SQL Server Management Studio or an app you developed, etc? Have you tried restarting the SQL Server service and the server machine?