Check our Tip of the Week, which this week discusses about the main data structures in C#. Tip of the Week #15 Data Structures, are data organization and storage formats, that are used in different programming languages for storing data, define attributes between data, and apply different operations on this data. The main data structures … Read more…
Hi friends! In this article, we will be answering different frequently asked questions about SQL Server In-Memory OLTP. We will begin with the basics and then move to more advanced-level questions. What is SQL Server In-Memory OLTP? SQL Server In-Memory OLTP, is a powerful engine, seamlessly integrated into the SQL Server Engine (version 2014 and … Read more…
Check our Tip of the Week, which this week discusses about the Azure availability sets and availability zones and explains their differences. Tip of the Week #14 An availability set, is always within the same data center. They can provide resiliency against potential machine failures and they are based on the principle where you set … Read more…
Check our Tip of the Week, which this week discusses about the availability of the In-Memory OLTP feature in different SQL Server versions and editions. Tip of the Week #13 In-Memory OLTP was initially released with SQL Server 2014 and was supported in the Enterprise, Developer and Evaluation editions. Since SQL Server 2016 SP1, In-Memory … Read more…
Hi friends! In this post, which is related to SQL Server failover clustering, we will talk about how you can resolve the issue of not being able to add a node to a Server failover cluster, due to the fact that one of the service accounts (i.e. SQL Server or SQL Server Agent, or both) … Read more…
Check our Tip of the Week, which this week discusses about the available data service offerings on Azure and provides relevant examples. Tip of the Week #12 On the Azure cloud, there many types of data offering platforms and services. There are RDBMS platforms for dealing with relational data, Document databases for dealing with document-based … Read more…
Hi friends, in this post, we will discuss about how you can fix the issue, where SQL Server Agent might not be showing up in a SQL Server Failover Cluster Instance (FCI). SQL Server Agent not showing in Failover Cluster If you have a SQL Server failover cluster, and you cannot see SQL Server Agent … Read more…
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…