Tip of the Week No.18 – Benefits of Using Database Stored Procedures

Check our Tip of the Week, where in this week, we discuss about the benefits of using database stored procedures. Tip of the Week #18 Using stored procedures in your database processes, can be very beneficial, not only for performance, but also for security and code reuse. Below, we list some of the main benefits, … Read more…

Tip of the Week No.17 – Modern Servicing Model for SQL Server 2017 and Later

Check our Tip of the Week, where in this week, we discuss about the modern servicing model for SQL Server 2017 and later. Tip of the Week #17 Starting with SQL Server 2017, the servicing model for SQL Server has changed. One of the major changes, is that Microsoft releases a series of Cumulative Updates … Read more…

How to Build a Simple Image Viewer with .NET WinForms and C# in Visual Studio

Hi friends! In this post, which is actually a 30-min video guide, we will see together, step-by-step, how you can easily build a simple image viewer with .NET WinForms and C# in Visual Studio. Our Simple Image Viewer App’s Functionality The functionality of the simple image viewer app we will be developing in Visual Studio, … Read more…

Tip of the Week No.16 – Available Visual Studio Editions

Check our Tip of the Week, which this week discusses about the available Visual Studio editions and discuss about their main differences. Tip of the Week #16 There are 3 Visual Studio editions. There are: Community Edition (free) In comparison with the other editions, the Community Edition of Visual Studio lacks some features, mainly about: … Read more…

Tip of the Week No.15 – Main Data Structures in C#

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…

Frequently Asked Questions About SQL Server In-Memory OLTP

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…

Tip of the Week No.14 – Azure Availability Sets and Availability Zones

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…

Tip of the Week No.13- SQL Server Support for In-Memory OLTP

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…

Issue Adding Node to a SQL Server Failover Cluster – Greyed Out Service Account – How to Resolve

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…

Tip of the Week No.12 – Data Service Offerings on Azure

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…

How to Fix SQL Server Agent Not Showing in a Failover Cluster

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…

Tip of the Week No.11 – Capital Expenditure (CapEx) vs. Operational Expenditure (OpEx)

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…

Azure Database for MySQL Firewall Rules and Connection Security

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…

Tip of the Week No.10 – The Tags Feature in Azure SQL Database Settings

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…

Tip of the Week No.9 – SQL Server Service Account Info using T-SQL

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…