Best practices for moving SQL Server to AWS: Amazon EC2 and RDS
26 Jul 2018

One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormous database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. Their overall goal was to move all of their applications out of their datacenter and over to Amazon Web Services through a lift-and-shift process. Watch the following video to discover how we approached this project. This blog post documents the best practices for moving SQL Server to AWS, specifically the Amazon EC2 and ...

Power BI dashboard
Out of the Ring: Building a One-Day Power BI Dashboard that crushed Sumo Logic
25 Jul 2018

One of our customers, a major software provider in construction, agriculture, and geospatial industries, has one of the leading solutions for building design and building information modeling (BIM). Just think about the complexity of designing a building and the complexities of designing, fabricating, and installing air ducts, plumbing, electrical wiring, etc. In order to improve the software for their customers, their software product that we’ll call “BIM-APP” tracks all the user interactions and any system errors to log files. The development team for BIM-APP can then use the data from the log files to prioritize bug fixes...

Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
17 Jul 2018

So Long, Microsoft SQL Server 2008 I think that you’re supposed to know when it’s time to say goodbye. – Judy Sheindlin We get it. You’ve been running your SQL Server 2008 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business while keeping your data safe and you really can’t ask for a better show from your database software. Unfortunately, it’s now reached the end of its support life, and that means you’re about to have a range of new problems and issues with it. When Microsoft decides to finally pull the plug on SQL Server 2008 Support in July 2019, th...