How to fix SQL Server deadlocks with monitoring
Learn about deadlocks and how you might better troubleshoot the issues involved.
2016-04-12
5,177 reads
Additional Articles
The 2015/2016 Simple-Talk Awards: Winners Announced
The 2015/16 Simple-Talk Awards have concluded, the votes have been counted and recounted, and the winners have now been announced.
2016-04-12
2,372 reads
Getting Started with Temporal Table in SQL Server 2016 – Part 1
With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.
2016-04-11
4,139 reads
The Comeback of Migrations-Based Deployments
With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which are normally called ‘migrations-based approaches’, have more discipline around them. In this article, Redgate Product Manager Elizabeth Ayer covers ‘migrations’, and shows some of the benefits that have come with new tooling which is specifically designed to assist the change script processes.
2016-04-08
3,078 reads
Exploring SQL Server 2016 Dynamic Data Masking – Part Two - Masking and Exporting Data in Existing Tables
Dynamic Data Masking allows you to obscure your confidential data column values at the database engine level for both new and existing SQL Server data. Being able to alter the definition of an existing column to add a masking rule makes it very simple to obscure your existing column values without even changing your application code.
2016-04-07
4,873 reads
Performance Surprises and Assumptions: STRING_SPLIT
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. In this article, Aaron Bertrand compares its performance to existing methods.
2016-04-06
4,076 reads
The 2015/2016 Simple-Talk Awards
Once more Simple-Talk invites its readers to vote on the top nominations for the Simple-Talk Awards. Find out who or what has been nominated for each of this year's nine categories, and cast your vote to decide the winners - voting closes tomorrow!
2016-04-05
2,523 reads
Bad Cardinality Estimates from SSMS Plans – Redux
Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
2016-04-04
2,780 reads
Relational Algebra and its implications for NoSQL databases
With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists.
2016-04-01
3,673 reads
Creating a Date Dimension in a Tabular Model
As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.
2016-03-31
4,032 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers