MSSQL

What is Row Level Security in SQL Server? Row-Level Security is a feature introduced in SQL Server 2016 that allows each user to see only …

You can find information about creating SQL Database in Azure in this article. If you are creating a Stretch Database, you must first create a …

In Azure, you can create a virtual machine to manage SQL Server databases. In this article, I will explain how to create this virtual machine …

What is Stretch Database? If you want to archive your old data to Azure, all you need is StretchDatabase. You can then query as you …

What is PolyBase? This article contains information about PolyBase in sql server. Use cases, installation steps,configuring polybase cluster. With PolyBase; We can bridge between SQL …

Tempdb is a very important system database for heavily used systems. If it is not configured correctly, it can cause serious performance problems in the …

With SQL Server 2016, we are now able to use parallelism in the query using INSERT INTO… SELECT with WITH (TABLOCK). In order for the …

What is Live Query Statistics Live Query Statistics is a feature that we can use with SQL Server 2016 Management Studio. But we can use …

What is a temporal table in SQL Server? We can store the history of inserts, updates and deletes by using temporal tables. Previously, we could …

We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. …