Tip of the Week No.21 – Intelligent Performance Features for Azure Database for MySQL

Hi friends! Check our Tip of the Week, where in this week, we discuss about the Intelligent Performance Features for Azure Database for MySQL. Tip of the Week #21 The two main intelligent performance features for Azure Database for MySQL are Query Performance Insight and Performance Recommendations. With Query Performance Insight, you can get quick … Read more…

Tip of the Week No.19 – What is the Database First Workflow in Entity Framework?

Check our Tip of the Week, where this week, we discuss about the Database First workflow in Entity Framework. Tip of the Week #19 Based on the Database First workflow in Entity Framework, you create an Entity Data Model (EDM) by reverse-engineering an existing database. The workflow is: You first create a new .NET application … Read more…

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…

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…

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…

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…

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…

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…

Tip of the Week No.8 – Activity Log in Azure Database for MySQL

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…

Tip of the Week No.7 – SQL Server Offerings in Azure

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…