A long-awaited string function added to SQL Server 2016 (and later) the is STRING_SPLIT function. Read on to better understand this cool function and see examples of how you can use it. What does the STRING_SPLIT Function in SQL Server do? As the name implies: this function splits the given character expression using the separator … Read more…
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 we developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server. What Does the Paper Discuss? This paper presents … Read more…
SQL Server Row Level Security (RLS) is one of the top new features shipped 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, … Read more…
When using In-Memory OLTP in SQL Server 2014, under certain conditions you might get the below error message: The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’ Symptoms One symptom due to the above issue, is that the transaction log of a memory-optimized table, might continue to grow, without being able to truncate … Read more…
Another year has passed…as always, full of everything! Events, articles, direct communication with you, my fellow SQL Server community members, via different online and offline channels, software and book releases and many other activities! Among my blog and journal articles, user group/conference events, tweets and software and book releases, I feel that two of my … Read more…
In this article, we will be discussing about the main TempDB enhancements in SQL Server 2016 (and later) installation process. About the SQL Server TempDB System Database 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 … Read more…
In this article, we will be discussing about Temporal Tables in SQL Server and Azure SQL Database. Temporal tables in SQL Server 2016 and later as well as in Azure SQL Database is a new type of user table which was was introduced in ISO/ANSI SQL 2011. Read on to learn more temporal tables and see … Read more…
In this article, we will discussing about built-in JSON support in SQL Server and Azure SQL Database. What is JSON? JSON stands for JavaScript Object Notation and it is widely used for data representation in the data services world. With built-In JSON support in SQL Server and Azure SQL Database, you can format query … Read more…
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. Read on, to learn more about SQL Server 2016 Top Features. SQL Server 2016 … Read more…
Earlier this month I have released the third and last book of my “ebook series” on SQL Server administration, development and performance. Through this three-book series, I share my experiences with SQL Server on the below areas: Tuning Administration Development and Data Access Feel free to check it out! SQL Server eBook Releases: Title: … Read more…
Yesterday, I released my third book on SQL Server, titled ‘Developing with SQL Server’ and it is dedicated to SQL Server development but don’t worry, there are more books to come! 🙂 This book is for database developers and architects who develop SQL Server databases and related database processes. The book features tens of articles … Read more…
Question: What I’m I doing wrong and I’m getting the following error message when trying to list my database’s tables? “The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.” Here’s the screenshot also: Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that -most probably- (hey, you never … Read more…
In earlier articles I talked about the In-Memory OLTP Engine in SQL Server. Even though it is very powerful, it had some limitations (note the past tense of “have” here as I have some good news! 🙂 For example, you couldn’t use subqueries in the clauses of a SELECT statement inside a natively-compiled stored procedure, … Read more…
In this article, I am publishing a stored procedure (DBStats) I have recently written and which given a database name as an input parameter it returns the below basic information: TotalTables TotalViews TotalSPs TotalFunctions TotalDMLTriggers TotalDBSize (MB) LogSize (MB) List of all tables with their number of columns Sample Output of DBStats The below … Read more…
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 scenario is a set of table and stored procedure … Read more…