T-SQL

Create a SQL Server view with encryption

How to create a SQL Server view with the encryption option? The WITH ENCRYPTION option allows you to hide the view code. Here is an example of code in T-SQL language to create a view with the WITH ENCRYPTION option. Create a SQL Server view with the encryption option First, here is the original tutorial with the script for creating the sales view used

T-SQL

Manage SQL Server tables

How to manage SQL Server tables? Here is a list of syntaxes for SQL Server tables. SQL tables in general are the most central type of object that exists in a database. As a file is the basic building block of any operating system. Keep this as a bookmark for creating a table easily. Manage SQL Server tables with T-SQL scripts Here is how

SQL Server DBA

Create SQL Server user with SSMS and set up access rights

How to create a new SQL Server user with SQL Server Management Studio (SSMS)? This SQL Server administration tutorial explains how to create a SQL Server user login with SSMS, used to connect to the databases of an instance. The user login can have a Windows security or the SQL Server security. Security management in SQL Server in general and in SQL databases is

T-SQL

Create a SQL Server index

Create an index in SQL Server to improve the performance of queries on tables and in clustered views. Two types of indexes exists, the clustered and the nonclustered one. To create a non-clustered index, use this example and adapt it to the project requirements. Indexes are the first recommended step to performance optimization in SQL Server. Create a SQL Server non clustered index on

T-SQL

Manage SQL Server user defined functions

How to manage SQL Server user defined functions ? SQL Server user-defined functions are very useful when starting T-SQL development. You need to use them very often so you have to learn the right syntaxes and avoid errors. At the beginning it can be tricky and frustrating because it’s binary, it work or don’t work, programming T-SQL functions is an exact science. There is