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 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
This month’s tech tip is about SQL Server and Azure SQL Database. Tech Tip: Among other, SQL Server (version 2016 and later) and Azure SQL Database support “Dynamic Data Masking”. This feature, allows the user to set SQL Server to dynamically mask sensitive data from unauthorized access, based on certain rules. Enroll to … Read more
This month’s tech tip is about SQL Server and Azure SQL Database. Tech Tip: Among other, SQL Server and Azure SQL Database support Transparent Data Encryption also known as TDE. TDE encrypts SQL Server data files, log files and backup files and it is transparent to the users that are authorized to access SQL … Read more
This article discusses whether it is possible to restore a database backup from SQL Server 2005 SP4 to SQL Server 2005 SP3 or not. If the database was in place when you patched SQL Server 2005 to SP4 then yes, you can backup the database and restore it on SQL Server 2005 SP3. If the … Read more