SQL Server is one of the world’s leading data platforms. It is a mature platform, full of features that enable you to store, organize, retrieve and transform your data into useful business insights and knowledge. Like in all Database Management Systems, in order for your SQL Server instances to operate…
A few days ago I was searching within the SQL Server 2017 Feature Pack for Shared Management Objets (SMO). I first checked SQL Server 2017 Feature Pack, but I could not find SMO there. With a bit more searching, I found the official MS Docs article, which explains that beginning…
This short tip is about how to handle the following error message, in case you get it when you install SQL Server 2019 CTP or RC: An error occurred for a dependency of the feature causing the setup process for the feature to fail. How to Resolve the Issue What…
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…
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++…
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…
Recently, I have released my new online course “The Philosophy and Fundamentals of Computer Programming“. 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…
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…
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 will go through a video tutorial I created, in order to offline install SQL Server 2019 (currently CTP…
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…
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…
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…
