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
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?