However, the database is so big that it almost doesn't fit on a CD-R, and we would only like to update a couple tables anyway. I did some googling and found the bcp command.

A limitation of the profiling tool is that source data must be stored within a SQL Server database. If you wish to profile data stored in flat files, for example, then you must first load that ...

Using the Copy-DBAAgentServer command, you can bring over everything in the SQL Server Agent, including jobs, notifications, operators and alerts. Log-ins work in the same easy manner.

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...

SQL Query Store is a new feature offered in SQL Server 2016 that allows DBAs to see which queries ran when, how often and with what performance results to optimize queries and query plan selection.