Check our Tip of the Week, which this week explains the Capital Expenditure (CapEx) vs. Operational Expenditure (OpEx) concepts. Tip of the Week #11 Two of the fundamental concepts you need to learn when getting started with Cloud Computing is Capital Expenditure (CapEx) and Operational Expenditure (OpEx). CapEx has to do with the money an … Read more…
Hi friends! In this article, we will be discussing about Azure Database for MySQL Firewall Rules and Connection Security. About Azure Database for MySQL Server Firewall Rules Firewall rules in Azure Database for MySQL, is a way of controlling who can be allowed network access to your online resources on Azure, such as your MySQL … Read more…
Check our Tip of the Week, about the “Tags” feature in Azure SQL Database. Tip of the Week #10 One of the available Azure SQL Database Server settings are “Tags”. Tags are name/value pairs that enable you to categorize resources and view consolidated billing by applying the same tag to multiple resources and resource groups. … Read more…
Hi friends! This week’s tip, is about how you can easily retrieve, SQL Server service account info, using T-SQL. Tip of the Week #9 An easy way to find the service accounts for the main SQL Server services such as Database Engine and SQL Server Agent, is to execute the below T-SQL statement within SSMS: … Read more…
In this article, we will be discussing about the three main categories of cloud services (IaaS, PaaS, SaaS) and see some examples. Which are the three main categories of cloud services? The three main categories of cloud services are: Infrastructure as a Service (IaaS) Platform as a Service (PaaS) Software as a Service (SaaS) Below, … Read more…
Hi friends! After a short break, our weekly tips are back! This week’s tip, is about Azure Database for MySQL, a great technology offering in the Azure cloud platform. Tip of the Week #8 From within the Azure Database for MySQL server’s Activity Log feature, you can view historical information about any actions taken … Read more…
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…