Hi friends! In previous posts, you’ve learned how to create databases in SQL Server, as well as, how to create and alter tables. In this post, you will learn how to easily create database views in SQL Server and see relevant examples. What is a Database View? A database view, is an entity, which in … Read more
Hi friends! In a previous article, we’ve talked about how you can create databases in SQL Server. In this article, we’ll talk about how you can create and alter tables in SQL Server databases. The basic syntax for creating SQL Server database tables The basic syntax, involves the CREATE TABLESQL statement. Creating a … Read more
In short tech how to, we show how you can easily can run the command prompt as administrator in Windows 10. Running the Command Prompt as Administrator So, the procedure for running the command prompt as administrator in Windows 10 is: Step 1 Within the Windows search box on the bottom left of … Read more
Via this how-to, you will learn how to easily change the time and date format in Windows 10. To this end, we will see a step by step example. Since there are multiple ways of navigating to the time and date settings in Windows 10, in this article, we will be showing the most common … Read more
In this short article, we will see, how you can easily change the screen resolution in Windows 10. Before jumping into the steps for changing the screen resolution in Windows 10, first let’s define what the term “screen resolution” means. What is screen resolution? Screen resolution, or display resolution, is the total number of pixels … Read more
In this article, we will be discussing about the benefits of using stored procedures in databases. Introduction In a previous article, we have discussed about stored procedures in the SQL Server data platform, and more specifically, we have you’ve learned: How to define a stored procedure in SQL Server Without any input parameters With input … Read more
In this tech how-to, we will see via different examples, how to check SQL Server version. Since there are many methods for checking the SQL Server version, in this how-to, we will see the most commonly-used methods. Method 1: Check SQL Server version using @@VERSION One of the most popular ways for checking SQL … Read more
In this short tip, we answer the question many users might have: How to Save a Microsoft Word Document as a PDF? Saving a Microsoft Word document to PDF, is a very easy process, that does not require any additional tools or plugins. So, in order to save your Word document as a PDF file, … Read more
In this short but useful how-to tip, we will see how you can easily find your Windows OS version and build number. Finding your Windows OS Version and Build – Method 1 (this PC) The first method for finding the version and build number, is to right-click on the “This PC” icon on your … Read more
This month’s tech tip is about Azure SQL Database and more specifically, about the different compatibility percentages, when migrating from on-premises to the Azure cloud. Tech Tip: When migrating your on-premises SQL Server databases to the Azure cloud platform, the available SQL Server deployment options have the following compatibility percentages with your on-premises databases … Read more