CODE Magazine / Articles
SQL Server 2016
Articles filed under SQL Server 2016
Articles
Showing 1–15 of 15
-
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.
-
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.
-
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.
-
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.
-
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.
-
SQL Server Reporting Services: Eight Power Tips
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)
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
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.
-
Azure Skyline: Using WebJobs for Event-Driven, Asynchronous Services
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
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.