Consulting Pragmatic Works specializes in integrating the Microsoft platform with your company. We can help you fill the gaps in your project or deliver a complete solution. Database Administration and Tuning Our experienced consultants can help you with migrations, installations, proper configuration or troubleshooting an issue with the SQL Server platform. We are also proficient in building a highly available solution with Windows clustering (MSCS), database mirroring, replication or log shipping. If you have performance issues, we have years of experience in tuning methodologies to make your system and queries perform at their peak capacity through index, query and system tuning. Microsoft Business Intelligence Our consultants have years of experience with SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) and are involved in the product development cycle early in the beta cycles. We can help you build a highly scalable envrionment from the inception of the warehouse to loading it with data to creating a scorecard on the data. We have many industry leaders on staff to help you bring your solution to the next level. Training Pragmatic Works offers a wide array of specialized SQL Server classes taught by published authors and speakers. You will know that when you arrange a private class for your corporation that you're going to have a high-end teacher that has used the product before. Our trainers are required to spend at leaast half their time in the field working with the product on projects. For a full list of classes, you can visit our partner training center in Orlando , End to End Training. Mentoring Mentoring blends consulting and training together to help you learn how to use a technology or strategy well after the mentor leaves. Mentoring projects are usually shorter-term and are tied to a proof of concept. During this mentoring engagement, we will work directly with your staff teaching them a technology through the proof of concept to ensure that they will know how to accomplish the task in the long term. DTS Migration Over its 5 year lifespan, companies have accumulated sometimes thousands of SQL Server 2000 in their environments. With DTS soon to be removed from SQL Server, the conversion to SQL Server Integration Services (SSIS) can be overwhelming for companies. The built-in wizard to migrate DTS packages is approximately 40% successful and does not allow you to enjoy the benefits and best practices of SQL Server 2005 Integration Services (SSIS). Pragmatic Works will partner with your company to make your DTS migration project a success. We have a number of approaches based on how much experience and time you have to complete your project. We will help you formulate a low-risk plan to make your project a success by blending our unique experience with your team. End to End SSIS Training This four day class designed to help you understand all aspects of SSIS, the ETL tool of choice for SQL Server DBAs. Our experts all have real-world experience in the field and are all recognized experts in the field. We use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server subsystem. With the hands-on labs, you will learn how to create a SSIS package to load an OLTP or warehouse environment. You'll also learn how to make the package dynamic to where it will work and self-heal in the event of a failure. You can come to our training center ($2,400 per student) in Orlando or we can come to you. Outsourcing Outsourcing of your implementation for DTS package migration project is simple with Pragmatic Works. We have several levels of experienced consultants to make your migrations a simple process. Our consultants have experience in creating a reliable architecture delivering your packages with integrated dynamic, enterprise logging enabled with comprehensive configuration capabilities. The goal is to migrate your packages to an environment where there is no configuration required to migrate from development to production.