CODE Magazine / Articles
Database
Articles filed under Database
Articles
Showing 1–32 of 32
-
Stages of Data: The DNA of a Database Developer, Part 1
Updated
In this article, Kevin Goff discusses various skills and concepts that are important for database developers, especially those looking to prepare for an employment interview. He emphasizes the importance of understanding SQL and database fundamentals, such as indexes and different types of joins. He also highlights the significance of knowing about data profiling, isolation levels, and slowly-changing dimensions in data warehousing. He also encourages experimentation and hands-on practice with tools like PowerShell and SQL Server Reporting Services.
-
Using DuckDB for Data Analytics
Updated
In this article by Wei-Meng Lee, the author introduces DuckDB, a Relational Database Management System (RDBMS) that supports Structured Query Language (SQL) and is designed for data analytics. Unlike traditional database systems, DuckDB does not require installation and can run queries directly on Pandas data. The article provides examples and demonstrations of how to use DuckDB for data analytics tasks, including loading datasets, querying data using SQL, and performing analytics on the data. The author also discusses the recently added support for JSON ingestion in DuckDB. Overall, the article highlights the convenience and efficiency of using DuckDB for data analytics tasks.
-
Create Your Own SQL Compare Utility Using GetSchema()
Updated
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
Updated
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.
-
Some Overlooked EF Core 7 Changes and Improvements
Updated
Great updates for EF Core 7 include explicit methods FromSqlRaw and FromSqlInterpolated. The SqlQuery method lets you pass in a raw SQL query to get scalar data directly from the database. And many more cool features. Read about them in Julie's article.
-
The Rich Set of Data Annotation and Validation Attributes in .NET
Paul teachs how to use many of the data annotations available in .NET; likely the ones you will use most often. Plus he shows you how to build custom validation attributes using the [CustomValidation] attribute. Finally, learn to localize error messages using resource files.
-
Event Sourcing and CQRS with Marten
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
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.
-
Fast Application Persistence with Marten
Updated
You don’t want to wait—and you don’t want your users to wait—while your application completely rebuilds itself for a simple query. Jeffrey shows you how Marten can store whole documents as a single element in your database and deliver the whole thing in one quick gesture.
-
Data Structures and Algorithms
Sahil collects his favorite tools and tells you why they should be your favorites too.
-
Can You Keep a Secret? Azure Can!
Updated
Learn how to leverage Microsoft Identity via Azure Active Directory (AAD) to secure a Web application. Julie shows you how to store a database’s connection string along with its elements in Azure Key Vault.
-
Tapping into EF Core’s Pipeline
Updated
Julie describes new EF Core 5 metadata features and how to use them, including ToQueryString, DbCloggerCategory, DbContext.SavingChanges, DbContext.SavedChanges, DbContext.SaveChangesFailed, Dotnet-counters, ChangeTracker.DebugView and Model.DebugView.
-
Calling Stored Procedures with the Entity Framework in .NET 5
Paul shows you how to avoid the frustration of having to determine a stored procedure’s function before you call it by using Entity Framework in .NET 5. Learn how to make calls to stored procedures using Entity Framework in .NET 5.x.
-
EF Core 5: Building on the Foundation
Julie’s pretty excited about the new features in EF Core 5. You will be too when you read about the bugs fixed, over 200 new features (including many-to-many support and the ability to filter when eager loading with the Include method) and minor enhancements and support for previous versions.
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data, Part 2
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
Updated
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
Updated
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.
-
Discovering AWS for .NET Developers
Updated
Learn a bit about how Amazon Web Services (AWS) supports .NET platforms including hosting ASP.NET Core apps.
-
Entity Framework Core 3.0: A Foundation for the Future
The latest release of Entity Framework gets it geared up for some big future changes. Julie shows you that the changes are nothing to sneeze at.
-
Synchronizing Databases Using Microsoft Sync Framework
If you’ve got multiple data stores, you have to keep them synced or you’ve got trouble on your hands. Joydip makes it look easy using Sync Framework.
-
Stages of Data #1: A New Beginning
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.
-
Entity Framework Core 2.1: Heck Yes, It’s Production Ready!
Updated
With this release, EF Core has really matured. Julie takes you on a tour and points out some of the highlights of this labor-simplifying tool.
-
Refactoring a Reporting Services Report with Some SQL Magic
Updated
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)
Updated
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.
-
A SQL Programming Puzzle: You Never Stop Learning
Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.
-
The Baker’s Dozen: 13 Tips for Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 1 of 2)
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.
-
Azure Skyline: Data in Cloud Applications
Updated
Mike looks at the technology that allows multiple teams to connect and scale their data despite disparate data storage methods.
-
SQL Server Reporting Services: Seven Power Tips
Updated
You already know that SQL Server’s Reporting Services tools are useful. Kevin shows you some nifty work-arounds and extra-credit tricks that will make your reports sing.
-
Processing Large Datasets Using C# and SQL Server Table Data Types
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.
-
The Baker’s Dozen: 13 Great Things to Know About SQL Server 2016
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.
-
The Baker’s Dozen: 13- SQL Server Interview Questions
Kevin uses his experience on both sides of the interview table to help you wow at your next interview. Not only that, but you’ll probably pick up a few pointers, too!
-
The Baker’s Dozen: 13 Miscellaneous Transact-SQL Tips
Whether you’re new to T-SQL or not, you’re sure to find something interesting among Kevin’s tips for using it, no matter which version of SQL Server you’re using.