As a SQL Server DBA or developer here is what you should know about memory-optimized tables (in-memory tables):
Introduced in SQL Server 2014
Primary store is main memory, second copy maintained on...
2016-10-13
3 reads
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
296 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
225 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...
2016-10-12
5 reads
If you've ever designed a database you've most certainly run into the need for what we called history tables, those tables that stored the history of row changes (sometimes...
2016-10-11
6 reads
If you've ever designed a database you've most certainly run into the need for what we called history tables, those...
2016-10-11
428 reads
Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data Compare v7.0.0 – v9.0.0
Description: Using xSQL Schema Compare and xSQL Data...
2016-10-06
416 reads
Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data
Compare v7.0.0 – v9.0.0
Description: Using
xSQL Schema Compare and xSQL Data Compare to keep the tables of two databases
in sync...
2016-10-06
7 reads
Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0
Summary: When adding databases to the workspace both in xSQL Schema Compare...
2016-09-21
9 reads
Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0
Summary: When adding...
2016-09-21
328 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers