GitHub

generate-sql-script-replication-objects.md

[!INCLUDE SQL Server SQL MI] A replication script contains the [!INCLUDEtsql] system stored procedures necessary to implement the replication components scripted, such as a publication or subscription ...
GitHub

SQL Server script seeding for Entity Framework Core

Data seeding is an important step in development process as it provides data for basic functional testing during development. However, data seeding may be also an integral part of the deployment where ...
Microsoft

Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...
Visual Studio Magazine

Next-gen SQL Projects with Microsoft.Build.Sql

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...