A few days ago, Microsoft released Service Pack 1 (SP1) for SQL Server 2016. This release however, is not at all similar to older releases of SQL Server service packs, in a very pleasant manner. Breakthrough Changes in SQL Server 2016 SP1 In addition to cumulative patches, bug fixes,…
A long-awaited string function added to SQL Server 2016 is STRING_SPLIT. As the name implies, this function splits the given character expression using the separator set by user. Let’s see some examples of using the STRING_SPLIT function. —–Example #1—DECLARE @string AS VARCHAR(250);SET @string = ‘1-2-3-4-5-6-7-8-9-10’;SELECT ValueFROM STRING_SPLIT(@string, ‘,’);–Output: —–Example #2—CREATE…
A few days ago I published a 38-page technical paper titled “In-Memory OLTP Simulator: The Experiment“. In-Memory OLTP Simulator is a software tool that I developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server. This paper presents a…
Row-Level Security (RLS) is one of the top features in SQL Server 2016. With RLS you can control access to rows in a table based on the characteristics of the user executing a query. The access restriction logic is located in the database tier and access restrictions are always applied,…
TempDB system database plays a major role when it comes to performance in SQL Server. TempDB is available to all users connected to a SQL Server instance and it is used to hold local or global temporary tables, temporary stored procedures, table variables and cursors. Another example of when TempDB…
Temporal tables in SQL Server 2016 is a new type of user table. It was introduced in ISO/ANSI SQL 2011. Temporal tables keep a full history of data changes (based on UTC time) by using a pair of current-historical tables. These tables has the same structure. The period of validity…
JSON stands for JavaScript Object Notation and it is widely used for data representation in the data services world. With JSON support, you can format query results as JSON by adding the FOR JSON clause to a SELECT statement in SQL Server. Also, you can converts JSON data to rows…
SQL Server 2016, Azure SQL DB and related cloud technologies, are Microsoft’s implemented vision for a complete data platform that offers everything that has to do with data management, transformation, knowledge extraction from structured, semi-structured and unstructured data and beyond. At a recent community event, I talked about SQL Server…
Please read below for In-Memory OLTP Simulator Frequently Asked Questions (FAQ): What is In-Memory OLTP Simulator? In-Memory OLTP Simulator is third-party tool that allows the user to easily create and run scenarios with different workloads against the In-Memory OLTP Engine of SQL Server®. What is a Simulation Scenario? A simulation…