SQL Server 2016 Temporal Table Query Plan Behaviour
For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Introduction to Row Level Security in SQL 2016
In SQL 2016 several new security features gets introduced which will help users to protect their data in many ways. New security feature Row Level Security (RLS) which implements the security inside the database itself, not at application level.
Stairway to DLM Dashboard Level 2: Setting up DLM Dashboard
Learn how to install and configure your initial DLM Dashboard instance.
Losing Rows
MongoDB can lose some rows in queries run very close together. Is that bad? Steve Jones thinks so, though this doesn't mean you shouldn't use MongoDB or any other NoSQL database.
Different Options for Importing Data into SQL Server
Moving data into SQL Server is something that most DBAs or Developers are faced with probably on a daily basis. In this article, Greg Robidoux explores the various options for doing so.
Calculating MySQL Database, Table, and Column Sizes
Rob Gravelle demonstrates a sure-fire way to calculate how much disk space your MySQL data entities are taking up.
SQL Server 2014 Service Pack 2 is Available
SP2 for SQL Server 2014 is now out. Check out the build list.
Importing Blobs from a MySQL Database and Export Them
Using the power of SSIS and BCP to import MySQL Data and extract files from a BLOB(Varbinary) column.
New Mobile Attack Vectors
With many mobile phones containing malware, Steve Jones notes this could be a problem for data professionals.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers