163 reputation
17
bio website blog.mvct.com
location Canada
age 45
visits member for 1 year, 10 months
seen Jul 7 at 13:09

Professional Developer / SQL Server DBA

profile for Max Vernon on Stack Exchange, a network of free, community-driven Q&A sites

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

DBA.se all time rank

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


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.
Nov
13
awarded  Enthusiast
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
awarded  Citizen Patrol
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
answered How to find out Sql server instance name in TFS 2008?
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
7
asked Do large corporations block jQuery content on web pages?
Sep
4
revised What is the default RAID-50 stripe size on a Dell EqualLogic PS6510?
added 243 characters in body
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
revised Internet setup for my office
improved formatting and corrected grammar.
Sep
4
suggested suggested edit on Internet setup for my office
Sep
4
awarded  Commentator