To encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key). So if you don’t have a Database Master Key defined you need to create one.
To encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key). So if you don’t have a Database Master Key defined you need to create one.
Dedicated Administrative Connection: How to Enable the DAC for Remote Connections and Clusters EXEC sp_configure ‘remote admin connections’, 1; GO RECONFIGURE GO
Dedicated Administrative Connection: How to Enable the DAC for Remote Connections and Clusters EXEC sp_configure ‘remote admin connections’, 1; GO RECONFIGURE GO
On 16th Nov 2016, Microsoft announced the support for ‘Consistent Programming Surface Area’ across all editions of SQL Server with few exceptions. Please refer to the https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released. The key value proposition is that it allows customers to use the same code base independent of the editions in SQL Server.
On 16th Nov 2016, Microsoft announced the support for ‘Consistent Programming Surface Area’ across all editions of SQL Server with few exceptions. Please refer to the https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released. The key value proposition is that it allows customers to use the same code base independent of the editions in SQL Server.
Since MSSQL 2008, we can use SPARSE columns to reduce table size, in case we have frequent NULL or 0 values.Sparse columns are not counted in the max column per table limit (1024).(I would rather check that data model, it is not usual to have more than 80 columns in a single table) see Code
A partir de la versión 2016, MS SQL integra el versionado (historial) de datos. ver también en sqltips
from a command prompt (cmd) cd «C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn» bcp “Person.Address” out c:\data\Address.txt -S “127.0.0.1” -d AdventureWorks2014 -Usa -Psql -c -T Output file: C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools>bcp -? uso: bcp {tablabd | consulta} {in | out | queryout | format} archivo de datos [-m errores máximos] [-f archivo de formato] [-e archivo …
desde consola (cmd) cd «C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn» bcp “Person.Address” out c:\data\Address.txt -S “127.0.0.1” -d AdventureWorks2014 -Usa -Psql -c -T Fichero generado: C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools>bcp -? uso: bcp {tablabd | consulta} {in | out | queryout | format} archivo de datos [-m errores máximos] [-f archivo de formato] [-e archivo de errores] …