SQL Migrations or Upgrades Services in Sacramento

The key to successful SQL Server Upgrade and Migration projects is the proper prep work. This part of the work will probably take from 90 to 95% of your time. Here is a partial list of items we do during Sacramento SQL Server upgrades and migrations - just to get your creative SQL juices going:

  1. Planning
  2. Analyzing of current production environment

    Agreeing on deadlines

    How long is the allowed down time window for SQL Server Migration cut over

    How Disaster Recovery site will be handled

    Analyzing of current production environment

    Agreeing on deadlines

    How long is the allowed down time window for SQL Server Migration cut over

    How Disaster Recovery site will be handled

    Ordering new hardware for SQL Servers

  3. New SQL Server setup
  4. Migrating all components from old/current production
  5. Testing
  6. Setting up new environment and making sure all components work

    Capturing old/current production workload and rerunning it in new environment

    Analysis errors and issues

    Analyzing performance differences on old vs. new

    Addressing slowness and other issues

  7. Coordinating with the rest of the team involved
  8. Cut over
  9. Post cut over troubleshooting, monitoring and fixes

As you can see, there is a lot going on during any SQL Server Migration or Upgrade. Depending on your size, you may want to have a project manager assigned. If you are small, no need. If larger, it will help a lot. As SQL Server DBA can go get programmers to do things. And if you make your SQL DBA resource do it - let’s just say, you won’t be in his phone favorites list for long.

When you need to migrate or upgrade Sacramento SQL Server, here are a few important things to think about:

  1. Decide if you want one to one migration, or if you want a new environment setup using all the best practices. The vast majority of upgrade/migration project s we have done go with the best practices method. And so far, it has been the right choice every time. We wouldn't let you go down the wrong route, don't worry.
  2. Do not cut preparation work short. Successful prep equals successful SQL migration or upgrade.
  3. How much downtime can you expect during SQL Server migration/upgrade? This is important to figure out at the start as this will drive the HOW part and your SQL DBA will choose appropriate method based on those parameters.
  4. What date migration will happen? Often dates change as you go, because another team can't deliver on time. But make sure when migration falls on major holidays - everyone who is a key person is available.
  5. When migrating SQL Server to cloud providers such as Amazon AWS EC2 or Microsoft Azure or any other cloud, test your disk performance. And be prepared to get really disappointed at sad cloud disk performance. If you were used to 1000MB/s or more in your on-premise SQL Server, cloud drives won't even come close (unless you have Department of Defense budget). There are ways to tweak it, but be prepared as it means extra work.
  6. When migrating SQL Server to, or from, a physical server to a virtual (some call it P2V SQL migration, physical to virtual or P-2-V), you should definitely use SQL consultants or DBA who have done this before. Ideally - they have done a variety of migrations/upgrades multiple times. Here are a few questions you can ask:
  7. How many complex SQL Server migration and upgrade projects have the service providers conducted successfully in the last 12-24 months?

    How fast were they when it was necessary to migrate SQL in short notice?

    What is the worst unplanned issue you ran into during your past SQL migrations or upgrade?

    Have you bumped into any issues which turned out to be "unique", and how did they get solved?

    Oh...and most importantly - were you the lead SQL DBA on this project, or was there someone else? Enough said...

  8. Figure out what to do about your disaster recovery site. Usually not a problem, but some companies have SLAs they have to meet, and SQL outage in DR site is a problem. So, you want to figure out how to minimize dramatic issues.
  9. Think through a roll-back scenario. It can happen. Just do it. Its better to think through with everyone involved now, rather than when everyone is exhausted at 4AM in the morning.
  10. Write down all the steps. And who will be doing what. And how long it will or should take. You want a large Excel or Project Plan with all the steps. Even the smallest. Believe us, a small number of items will simply blow you away. When you are done, and somewhere half way through you will be filling out our contact us form thanking us for this suggestion. You are welcome.

So now that you have a good start for migrating or upgrading your SQL Server database which resides in beautiful Sacramento. And you can handle any SQL migration, physical to virtual (P2V or P-2-V), SQL migration to the cloud or to VMWare.

And in case you need help with this - it would really make our day, if you called us! We can make a big difference in your SQL migration. No doubt!

Our offer is simple. Make your SQL Server issue someone else's problem.

We take care of the complex SQL Support issues, projects, migrations, and other consulting all the time, on on-going basis for past 20 years and have been pretty successful at it.

TESTIMONIALS

Significant Performance Improvement in minutes

In just a few minutes, Mark was able to find significant performance improvement opportunities in my database. These improvements were in areas I hadn’t even considered. Mark came up with many ideas; just the top 2 to 3 were enough to give us a significant performance boost. Mark has extensive knowledge when it comes to SQL Server. I can’t imagine there is anything he does not know. We plan to continue to work with him on a regular basis and continue to enjoy the benefits of his knowledge.

Kess EburuFounder and Director, GoodsExpress.com

Rare… Penetrating Knowledge of SQL

What a rare, great feeling it is to know when you hand off a project to someone, you can sit back and simply expect the best possible outcome. Mark's cool confidence and eagerness to deliver results are surpassed only by his deep penetrating knowledge of SQL. Whether it's design, development, optimization, or recovery, Mark is a SQL Gem.

David LernerPresident, Lerner Solutions

Complex and heavy 5,000+ concurrent connection databases need tuning, indexes, best practices, up-time, and smooth performance over all

Mark is an expert in large scale MS SQL Database environments which exceed 5,000+ concurrent connections. He has mastered the understanding of complex, heavy load TSQL transactions. When tuning, database structure, indexes, stored procedure, best practices, up-time, and smooth performance are all important, Mark is the type of DBA who truly knows how to keep these high standards. If you are growing, your feature sets are centered around MS SQL, then developers will benefit greatly from Mark's time to more efficiently write code. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA with the kind of skill set Mark has proven time and time again.

Tim JanssenApplication Manager, Service King

With little notice, Mark was able to find and fix a number of different SQL misconfigurations and wasteful practices. After a weekend of work, the customer realized a 60% decrease in CPU utilization as a direct result of Mark's work.

On an urgent SQL issue, Mark did a great job. Our customer moved their SQL environment from a rack solution with Fiber SAN to the Azure cloud. Doing this exposed all of the wasteful IO practices they had in their SQL environment. With little notice, Mark was able to find and fix a number of different SQL misconfigurations and wasteful practices. After a weekend of work, the customer realized a 60% decrease in CPU utilization as a direct result of Mark's work.

Jason MilgramAzure Practice Director, Champion Solutions Group, AllAware.com

Quickly identified and fixed SQL performance issues we had struggled with for weeks

I highly recommend Mark Varnas as a SQL Server DBA. Mark worked for us on a project for several months. Upon kicking off the project, Mark was able to quickly identify and fix several SQL performance issues we had been struggling to trace for several weeks. Additionally, he made several other recommendations and configuration changes that had a significant positive impact on database performance. I will absolutely use Mark again in the future, and would recommend him to anyone looking for a strong SQL DBA.

Nick KellandVice President of Ops & IT , SJV & Associates

My site is flying now!

After SQL Database query tuning - My site is flying now! I have already have hired him three times. I am very happy I found him!

Emil KadlecOwner, Fantasy Sports Publications, Inc.

Played a significant role in developing our next generation technology blueprint

Mark is an excellent SQL Server DBA with strong analytical skills and a passion for learning new technology. He worked on my team at Nuance Communications for over a year and was not only a strong individual contributor, but also a great team player and project lead. He played a significant role in developing our next generation technology blueprint and was project lead for our database monitoring initiative. Mark would be a strong addition to any database organization.

Daniel DonahueManager, Database Administration

The right expertise when it's time sensitive

When we were faced with a major crisis that was time sensitive and needed the right expertise, Mark stepped in. In no time he found the cause of the problem and prepared a plan that got us back operating at 100% efficiency. Throughout the project he was always available and felt like a member of our team. Thank you Mark!

Radu Butarascu.NET Software Engineer, SurferNETWORK, LLC

Yielded some very impressive results

The breadth and depth of knowledge of the Microsoft SQL Database platform and ancillary technology stack that Mark brought, has already yielded some very impressive results from both a physical and logical architecture perspective.

Preferred to stay anonymous

Top database architect instrumental in optimizing Amazon cloud SQL Instances

Mark is one of the top database architects I have worked with. Mark has been instrumental in the installation, configuration, and optimization of our SQL Server instances which are hosted through Amazon AWS. Mark's always pleasant to work with, and eager to assist his teammates. I hope to work with Mark in the future, and highly recommend him for senior level opportunities.

Sean FitzgeraldDatabase Engineer, Kabbage, Inc

Highly regarded SQL database expertise

Mark proved to be a highly capable and productive resource for a valuable SolTech client. He provided complete end-to-end evaluation on database design, development and performance capacity and successfully executed those recommendations. Mark's SQL database expertise is highly regarded; looking forward to partnering with Mark again in the future.

Heather LinnTalent Acquisition & Account Management Specialist, SolTech, Inc.

Expert SQL Server knowledge willing to go an extra mile

Working with Mark Varnas at Nuance Communications has been a pleasure. Mark is a great team player, has expert knowledge of SQL Server database administration, and is always willing to go an extra mile to get the project done.

J Daniel GonzalezSr. Database Administrator, Nuance Communications

Proved invaluable on numerous occasions

Outstanding database administrator. Mark brings a broad range of experience and practical knowledge to his roles in supporting development practices and implementing database solutions. I've found him to be an intelligent, thoughtful and talented professional. Mark's expertise in SQL Server has proved invaluable on numerous occasions, particularly when dealing with customer issues requiring not only immediate assistance, but also strong analytical and problem solving skills. I recommend Mark highly to any corporation looking for an outstanding database administrator.

John Alexander LopezSenior Manager, Research and Development

Designed Clustering and Disaster Recovery solution, optimized TSQL code, immediately fixed SQL performance, setup monitoring, troubleshot server issues beyond the scope of SQL

[Mark Varnas] was involved in large SQL server projects. He worked on designing of Microsoft SQL Server Clustering and Disaster Recovery Real-Time solution, optimizing existing stored procedures and immediately fixing critical SQL Server performance bugs. He took on the responsibility to setup monitoring for all our servers with a completely new tool. As a senior DBA, he managed multiple SQL servers and could technically and quickly troubleshoot server issues, often beyond the scope of SQL issues. We had his support and utmost dedication on every critical incident we came through

Sanjay KondaSenior DBA, Nuance Communications

Put my mind at ease

It has been a great pleasure working with Mark. From the get-go I could tell he knew what he was talking about, and he put my mind at ease. We will be using him going forward for everything database related. I would highly recommend him.

Mike KennedyFounder and Developer, Quicket.co.za

Solved my problem - Will be hiring again

Mark was able to remotely log in and solve the problem I had within the 24 hour window. I will be hiring Mark again for future support.

John B Berkeley Lights, Inc.

Whole experience was excellent from start to finish.

SQL Server Replication - expert and professional assistance. My whole experience was excellent from start to finish. Red9 was willing to accept a job a bit outside of normal; I was really looking for was someone to provide some expert advice to a novice SQL Server admin. I needed some pointed training in replication of best practices and performance tuning. I understand that teaching is quite a different skill set than actually performing the tasks yourself, so Red9's ability to convey his points clearly and tailor them to my level of understanding was impressive. Red9 was also responsive to my request for a follow-up, and did a very good job communicating when setting up meeting times. I would not hesitate to recommend Red9 to anyone who has a need for expert and professional assistance with SQL Server. My whole experience was excellent from start to finish.

Jamey SaundersSystem Engineer, Innovatum, Inc.

Stellar performance, attention to detail incredible, and very dependable. Mark consistently performs at a very high level

MSSQL 2012 DB maintenance plans and optimizations. Stellar performance as always. Mark's attention to detail is incredible, and he is very dependable and consistently performs at a very high level.

Rex Klein Barryhund Administrators, Inc.

The Best

For MSSQL 2012 DB maintenance plans and optimizations, Mark is again the best SQL Server consultant… And I have worked with many.

Preferred to stay anonymous

As good as it gets.

I will say it again. If you are lucky enough to have Mark bid on your project, hire him. He is as good as it gets.

Rex Klein Barryhund Administrators, Inc.

If you experiencing SQL issues – definitely recommended Red9

Immediate Repair - Server Off Line: Red9.com was extremely responsive and took the time to explain things to me on a level I could understand. I would definitely recommend him for others experiencing issues with SQL.

Connor L ConnorNeoRoofing

Will definitely rehire again

Very experienced. Great to work with. Will definitely rehire again for other jobs.

Preferred to stay anonymous

Very pleased with the SQL Server 2012 install/configuration

Mark was very knowledgeable, professional and courteous. He was also very accessible which made for a quick resolution. I was very pleased with the work, and would certainly recommend his services.

Geoffrey CelharDirector of Analytics, Poplicus

Very helpful and attentive.

Awesome contractor. Was very helpful and attentive.

Mike Doughty TheKnowledgeGym.com

Quick Resolution! - Server delay issue

Mark did a great job! Very knowledgeable in SQL and was also quick! I was in need of a good SQL database person and he was great!

Emil KadlecOwner, Fantasy Sports Publications, Inc.

Stored Procedure to Update RGB table value

Very good work and quick to respond. Hope to use again in the future.

Rowdy M SportApparel

Completed everything in a shorter time than expected

Very knowledgeable and easy to work with. He was able to solve issues that others weren't, advised better options for my business needs based on his experience with larger systems, and completed everything in a shorter time than expected.

Mark FoxPresident, Solel Software

Could not say enough positive things about his level of skill and with intricate attention to detail

Resource was expert, accurate, extremely helpful, and could not say enough positive things about his level of skill and ability to understand the issues at hand and explain both at a high level and with intricate attention to detail. Will definitely hire again.

Joshua AbbeySolution Architect/Principal, BackupSecurity.Net

Outstanding job

SQL database integration changes. Mark, again, did an outstanding job - was quick, very knowledgeable and professional. This was a second hire, and there will be more!

Emil KadlecOwner, Fantasy Sports Publications, Inc.

Win Server 2008R blowing 53 error suddenly

Mark is UNBELIEVABLE! We had a server connection issue plaguing us for over 3 weeks. We had 2 so-called professionals trying to figure out what the problem was, and after 3 weeks they were still scratching their heads! I hired Mark to investigate this issue. Within ONE HOUR Mark honed-in on the actual problem; advised us on what needed to be done with the Server Hosting company, and then within 30 minutes we finally had access to the crucial data we needed to run our business! Anyone looking for a TRUE professional regarding SQL or SQL Server, don't even bother looking elsewhere; Mark is the exactly the guy you want and need!

Joseph RiceSenior American Assistance Benefit Assoc

Next steps

Contact Us!

Call Us: 1-877-891-1870

Or complete the form below and we’ll call you.

*Required field.

Thank you for contacting us! Someone will get back to you in one business day.

Guarantee Certificate

Guarantee Certificate