The container behind a memory-optimized filegroup is a folder, and a restore must place it. Here is the error you get when you forget, and the fix.
Building Demo Data With GENERATE_SERIES
Build demo data with GENERATE_SERIES, weighted categories, customer skew, random amounts, and validation that preserves repeatable tests.
Database Scoped Configurations Changed From Their Defaults
One column in sys.database_scoped_configurations finds every setting that differs from its default. I show how to use it, and where it goes blind.
Install the WideWorldImporters Sample Database
To install the WideWorldImporters sample database, restore its backup file in SSMS and check the files and the row counts. This post explains the Full and Standard versions, the disk space you need, the permission trap, and three queries that prove the install worked.
Test Data That Looks Like Production
Test data that looks like production matches distributions, relationships, and volume without copying sensitive values into development.
Sample Databases for Practicing Performance Tuning
Use sample databases for practicing performance tuning by checking data volume and skew, then enlarging the right tables carefully.
SQL SERVER – AdventureWorks for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0
Microsoft released AdventureWorks for SQL Server 2012 RC0. Here is the download link, plus why this sample database belongs on a development box only.