This short post, discusses about installing SSIS on a SQL Server Failover Cluster Instance and how you can resolve the error message: The instance selected for installation is already installed and clustered on computer [ComputerName]. To continue, select a different instance to cluster. Reproducing the Error Message If you have already deployed a SQL … Read more…
Hi friends. Here’s a quick tip on Windows Clustering and Windows Disk Management and specifically on how to handle the error message “The parameter is incorrect” when working with disks and mount points. Why you get the “Parameter is Incorrect” Error Message Most probably, under certain circumstances, you get the above error message when attempting … Read more…
This post explains the error message you might get in SQL Server: The OLE DB provider “SQLNCLI11” for linked server “[…]” supplied inconsistent metadata for a column. The column “[…]” (compile-time ordinal 1) of object “[query…]” was reported to have a Incomplete schema-error logic. You might get the above error message, when you are trying … Read more…
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 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…
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…
