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…
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…
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…
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…
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…
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…
In this article, we will be discussing about the available MySQL deployment options in Azure. A few words about Azure Database for MySQL Azure Database for MySQL, is the technology offering of the well-known MySQL DBMS, on the Azure platform. Via this offering, you can set a MySQL server on Azure and after performing … Read more…
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…
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…
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…
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…
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…
In this article, we are going to see, step by step, via an example, how we can connect to SQL Server from a Python program using an ODBC connection and the pyodbc module. For this article’s example, I will be using Visual Studio Code, with the MS Python extension. Prior to start reading the article, … Read more…
Check our Tip of the Week, about the SQL Server offerings in Azure. Tip of the Week #7 The Available 3 SQL Server offerings in Azure are: SQL Server on Virtual Machines (*IaaS) Azure SQL Database (Logical Server – *PaaS) Azure SQL Database Managed Instance (*PaaS) *IaaS: Infrastructure as a Service *PaaS: Platform … Read more…
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…
