Choosing a Data Warehouse can be a daunting task, particularly if you’re not a technical person. It’s also a hugely important part of building a Business Intelligence Infrastructure. There are a lot of things to consider and sometimes it can feel like there’s no clear right answer. So if you’re finding yourself overwhelmed, check out...Continue reading
Category: Database Optimization
4 Things to Consider When Building a New BI Solution
Whether you’re a new business, a business new to Business Intelligence software or a business looking to upgrade its current system, there are a lot of options available these days. That’s because more and more businesses have begun to recognize the benefits of these softwares and services. But with so many options to choose from,...Continue reading
How to create Stored Procedures with Filters – Dynamic Search in MS SQL Server Instance
When we were in need to upgrade one of our client’s application code, we decided to filter the data in the database instead of through our application code. The logic behind the idea is that the database engine will do a better job at finding the most efficient way of completing the task than the...Continue reading
How to Change Inline SQL Statements Into Stored Procedures
From time to time, you may consider rewriting your application. Maybe your application has bugs. Maybe it doesn’t scale well or the framework is no longer maintained or fully supported. Or maybe the code is just ugly. Whatever the reason, a rewrite gives you an opportunity to make improvements and lay the groundwork for future...Continue reading
How to limit a database size on SQL Server
In an ideal world, we would not need to focus on the size of a database, but in most cases, we need to consider limiting our database size’s. If such considerations are not made, databases can grow faster than we expect and cause a whole slew of problems—architecture, availability, maintenance, performance tuning, just to name...Continue reading