Frequently Asked Questions about SQL Server TDE

In an older article, we have discussed about Transparent Data Encryption (TDE) in SQL Server. In this article, we will be answering different frequently asked questions about SQL Server TDE.   What is SQL Server TDE? SQL Server TDE stands for Transparent Data Encryption and it is Microsoft’s technology, based on which SQL Server performs … Read more…

What is Microsoft’s Passwordless Option?

On September 15, 2021, Microsoft announced its passwordless technology. So, a logical question you might have, is what is Microsoft’s passwordless option and how can it help you?   The inconvenience of maintaining multiple passwords Let’s face it: nobody likes passwords! We need to manage so many passwords for just about anything! On the one … Read more…

Azure Database for MySQL Server Management Components

Hi there! In a previous article, we have discussed about the available MySQL deployment options in Azure. In this new article, we will be discussing about the available Azure Database for MySQL server management components.   Available Server Management Components for MySQL on the Azure Cloud Platform The server management components for MySQL server on the … Read more…

SQL Server replication requires the actual server name to make a connection to the server – How to Resolve it

When working with SQL Server replication and you try to add a new subscription under a local publication, under certain circumstances you might end up with the error message: Cannot connect to … SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name (Replication.Utilities).   … Read more…

Main Benefits of Using Azure Cloud Services

In this article, we will be discussing about the main benefits of using Azure cloud services.   Introduction Microsoft Azure cloud platform, among other, provides a rich set of services and resources, that can be used for building robust and highly available solutions and ecosystems. Even though all services are beneficial for the end user, … Read more…

The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered – How to Resolve it

In this article, we will be discussing about the error message [The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered] and how you can easily resolve it.   Importing Data from Excel to SQL Server via SSMS In most of the cases, you might get the [OLE DB Provider “Microsoft.ACE.OLEDB.12.0” has not been registered] error … Read more…

[Resolved] Operand type clash: int is incompatible with uniqueidentifier

When developing in SQL Server, under certain circumstances, you might get the error message: Operand type clash: int is incompatible with uniqueidentifier. In this article, we will be discussing about, why you got that message, what’s wrong in your T-SQL script and how to fix it.     About the above “Operand type clash: error … Read more…

Introduction to Azure Database for MySQL (Course Preview)

In this post, we are announcing the general availability of our online course: “Introduction to Azure Database for MySQL“. Note that the course is currently available on Udemy.   What is this course all about? As Cloud Computing is becoming the new norm of modern computing, new services are constantly being added in the cloud … Read more…

How to Resolve: The feature “Scale-out deployment” is not supported in this edition of Reporting Services

Under certain circumstances, when upgrading SQL Server Reporting Services Standard Edition, for example from SSRS 2012 or 2014 to SSRS 2017 or 2019, you might get the following error message when trying to start the Reporting Services service: “The feature “Scale-out deployment” is not supported in this edition of Reporting Services“. But first, let’s discuss … Read more…

How to Resolve: [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)

This article, provides useful troubleshooting tips, for the following error which you might get, under certain circumstances, when trying to connect to SQL Server from Python, using pyodbc: [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect). Prior to sharing our tips for troubleshooting the issue, let’s discuss … Read more…

Useful Python Programming Tips

In this post, I will be regularly posting useful Python programming tips. These tips will be organized in different categories, in order to make it easier to read it.   Hello World in Python The below command, prints a “Hello World” message from within a Python script: print(“Hello World from Python”)   Code Indentation in … Read more…

Working with Python on Windows and SQL Server Databases (Course Preview)

In this post, we are announcing the general availability of our online course: “Working with Python on Windows and SQL Server Databases“. Note that the course is currently available on Udemy.   What is this course all About? Python is a very popular programming language. Due to its simplified syntax, Programmers can develop a wide … Read more…