How to Create Databases in SQL Server

Technology articles, eBooks and courses - SQL Server - Databases - Azure - Python - Programming - TechHowTos

In this post, we will see how to easily create databases in SQL Server. To this end, we will see a relevant example along with a short video.   Connecting to SQL Server with SQL Server Management Studio (SSMS) The first step, prior to creating the database, is to connect to SQL Server, in our … Read more

How to Change the Screen Resolution in Windows 10

Windows 10 Articles and How Tos on TechHowTos.com

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

Benefits of Using Stored Procedures in Databases

Technology articles, eBooks and courses - SQL Server - Databases - Azure - Python - Programming - TechHowTos

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

What are SQL Server Stored Procedures?

What are SQL Server Stored Procedures - Article on TechHowTos

In this article, you will learn what are SQL Server stored procedures, how you can define them, as well as how you can execute them.   About SQL Server Stored Procedures A SQL Server stored procedure, is a batch of T-SQL statements, stored as a logical unit (programmability object) that has a name and can … Read more

How to Check SQL Server Version

Technology articles, eBooks and courses - TechHowTos

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

Differences Between Batch and Streaming Data

Technology articles, eBooks and courses - TechHowTos

In this article, we will be discussing about the batch and streaming data, what they are and which are their main differences.   What is Batch Data and Batch Processing? Batch data, is a term used to characterize large data sets with millions of records stored in files, records, etc. Batch data is processed by … Read more