Hi there! I’m proudly announcing the general availability of my new online course titled: “SQL Server 2019 – What’s New (New and Enhanced Features)“! What will I learn in this course? In this course, you can learn in an interactive and efficient way, about all the major new features and enhancements in SQL Server … Read more…
This article, suggests a way of resolving the below error message, when you are trying to access SQL Server using “Microsoft OLE DB Provider for SQL Server” and TLS 1.0: [DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error Prior to start writing this article, I was thinking of using a title like “How to still use TLS … Read more…
There is so many people searching the web every on how they can get started with SQL Server! They read blogs, tutorials, how-to’s, watch videos and more. However, besides all that, which are very useful, I felt the need to create a structured online course, that will help people all over the world, to easily … Read more…
This post helps you how to resolve the BULK INSERT-related error in SQL Server: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row… , column … Reproducing the issue with an example Consider an example where you have a text file which you want to import in … Read more…
Yesterday, we proudly announced the release of our brand new software tool “My Remote Connections Manager“. In this short post, we are introducing My Remote Connections Manager by describing its main features and explaining how it can help you in your daily IT tasks. What is My Remote Connections Manager? My Remote Connections Manager, … Read more…
Let’s say you have a C# (or VB.NET) project with namespace “MyProject” and you are trying to serialize a class named “MyClass” and you get the error message: There was an error reflecting type ‘MyProject.MyClass’. The first thing to check, is that the class which you want to serialize (that save it to disk), contains … Read more…
In this article, we will be discussing about Azure Resource Cost Estimation and Management. Introduction to Azure Cost Estimation and Analysis Microsoft Azure has a ton of features and resources to use, which enable you to do just about anything from the computational aspect. However, since you pay for the usage of all these … Read more…
Enabling auditing in Azure SQL Database is a very good idea, since it allows you get alerts on a variety of actions and behaviors. Since data is the most valuable asset in any organization, it is always a good idea, if not a necessity, not only having your database servers and instances secured, but also … Read more…
Azure Data Lake Analytics, is a powerful on-demand analytics job service on Microsoft Azure. By reading this article, you can learn Azure Data Analytics by Example. The Example Since this is an introductory article on Azure Data Lake Analytics, the example that will be presented, will be a simple one just to showcase the technology. … Read more…
We continue our article series dedicated Microsoft Azure. In previous articles, we’ve talked about Azure SQL Database, SQL Server on Azure VMs, Azure Advisor, etc. In this article, we will talk about what Azure Cosmos DB is, as well as see a simple step by step example on how to enable it and access it … Read more…
In previous articles, we’ve talked about how you can create your first database in Azure SQL Database, how you can create an Azure SQL Server virtual machine, as well as how to backup a SQL Server database from on-premises to Azure Storage. In this article, we will discuss about what is Azure Advisor and what … Read more…
In Microsoft Azure, there are two main options for SQL Server services. The first option is Azure SQL Database (PaaS). The second option in SQL Server on Azure (laaS). In a previous article, I explained how you can create a SQL Server instance and database on Azure SQL Database. In this article, we are going … Read more…
In a previous article, we discussed how you can create your first database on Azure SQL Database. In this article, we are going to see, how to backup a SQL Server database from on-premises to Azure blob storage. Moreover, we will see how we can restore a database on-premises, based on a backup file store … Read more…
In this article, we will be discussing about what’s new in SQL Server 2019, in terms of new features and enhancements. In September 2018, during the MS Ignite Conference, Microsoft announced the Community Technology Preview of SQL Server 2019 (CTP 2.0). This is an exciting new version with a plethora of new features, as well … Read more…
In some cases where you might try to launch SQL Server Configuration Manager, you might get the error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] … Read more…