Among the many cool things in SQL Server, a very significant one is the fact that SQL Server provides many built-in tools and mechanisms that allow you to import and export data easily. One day while working with SQL Server, I thought to myself “why not creating an online course…
Hi folks! I’m pleased to announce that my new online course Entity Framework: Getting Started (Ultimate 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…
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,…
Hi folks! In this post, I’m sharing with you a useful infographic I created for my Online Course “Entity Framework: Getting Started (Ultimate 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…
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…
Hi folks! I’m proudly announcing the general availability of my new online course titled: SQL Server 2019 – What’s New! What will i learn in this course? In this course, you can learn in an interactive and efficient way, about all the major new features and enhancements in SQL…
![[DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error – How to Resolve](https://www.sqlnethub.com/wp-content/uploads/2019/02/connectionopen-secdoclienthandshake-ssl-security-error-sqlnethub-article-230x160.jpg "[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…
There is so many people searching the web every on how they can get started with SQL Server! They read blogs, tutorials, how-to’s, watch videos and more. However, besides all that, which are very useful, I felt the need to create a structured online course, that will help people all…
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…
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…
Let’s say you have a C# (or VB.NET) project with namespace “MyProject” and you are trying to serialize a class named “MyClass” and you get the error message: There was an error reflecting type ‘MyProject.MyClass’. The first thing to check, is that the class which you want to serialize (that…
Microsoft Azure has a ton of features and resources to use, which enable you to do just about anything from the computational aspect. However, since you pay for the usage of all these resources, you need to have an efficient cost estimation and monitoring policy in place, in order not…
Enabling auditing in Azure SQL Database is a very good idea, since it allows you get alerts on a variety of actions and behaviors. Since data is the most valuable asset in any organization, it is always a good idea, if not a necessity, not only having your database servers…
Azure Data Lake Analytics, is a powerful on-demand analytics job service on Microsoft Azure. By reading this article, you can learn Azure Data Analytics by Example. The Example Since this is an introductory article on Azure Data Lake Analytics, the example that will be presented, will be a simple one…
We continue our article series dedicated Microsoft Azure. In previous articles, we’ve talked about Azure SQL Database, SQL Server on Azure VMs, Azure Advisor, etc. In this article, we will talk about what Azure Cosmos DB is, as well as see a simple step by step example on how to…
