Hi friends! This article, discusses about the benefits of primary keys in database tables. A primary key is a special column (or set of combined columns) in a relational database table, that is used to uniquely identify each record. A database primary key cannot contain NULL values and each table can have only one primary … Read more
Hi friends! I would like to wish to you and your loved ones, Happy New Year 2022! Best wishes, for a healthy, creative new year! Best regards, Artemakis Read Also: Welcome to {essentialDevTips.com}! How to Write a “Hello World” App in Visual C++ How to Write a “Hello World” App in C# … Read more
This article, discusses about, how you can rebuild all indexes online for a SQL Server database and provides useful T-SQL scripts that can help you perform this task. The below script makes use of the undocumented SQL Server stored procedure “sp_MSforeachtable” and with the proper syntax, it rebuilds all SQL Server indexes online for all … Read more
Hi fellow developers! In this post, we will see step by step, how to write a “Hello World” app in C#. Introduction Visual Studio is an extremely powerful IDE for building many types of applications. In this dev tip, we are going to build a “Hello World” Windows forms application in C#. If you don’t … Read more
In this tip, we are going to build a “Hello World” console application in Visual C++. If you don’t already have Visual Studio, the you can download Visual Studio Community Edition which is free. Building the App in Visual Studio Ok, let’s build our Hello World app! After launching Visual Studio, we click on “File“, “New“, … Read more
Hello and welcome to {essentialDevTips.com}! At {essentialDevTips.com}, our main goal is to provide cutting-edge helpful software development tutorials that are easy to understand. My name is Artemakis Artemiou, I’m the founder of {essentialDevTips.com} and former Microsoft Data Platform MVP. I have been writing code since the ’90s, that’s about 30 years of working with a … Read more