Skip to content

db_sql_server

Jump to bottom
amaskey edited this page Mar 25, 2018 · 1 revision

Linked server

 * SSMS --> Server Objects --> linked servers
 * right click on linked server --> new Linked server
 * Linked server: friendly name
 * Server type: other data source
 * Provider: Microsoft OLD DB Provider for SQL Server
 * Product name: SQLSERVER
 * Data source: Server name
 * Security --> For login not defined in the list: Be made using login's current security context

Active directory

Brent Ozar - FirstaidResponderKit

DAC

  • during crisis
EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE
GO

foot

Table of Content

Powershell

Ubuntu

Git

Docker

Security Onion

Python

Certified Ethical Hacker

Meteor

Mongo

Systems Admin

Upgrade

IDE shortcuts

Warehouse

Clone this wiki locally