I’m pleased to announce the availability of my new online course, titled “A Guide on How to Start and Monetize a Successful Blog“. Read on, to learn more about the course! Why Have I Created this Course? You start a blog, when you have something to share with the world. A blog gives you … Read more…
Under certain circumstances, when working in SQL Server Management Studio, you might get the error message “Property SpaceAvailabable is not available for Database ‘[tempdb]’“. Why I got this message? Most of the times, you might get the above message because something else happened prior to the action that triggered the error message. For example, … Read more…
Hi friends all around the world! Another year has gone by, incredibly fast, filled with many challenges, lots of creativity and much more! In a few hours, we are about to enter not only year 2020, but a whole new decade! I would like to personally thank you for choosing SQLNetHub as your source of … Read more…
When working with Inheritance in C#, under certain circumstances, you might get an error message similar to this: There is no argument given that corresponds to the required formal parameter. Don’t worry, the above error can be easily resolved. Let’s see a full example, by first reproducing the error. Reproducing the Error Message Consider … Read more…
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 to the best possible level … Read more…
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 with SQL Server 2017, Shared … Read more…
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 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…
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 our lives, we interact with … 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…
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 3.1) on Ubuntu Linux 19.04. … 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…
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…
