Check our collection of high-quality “Tip of the Week” articles.
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…
Check our Tip of the Week, where in this week, we discuss about SQL Server’s Surface Area. Tip of the Week #20 Surface Area is a term that is usually used to describe the surface area of attack in terms of computer security. In SQL Server, it refers to the number of SQL Server components … Read more…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…