-
Create Your Own SQL Compare Utility Using GetSchema()
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.
-
Some Overlooked EF Core 7 Changes and Improvements
Last updated: Friday, February 24, 2023
Published in: CODE Magazine: 2023 - March/April
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 article.
-
The Rich Set of Data Annotation and Validation Attributes in .NET
Last updated: Wednesday, January 18, 2023
Published in: CODE Magazine: 2023 - January/February
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.
-
Tapping into EF Core’s Pipeline
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - March/April
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
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - January/February
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.
-
Stages of Data #1: A New Beginning
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
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)
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.
-
A SQL Programming Puzzle: You Never Stop Learning
Last updated: Thursday, May 6, 2021
Published in: CODE Magazine: 2018 - January/February
Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.
-
SQL Server Reporting Services: Eight Power Tips
Last updated: Friday, May 7, 2021
Published in: CODE Magazine: 2017 - November/December
Kevin looks at his favorite reporting tool (SSRS) and shows you how to maximize your users’ experience.
-
The Baker’s Dozen: 13 Tips for Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 1 of 2)
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.
-
SQL Server Reporting Services: Seven Power Tips
Last updated: Wednesday, May 19, 2021
Published in: CODE Magazine: 2017 - May/June
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
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.
-
Azure Skyline: Using WebJobs for Event-Driven, Asynchronous Services
Last updated: Friday, June 4, 2021
Published in: CODE Magazine: 2016 - November/December
If your call to services times out after four minutes, you can have a problem if the process needed to retrieve the data or a fire-and-forget operation takes longer than that. What if the user makes a request and then wanders away from the computer? Mike solves it for you, with WebJobs in Azure Skyline.
-
The Baker’s Dozen: 13 Great Things to Know About SQL Server 2016
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.