Agile Implementation Strategy

March 30, 2017 Leave a comment

Categories: Agile Strategy

Hosting DBA service with SQL Server 2014

March 19, 2017 Leave a comment

The database industry has seen significant change over the last 5 years, from the introduction of new technologies like clustering, big data, and in-memory data platforms to the recent variants of popular open source SQL alternatives like Percona Server and MariaDB making their way into popular technology stacks. Even with these new technologies becoming increasingly common, many enterprises still trust their mission critical database operation to Microsoft SQL Server. Recently, Microsoft released its latest iteration of the technology, Microsoft SQL Server 2014, with notable advancements in performance including in-memory functionality and added security with high availability.

 

In-Memory OLTP

As one of the first to market with support for this new functionality, SmartERP is focused on increasing database performance by allowing some data to be queried and processed in RAM instead of on constrained disk resources. Previous technology forced users to load ALL information into RAM, making large data sets problematic. Now, database administrators can choose which data tables to process in-memory, allowing those operations to achieve maximum priority to valuable processing resources. By speeding up the overall performance of query operation across a database environment, users can effectively do more with less resources, which eliminates the need to scale into expensive hardware solutions. SmartERP teams are already helping users plan for their migration to SQL Server 2014 by evaluating target data sets to load into memory.

High Availability

While replication and failover have long been part of any core strategy for business continuity, achieving true high availability for a database environment has been problematic. Organizations often must decide what level of inconsistency between database environments is acceptable – hours or days? However, with a new functionality called AlwaysOn, and strong connections between multi-cloud datacenters including ones belonging to SmartERP and Microsoft Azure, users can now implement nearly 100 percent resilient database environments that protect from both database operational failure and datacenter availability. Even though SmartERP has an industry leading record in uptime and a 100 percent uptime SLA, we want our users to meet their unique availability requirements, which may include a highly available database environment. We can help you meet those requirements with a team of DBA’s that have successfully implemented high availability for many customers. Check out this report on our support of AlwaysOn for more information.

DBA Services

Recently, we shared with you the economic benefits of our DBA services offering, including a full time DBA available 24×7 at a fraction of the cost of an in-house resource. We have seen growing interest in our DBA coverage and released a tiered offering to accommodate a variety of supplemental DBA needs. We have also witnessed some organizations relying solely on our DBA services to ensure database functionality, while others have formed close partnerships with their core database team and our DBA service. This allows our customers to focus on important development and optimization efforts without the burden of maintaining and monitoring the health of the existing database. Moving between any database iteration requires some thought and planning. Our DBA team is helping customers understand the scope of work and code change required to not only migrate, but also utilize new functionality. Our partnership with Microsoft ensures that our DBA Services team is ready to address even the more challenging scenarios when switching.

Flexible Licensing

At SmartERP, customers can consume fully managed SQL application licensing along with support at a low monthly cost. This allows users to move in-between SQL versions and hardware profiles without needing to address their software license agreement. We want to make sure you always have the best combination of optimized hardware and SQL versioning to meet your objectives.

Hybrid Potential

Lastly, while many web applications are moving to the cloud, many database users still require the performance consistency and controls of a dedicated server. Often, users partnering with a single cloud or managed hosting provider will be forced to make sacrifices by either not moving applications and web assets to the cloud because of database restrictions or sacrificing database performance and reliability by trying to operate it in a utility cloud service. With a Managed Private Cloud powered by Microsoft Cloud Platform, and the built in Database-as-a-Service capability, customers can take advantage of a fully managed, physically isolated, private cloud environment that allows customers to programmatically spin up SQL Server 2014 databases on demand. Customers can also strengthen their high availability and disaster recovery capabilities by choosing from a number of available destinations, including Microsoft Azure, as a designated disaster recovery location.
SmartERP can bridge public and private clouds running SQL Server over a strong network connection. It allows users to leverage both cloud and dedicated server resources in a single environment. Dominoes UK spoke about their use of hybrid to serve web content via the cloud while still having a reliable dedicated database in dedicated hosting. You can read more about that here.

SmartERP DBA services professionals are ready to help you wrap your brain around the cool new features in Microsoft SQL Server 2014. If you want to know more, please download our whitepaper and visit go.SmartERP.com/SQL2014.

SQL Server DBA Support

March 10, 2017 Leave a comment

SQL Server DBA Support

 

  • Proactive Problem management
  • Predictive capacity analysis
  • Intuitive event and incident correlation

Apart from this our service catalogue comprise of regular DBA activities like Monitoring, Backups, Space Management, Resource Utilization, License Rationalization, patch management Database Vulnerability Assessment, Object Migration and other activities. Other activities include:

  • Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas
  • Testing of new releases and features for application, O/S and Database upgrade & Troubleshoot application performance & Optimize query& index performance.
  • Designed & Tested a Scale-Out Architecture using Replication, DTC / 2PC, Distributed Database  with Data & Middle Tier, Web & Client Tier  for SQL Server Databases to facilitate a High-Availability environment by creating Read-Only copies for Reporting Services & Read-Write Hot copies of critical Databases, for Hot Instant Disaster Recovery.
  • Enhanced performance, scalability and usability across multiple cores & support that efficiently scale computer, networking and storage in both physical and virtual environments.
  • Establishes and maintains policies, standard operating procedures, and associated documentation for user interaction with the database environment.
  • Support on-premises to Microsoft Azure IaaS , PaaS & amazon RDS, Hybrid Scenarios with SSIS, Stretch Database, PowerBI with on-premises data.

Revenue and Risk Reward Program:

 

  • SLAs based on Risk Reward –Example. Availability of 99.95%
  • 10% cost reduction year over year during contractual period
  • Technology Consumption Management to ensure customer uses licenses/servers to the minimal and reduce OPEX costs.

SmartERP SQL server Portfolio

SmartERP SQL Health Shop Clinic


By utilizing SmartERP’s foundational ITIL process and delivery methodology, our SQL DBA experts can apply their breadth of expertise to provide both proactive and reactive database support. Our proactive database support will ensure that your database environment receives the preventative care it requires for the future while also promising to have the availability to respond to your most critical needs with integrity.

SmartERP’s robust support service model encompasses a wide range of activities. Within our company’s best practices, our expert DBAs will provide routine tasks, such as patching, backups, configuration and installation. Other support tasks are tailored to each unique database environment. This includes customized deployment procedures, refresh methodologies, failover and replication routines that require focused attention beyond rudimentary knowledge application.

Irrespective of the SQL version that you are using, by choosing SmartERP SQL DBA Support, you can be rest assured that your database is in safe hands. We are running SQL health clinic where many options do exist in the market; the question still remains to which IT cardiologist you would want to trust for the maintenance of the heart of your enterprise. We would like to introduce  complete SQL packages solution with multi specialist clinic where each SQL disease will be treat as a proper diagnosis along with permanent solution. We have a very strong DBA and Development team also where people are very good in DBA, BI and reporting side which ensure that whenever client reach to us with SQL related task they will be great fair treatment.

The delivery design of SmartERP’s database support will never restrict your company’s ability to optimize your environment or ignore opportunities to improve current practices.

DTS Package migration steps from SQL 2000 to SQL2008

March 31, 2015 Leave a comment

  1. Run time support installation for DTS packages.
  2. Design time support installation for DTS packages.
  3. Configure SSMS for DTS packages.
  4. Migrate the DTS packages by using SSMS.These are all high level steps which includes below step by step activities.
  • Check the backward compatibilities and integration services are installed on target server or not.Check the integration service is there or not.
  • Run services.msc
  • If the above services are not installed, go to binaries location and run the Setup on SQL2008 instance on target server and go to the feature selection page.
  • Select both features in the installation wizard and proceed with installation.
  • Download the design time components from the below URL and install the same.
  • http://www.microsoft.com/en-us/download/details.aspx?id=11988
  • Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.
  • Download and install SQL upgrade advisor to analyze the existing packages for migration issues.
  • Start the migration package wizard from SSMS to do the DTS package migration.                 Upgrade Advisor: http://www.microsoft.com/en-in/download/details.aspx?id=11455
  • Design time Components: http://www.microsoft.com/en-us/download/details.aspx?id=11988
  • Required Software Download location:
Categories: SQL SSIS

DTS Package migration steps from SQL 2000 to SQL2008

March 31, 2015 Leave a comment

  1. Run time support installation for DTS packages.
  2. Design time support installation for DTS packages.
  3. Configure SSMS for DTS packages.
  4. Migrate the DTS packages by using SSMS.These are all high level steps which includes below step by step activities.
  • Check the backward compatibilities and integration services are installed on target server or not.Check the integration service is there or not.
  • Run services.msc
  • If the above services are not installed, go to binaries location and run the Setup on SQL2008 instance on target server and go to the feature selection page.
  • Select both features in the installation wizard and proceed with installation.
  • Download the design time components from the below URL and install the same.
  • http://www.microsoft.com/en-us/download/details.aspx?id=11988
  • Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.
  • Download and install SQL upgrade advisor to analyze the existing packages for migration issues.
  • Start the migration package wizard from SSMS to do the DTS package migration.                 Upgrade Advisor: http://www.microsoft.com/en-in/download/details.aspx?id=11455
  • Design time Components: http://www.microsoft.com/en-us/download/details.aspx?id=11988
  • Required Software Download location:
Categories: SQL SSIS