How to Connect to SQL Server from Visual C++

In this article, we are going to see, step by step, how we can connect to SQL Server from a Visual C++ program using an ODBC connection. Prior to start reading, if you are really interested in learning Programming, then you should definitely check my 6-hour online course, “The Philosophy and Fundamentals of Computer Programming“. … Read more…

Installing SSIS on a SQL Server Failover Cluster Instance

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…

How to Resolve “The Parameter is Incorrect” Error when Adding New Disk Mount Point

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…

The OLE DB provider “SQLNCLI11” for linked server “…” supplied inconsistent metadata for a column… – How to Resolve

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…

How to Resolve “Property SpaceAvailabable is not available for Database ‘[tempdb]'”

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…

There is no argument given that corresponds to the required formal parameter

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…

Essential SQL Server Administration Tips

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…

An error occurred for a dependency of the feature causing the setup process for the feature to fail (SQL Server 2019)

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…

How to Resolve: The description for Event ID 1 from source msodbcsql13 cannot be found.

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…

The Philosophy and Fundamentals of Computer Programming

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…