Working with Entity Framework 6.3 and .NET Core 3.0

In May 2019, Microsoft announced that the first preview of Entity Framework 6.3 was available on NuGet. Entity Framework 6.3 will be the first version of Entity Framework 6 that can run on .NET Core and therefore, work cross-platform. This development, will make it easier to migrate existing applications that use Entity Framework 6 to .NET Core 3.0. … Read more…

Featured Online Course – Entity Framework: Getting Started (Complete Beginners Guide)

Hi folks! I’m pleased to announce that my new online course Entity Framework: Getting Started (Complete Beginners Guide) is now available! This is a comprehensive course on Entity Framework and SQL Server data access. Read on the learn more about the course!   What is this Course all About? Entity Framework is an Object-Relational Mapper … Read more…

The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group

So, you have a clustered SQL Server instance (FCI), you try to move (fail over) the entire role to another node of the cluster and you get the below error message: Error Code: 0x80071398 The operation failed because either the specified cluster node is not the owner of the group, or the node is not … Read more…

Infographic: An Introduction to Entity Framework

Hi folks! In this post, I’m sharing with you a useful infographic I created for my Online Course “Entity Framework: Getting Started (Complete Beginners Guide)“. This infographic, provides a quick overview of the Entity Framework in .NET, it describes what it is, how it works and what are its workflows that allow you to build … Read more…

How to Enable SSL Certificate-Based Encryption on a SQL Server Failover Cluster

Hi folks. Because enabling an SSL certificate on a SQL Server Failover Cluster, thus enabling encryption for your data in-motion, is a little bit tricky, I decided to write this article in order to help you out a bit, since in the past, I encountered the same difficulties. So, please read on to learn more … Read more…

[DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error – How to Resolve

This article, suggests a way of resolving the below error message, when you are trying to access SQL Server using “Microsoft OLE DB Provider for SQL Server” and TLS 1.0: [DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error Prior to start writing this article, I was thinking of using a title like “How to still use TLS … Read more…

How to Resolve: Bulk load data conversion error (type mismatch or invalid character for the specified codepage)…

This post helps you how to resolve the BULK INSERT-related error in SQL Server: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row… , column …    Reproducing the issue with an example Consider an example where you have a text file which you want to import in … Read more…

Introducing My Remote Connections Manager

Yesterday, we proudly announced the release of our brand new software tool “My Remote Connections Manager“. In this short post, we are introducing My Remote Connections Manager by describing its main features and explaining how it can help you in your daily IT tasks.   What is My Remote Connections Manager? My Remote Connections Manager, … Read more…