This short tip is about how to handle the following error message, in case you get it when you install SQL Server 2019 RTM: An error occurred for a dependency of the feature causing the setup process for the feature to fail. How to Resolve the Issue There several things you can try for resolving … Read more…
This quick tip, talks about creating Azure SQL Database logins and users after you have performed an initial setup of your Azure SQL Database server and defined the admin user. So, if for example, you would like to create a new SQL login/user with db_owner permissions on a database, you can do this by connecting … Read more…
Writing to a text file from a C++ Program is very easy. In this example, which is part of my online course on Udemy titled “The Philosophy and Fundamentals of Computer Programming“, I will show you step by step, how to write to a text file from a sample C++ program that generates an array … Read more…
This is a quick tip, on how to resolve the error message “The description for Event ID 1 from source msodbcsql13 cannot be found.” when trying to start SQL Server Agent. After you ensure that everything is OK with the service account running the SQL Server Agent service, and that the SQL Server service is … Read more…
Hi friends, in this post, I will be presenting my online course, titled “Introduction to Computer Programming for Beginners“. Below, you can find more information about the course, as well as links with special discounts for enrolling to the course. What is this Course All About? Programming is everywhere. In almost every aspect of … Read more…
Each SQL Server version has a specific native compatibility level, as a way to distinguish it from other SQL Server versions. The compatibility level is used internally in SQL Server for many operations. For example, if you try to restore a database backup taken on SQL Server 2017 with native compatibility level 140, to an … Read more…
In this article, we will be discussing about how to offline install SQL Server on Linux, and see a step-by-step live demonstration. Introduction Installing SQL Server on a Linux environment with Internet connection is a relatively straightforward process. However what about if you want to offline install SQL Server on Linux? In this post, we … Read more…
Sometimes, under certain circumstances, when trying to edit an existing or create a new maintenance plan in SQL Server, using SSMS, just when you try to save the maintenance plan, it might happen to get the error message “No Description Found“. How to Resolve the “No Description Found” Error There is a series of … Read more…
Hi friends, today, I’m proudly announcing the release of my new online course, titled “Introduction to Azure SQL Database for Beginners“. Below, you can learn more about the course, in terms of how it can help you, to easily get started with Azure SQL Database, both Platform as a Service (PaaS) and Infrastructure as a … Read more…
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…
Among the many great 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 demonstrating all these cool built-in … Read more…
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…
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…
Hi friends! 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…
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…