Article Category: SQL Server 2016

Create Your Own SQL Compare Utility Using GetSchema()

By: Paul Sheriff

Last updated: Wednesday, January 8, 2025

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

By: Julie Lerman

Last updated: Wednesday, January 8, 2025

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's article.
The Rich Set of Data Annotation and Validation Attributes in .NET

By: Paul Sheriff

Last updated: Wednesday, January 8, 2025

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

By: Julie Lerman

Last updated: Friday, January 31, 2025

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

By: Paul Sheriff

Last updated: Friday, January 31, 2025

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

By: Kevin Goff

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: Kevin Goff

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: Kevin Goff

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

By: Kevin Goff

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

By: Kevin Goff

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)

By: Kevin Goff

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

By: Kevin Goff

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

By: Rod Paddock

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

By: Mike Yeager

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

By: Kevin Goff

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.

Articles filed in category 'SQL Server 2016'