MICROSOFT SQL SERVER

Your SQL Server databases store and retrieve the lifeblood of your business – data. nFolks provides expert consulting services to organizations of all sizes for mission-critical Microsoft SQL Server installations.

TYPICAL CHALLENGES THAT WE SEE

Microsoft SQL Server provides a great experience using default installation parameters and cloud deployments with a variety of vendors. Over the years, we’ve worked with thousands of databases at customer sites around the world.

In many cases, these databases may not have the full attention of the DBA team, if a team even exists.

Here are some of the common challenges we see with Microsoft SQL Server deployments.

DATABASE SERVER LICENSES OPTIMIZATION

Database servers were provisioned for a larger than needed workload, resulting in higher than necessary licensing costs.
We’ve developed a Data Optimized Management solution that monitors your SQL Server workloads over a period of time. We use the data to determine how you can consolidate multiple databases onto a single SQL Server instance to dramatically lower your SQL Server licensing costs.

LEVERAGING BEST PRACTICES

Best practices in security, high availability, disaster recovery, auditing, infrastructure, and performance are often overlooked.
nFolks has a platform called DBMsys that collects server and database configuration and layout information. DBMsys then processes the data using our own algorithms to produce a map of best practices and reports. We will then propose solutions to the various issues discovered based on criticality. The same engine can be used to perform compliance checks for ISO or another standard.

UPGRADING OUTDATED SQL SERVER VERSIONS

Customers running unsupported versions of SQL Server run the risk of not conforming to data governance policies for their solutions. Don’t be faced with having to upgrade hundreds of databases without any idea where to start.

MIGRATING FROM ANOTHER DATABASE PLATFORM

Customers looking to migrate from other database platforms like Oracle and SAP ASE in order to save licensing costs and take advantage of the advanced features of SQL Server are not sure where to start.
nFolks is the original creator of the SQL Server Migration Assistant and has developed a unique 12 step migration methodology. This methodology ensures complete application capability and conformance with your organization’s service level agreements while also minimizing overall migration risks.

RUNNING SQL SERVER 2017 ON LINUX

Customers running Linux have been stuck with open-source databases like MySQL and PostgreSQL for years and are looking for a platform that can grow for their on-premises, cloud, and hybrid solutions.
nFolks was an early adopter of SQL Server 2017 on Linux and is ready to help you integrate SQL Server for your DevOps needs like running SQL Server in Linux Docker Containers. Whether you use GetLab, Visual Studio Team Services, Jenkins, or BuildBot. nFolks can help you with adding SQL Server schema and data into your Continuous Integration (CI) and Continuous Deployment (CD) pipelines.

GETTING STARTED

We have a variety of entry-level offers to help you get the most out of Microsoft SQL Server running either on-premises bare metal, private cloud, Microsoft Azure, AWS EC2 or RDS, and Google Cloud Platform.

If you are looking to better understand your SQL Server modernization roadmap, we recommend a Future-State Architectural Design Engagement. In some cases, you might qualify for co-investment funding by Microsoft to get started with SQL Server 2017 and Microsoft Azure.

  • Data Management Optimization (DMO)
  • Future-State Architectural Design
  • SQL Server Migration Assistant Support
  • SQL Server Health Check
  • SSDPS — Data Platform Modernization
  • SSDPS — Deploy Modern Business Intelligence