Visual Studio Magazine

How to Query JSON Data with SQL Server 2016

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...
Ars Technica

SQL Server - migrating to a new server

My question is about migrating data from one server to the other. My inclination is to stop SQL Server services, copy the database and log files over to the new server, and then attach the database to ...
Ars Technica

SQL tools to copy data between environments?

I'm building out a new system with a database back-end that runs in multiple environments (DEV, INT, TST, PROD) and am looking for a tool to allow the DEV, INT and TST environments be updated with ...
CCM

SQL Server diagram export: to another database

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...