PITTSBURGH (April 4, 2019) — With the help of Data Warehouse Consultants, the Allegheny County Department of Human Services recently launched an updated QuickCount Tool application. QuickCount is an online, easy-to-use interface that allows journalists, policy researchers, grant writers, nonprofit leaders and community agencies to obtain counts of participants involved in the programs and services […]
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 […]
https://www.dwconsultants.com/wp-content/uploads/2018/06/text-x-preview-1.png128128Steve Shantzhttp://www.dwconsultants.com/wp-content/uploads/2013/12/data-warehouse-logo-2.02.pngSteve Shantz2018-06-25 10:51:232019-04-04 15:22:08Loading Flat Files into a Database with C#
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, […]
https://www.dwconsultants.com/wp-content/uploads/2017/11/hd_insight.png225225Mukesh Thangaduraihttp://www.dwconsultants.com/wp-content/uploads/2013/12/data-warehouse-logo-2.02.pngMukesh Thangadurai2017-11-09 15:09:472019-04-04 15:22:37Our Experience with Azure HD Insight
Data Warehouse Consultants Introduce Unique QuickCount Tool
/in Allegheny County, News /by Taylor CiccarelliPITTSBURGH (April 4, 2019) — With the help of Data Warehouse Consultants, the Allegheny County Department of Human Services recently launched an updated QuickCount Tool application. QuickCount is an online, easy-to-use interface that allows journalists, policy researchers, grant writers, nonprofit leaders and community agencies to obtain counts of participants involved in the programs and services […]
Loading Flat Files into a Database (Method Overview)
/in News /by Steve ShantzHere 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 […]
Loading Flat Files into a Database with C#
/in News /by Steve ShantzThis 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 […]
Prototype Review of Azure SQL Data Warehouse
/in News /by Mukesh ThangaduraiData 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 […]
Our Experience with Azure HD Insight
/in News /by Mukesh ThangaduraiData 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, […]