-
Process XML Files Easily Using .NET 6/7
By:
Paul Sheriff
Last updated: Thursday, November 30, 2023
Published in: CODE Magazine: 2023 - November/December
Paul shows you how storing data in XML files can save a lot of time and network traffic. Learn how to create XML documents in memory, and to save and load XML files from disk. You'll also see how to use LINQ to XML for processing XML nodes including sorting, filtering, and aggregation.
-
Create Your Own SQL Compare Utility Using GetSchema()
By:
Last updated: Friday, February 24, 2023
Published in: CODE Magazine: 2023 - March/April
Learn how to use the GetSchema() method on the DbConnection class to retrieve tables, views, columns, index, stored procedures, and more from any database system. Create an instance of the SqlConnection or OracleConnection, or your own provider's implementation of the DbConnection class, and pass a valid connection string to the constructor to use the GetSchema() method.
-
Introduction to Snowflake
By:
Rod Paddock
Last updated: Wednesday, November 22, 2023
Published in: CODE Magazine: 2023 - March/April
In this article, author Rod Paddock introduces Snowflake, a cloud-based SQL database that offers a range of capabilities for developers. Paddock discusses the features of Snowflake, such as its cloud-agnostic nature, support for querying JSON data, and secure data sharing capabilities. He explains how Snowflake's unique architecture allows for "infinite" computing through its warehouse concept and provides insights into using Snowsight, the web-based application for managing Snowflake infrastructure. Rod also discusses building a data loading pipeline, securing data with masking, and sharing data with other Snowflake users. He concludes by highlighting the power and user-friendly nature of Snowflake as a game-changing product.
-
Event Sourcing and CQRS with Marten
By:
Jeremy Miller
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2022 - September/October
After examining persisted system states in a relational database, Jeremy discovers that he needs to use the Marten library to provide robust support for Event Sourcing.
-
Putting Data Science into Power BI
By:
Helen Wall
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2022 - September/October
Power BI seems to have everything you need for data analytics. Helen shows you how to get the most out of it and how to make some cool charts, too.
-
Big Data and Machine Learning in .NET 5
By:
Jeremy Likness,
Bri Achtman
Last updated: Wednesday, August 31, 2022
Published in: CODE Focus Magazine: 2020 - Vol. 17 - Issue 1 - .NET 5.0
Learn about .NET for Spark and ML.NET to help .NET 5 applications better use big data and machine learning (ML). This article includes a code walkthrough.
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data, Part 2
By:
Kevin Goff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - September/October
Developers should know their data before they spend a lot of effort analyzing it. For example, at face value, you should know if your data is in the millions or billions, and know "that's what the data said" is not the right answer if the data is bizarre. This article in Kevin Goff's Stages of Data series using PowerBI introduces a new state profile page with ranking formulas, new trend-based measures, defining custom filter groups, and more.
-
Power Query: Excel’s Hidden Weapon
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - July/August
Helen talks about how to use Power Query, a tool that's part of Excel and Power BI that enables you to automate the ETL process of bringing data into Excel. Learn to create an elegant ETL process in Power Query to first bring in the data, then later refresh it with a single button
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - July/August
Kevin uses Power BI mapping to track a constantly changing array of data about the COVID-19 pandemic. Learn how pick the right data; it doesn't all come from just a few sources.
-
Azure Machine Learning Workspace and MLOps
By:
Sahil Malik
Last updated: Wednesday, March 17, 2021
Published in: CODE Magazine: 2019 - September/October
It’s when you’re working with lots of data that you start looking around for an easier way to keep track of it all. Machine learning and artificial intelligence seem like the obvious answers, and Sahil shows you why.
-
Stages of Data #1: A New Beginning
By:
Last updated: Tuesday, April 13, 2021
Published in: CODE Magazine: 2018 - November/December
Kevin leaves his SQL Server-focused Baker’s Dozen behind and launches into a new series looking at the various stages of data warehousing. His first installment includes a look at reporting and storage layers, handy tips, and dealing with the business side of development.
-
Refactoring a Reporting Services Report with Some SQL Magic
By:
Last updated: Monday, April 26, 2021
Published in: CODE Magazine: 2018 - May/June
The point of showing data in graphical form is to make things clear, right? Keven shows you how the best of intentions can go wrong and how to repair the damage.
-
Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 2 of 2)
By:
Last updated: Thursday, April 29, 2021
Published in: CODE Magazine: 2018 - March/April
Kevin shows us how to solve tangles in SQL Server, and in this article, he looks at some questions that have come up since his last article on ETL practices in Data Warehousing.
-
The Baker’s Dozen: 13 Tips for Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 1 of 2)
By:
Last updated: Wednesday, May 12, 2021
Published in: CODE Magazine: 2017 - September/October
In this first installment of his ETL articles, Kevin shows you what to do—and even what not to do—when designing your Data Warehouse.
-
Processing Large Datasets Using C# and SQL Server Table Data Types
By:
Last updated: Friday, May 28, 2021
Published in: CODE Magazine: 2017 - January/February
If you’ve got large datasets, you don’t want to slow the system down every time you save them to your SQL Server database. Rod shows you an uncomplicated way to keep your records zipping along.
-
Introduction to Data Science using Python
By:
Wei-Meng Lee
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2016 - November/December
If you’re curious about Data Science or Python—and if you’re interested in the Internet of Things, you should be—you’ll find this introduction both important and exciting. Wei-Meng makes it all clear for us by explaining the basics.
-
The Baker’s Dozen: 13 Great Things to Know About SQL Server 2016
By:
Last updated: Monday, June 7, 2021
Published in: CODE Magazine: 2016 - September/October
All eyes were on Microsoft when the latest version of SQL Server came out a couple of months ago. If you want to know what’s so great about it, you need to read Kevin’s handy summary.
-
SQL Server Reporting Services: Eight Power Tips
By:
Last updated: Wednesday, June 23, 2021
Published in: CODE Magazine: 2016 - May/June
SQL Server’s Reporting Services is still the best workhorse for getting data to your users. Kevin tells you how to take advantage of some of its more subtle points.
-
The Baker’s Dozen State of the Union: 13 Points on SQL Server Data Warehousing and Business Intelligence
By:
Last updated: Thursday, July 15, 2021
Published in: CODE Magazine: 2015 - May/June
Kevin takes a look at SQL Server “then and now,” and shows us just how important it is to understand the various tools involved in BI.
- Home
Articles filed in category 'Data Warehousing'