SQL Server - Tips

SQL Server

Page update date :
Page creation date :

Tips related to SQL Server.

In-page links
SQL Server Management Studio
replication
Ssis
Server-side configuration for connecting to SQL Server with SQL Server authentication

Server-side configuration for connecting to SQL Server with SQL Server authentication

In order to connect to SQL Server on other servers with SQL Server authentication, you need to configure various settings.
Steps to migrate all data between servers in SQL Server

Steps to migrate all data between servers in SQL Server

There are several steps you can take to migrate SQL Server data to another server.
Install SQL Server 2014 CTP2

Install SQL Server 2014 CTP2

Provides instructions for installing SQL Server 2014 CTP2.
Install SQL Server 2008 R2

Install SQL Server 2008 R2

Provides installation instructions for SQL Server 2008 R2.
Automatic backup of SQL Server databases

Automatic backup of SQL Server databases

Automatically back up the database by using the SQL Server maintenance plan.

SQL Server Management Studio

Change the text that appears on tabs in SQL Server Management Studio

Change the text that appears on tabs in SQL Server Management Studio

Change the tab text that appears when you enter SQL in SQL Server Management Studio, for example.
Connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment

Connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment

Notes for connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment.
Enable table design changes in Management Studio

Enable table design changes in Management Studio

Allows SQL Server Manageement Studio to rename and type columns in a table.

replication

Enable transactional replication renewable subscriptions in SQL Server 2019

Enable transactional replication renewable subscriptions in SQL Server 2019

In SQL Server 2019, you cannot enable renewable subscriptions when you create transactional replication in the wizard. This section describes the steps to enable it.

Ssis

Install the SQL Server 2014 CTP2 version of the SSIS build

Install the SQL Server 2014 CTP2 version of the SSIS build

Provides instructions for setting up SQL Server Integration Services (SSIS) for SQL Server 2014 CTP2.
SSIS outputs a Unicode string as a Shift-JIS character code to a text file

SSIS outputs a Unicode string as a Shift-JIS character code to a text file

Describes how to output a Unicode string as a Shift-JIS character set to a text file without errors in SSIS (SQL Server Integration Service).
memorandum

memorandum

contains tips about sql server