At Data Warehouse Consultants we solve complex technical issues every day. Here are some technical tips.
Here we feature a few methods for loading files into an Oracle or SQL Server database. There are many methods for accomplishing this, but over the past few projects, and after implementing most of the methods discussed, I documented some of my experiences. Here I focus on developing an application or process to load data […]
This article features some methods that I have used to load data within a C# application. The methods discussed are an Insert Loop (with bind parameters), the DataAdapter.Update() method, and a custom method of passing the table to a stored procedure. For this article, a simple website demo was setup that accepted a 6-column CSV […]
Data Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings. The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure SQL Data Warehouse, which is Microsoft’s current cloud offering focusing on the data warehousing space. For more information on this prototype or similar work […]
Data Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings. The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure HD Insight product, which is Microsoft’s current Hadoop offering. For more information on this prototype or similar work we can do for your company, […]
The Cloud offers many advantages and many organizations are looking to utilize Cloud solutions. But how easy is it to move an existing Data Warehouse to Microsoft Azure or Amazon Web Services? To gain insight and better advise our clients, Data Warehouse Consultants has begun two research projects to identify the benefits and pitfalls of […]
We have been encountering a new issue with Microsoft Excel and one of our clients had it today. It took a little while to figure out, so we want to help out others in this situation. Issue – Excel External/Web Content is Blocked: In most of our interactive applications, we allow for exporting data (either to […]
Unix (all-caps UNIX for the trademark) is a family of multitasking, multiuser computer operating systems that derive from the original AT&T Unix, developed in the 1970s at the Bell Labs research center by Ken Thompson, Dennis Ritchie, and others. From the power user’s or programmer’s perspective, Unix systems are characterized by a modular design that […]