407 reputation
28
bio website straightpathsql.com
location New Hampshire
age 36
visits member for 5 years, 1 month
seen Jan 10 at 1:41

Mike is a partner, Database Wellness expert and coach with the SQL Server consultancy Linchpin People. He is an experienced SQL Server professional and has worked with every version of SQL Server since version 6.5. He has been in the role of DBA, Developer, Architect and Performance Lead but always leans on his DBA and performance tuning experience. He loves providing training and coaching to clients and colleagues and has been recognized as a SQL Server MVP by Microsoft for two years in a row. He speaks at national and regional conferences and SQL Server events on DBA, Performance Tuning and Professional Development topics and he blogs regularly on SQL Server topics.

Linchpin People Site and Blog


Nov
10
awarded  Yearling
Sep
30
awarded  Explainer
Dec
3
comment SQLOLEDB from sql2005 to sql2008?
Continue to receive?
Dec
2
awarded  Editor
Dec
2
revised SQLOLEDB from sql2005 to sql2008?
Added code comments and some clarifying text in question intro
Dec
1
awarded  Critic
Dec
1
awarded  Citizen Patrol
Dec
1
suggested approved edit on SQLOLEDB from sql2005 to sql2008?
Dec
1
answered SQLOLEDB from sql2005 to sql2008?
Nov
11
comment Error when connecting to Named Instance as a Linked Server
Pretty sure that's your issue. Sounds good, looking forward to results after restart.
Nov
9
comment Error when connecting to Named Instance as a Linked Server
Can you connect to the named instance via SSMS remotely from your laptop or another machine?
Nov
9
answered Error when connecting to Named Instance as a Linked Server
Nov
4
comment Error when connecting to Named Instance as a Linked Server
To clarify - You CAN connect locally through SSMS on the server itself, right? The issue is that you can't create a linked server on that server to an instance on the same server? Can you go the other direction with the linked server?
Oct
25
comment Storing important information for a company
I am pretty sure it does or other tools like it. I provided a link to check out for it above, answers all of those questions...
Oct
25
comment Storing important information for a company
You can store text in Password Vault also. Not just passwords.
Oct
25
comment SQL Server 2008 R2 50% Performance Drop after server repair?
+1 for a check of the bios and settings. What was the old processor? What is the new processor? How many?
Oct
25
answered SQL Server 2008 R2 50% Performance Drop after server repair?
Oct
25
answered Storing important information for a company
Oct
24
answered Scaling Out SQL Server 2008 R2
Oct
24
comment Scaling Out SQL Server 2008 R2
You also said "Scaling up won't be enough" - Can you just clarify that one. What kind of waits and challenges are you facing? I am really not trying to be difficult but I just want to understand your application better to help. I've helped a lot of my own clients with vendor apps that are built on SQL Express and don't perform. In each of the cases the issue was the resources allocated and/or the database code and design. I've had to scale out large SQL environments behind web sites, but never SQL Express based vendor apps. Always went with "scale up" or tuning/optimizing.