Features
Features:

Product Tour >

Edraw AI >

Paid Plans:

Individuals >

Business >

Eduaction >
Resources
Blog

History

How-tos & Tips

Discovery

Biography

Business Analysis

Examples

AI concept Map

Free AI Mind Map Generator

Onenote Mind Map

Bcg Matrix Examples

Nike Marketing Strategy

Unilever SWOT Analysis

Make Mind Maps in Google Docs

Guide

FAQs

What's New

Resource Center
Templates
All Templates

Brain Storming Templates

Strategy and Planning Templates

Project Management Templates

Product Management Templates

Human Resources Templates

Agile Workflow Templates

Marketing Templates

Education Templates

Fun and Games Templates

User Gallery
Download
Pricing
Enterprise

SQL deployment

This is a mind map of basic questions about ms SQL applications. The major applications of SQL include writing data integration scripts, setting and running analytical queries, retrieving subsets of information within a database for analytics applications and transaction processing, and adding, updating, and deleting rows and columns of data in a database.

Edited at 2022-12-18 13:55:55

zoltix

Recent works View more works>>

SQL deployment
This is a mind map of basic questions about ms SQL applications. The major applications of SQL include writing data integration scripts, setting and running analytical queries, retrieving subsets of information within a database for analytics applications and transaction processing, and adding, updating, and deleting rows and columns of data in a database.

SQL deployment

zoltix

Recent works View more works>>

SQL deployment
This is a mind map of basic questions about ms SQL applications. The major applications of SQL include writing data integration scripts, setting and running analytical queries, retrieving subsets of information within a database for analytics applications and transaction processing, and adding, updating, and deleting rows and columns of data in a database.

Recommended to you
Outline

40k classes
- 2.3k
- 4
- 1
Oliveettom
Cisco IOS interface
- 680
- 6
Roy Mustang
application development and deployment
- 1.0k
- 17
- 3
Roy Mustang
Data Sanitization Tools
- 463
- 4
Roy Mustang
DATA COLLECTION MEASURES
- 769
- 6
- 1
Roy Mustang
Android
- 520
- 2
- 1
Roy Mustang
Java Training
- 2.0k
- 19
- 3
Roy Mustang
Active reading techniques
- 680
- 5
- 3
Study Smarter
Classification of visual languages
- 437
- 3
Study Smarter
Game Theory
- 1.7k
- 18
- 2
Fiona_

SMD/SQL SERVER

Contacts

Project Manager :Muscat Ophélie

Application support contact(s) ?

Business owner of the application including department name ?

Security/settings

Remote access requirements

! not possible on share server !

need access on sql server

Application support user or vendor's login needs db_owner access to the database for the application installation (remove after the installation) ?

What Authentication will be used by the application to connect to SQL Server(choice)?

SQL Authentication

Windows Authentication – Domain Login

Windows Authentication – Domain Group (preferred)

Does the application require DBAs to create logins going forward?

Provide reasons if SYSADMIN server role is required for the day-to-day application functionality. Use minimal permissions principal?

List access requirements.

Do users from remote offices require direct access to the database

Specific Vlan

add specific network card for the specific vlan

collation

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive(prefered)

Are there any additional security considerations?

Dependencies

install tools/client on SQL server

Provide any dependencies on SQL Server features or services?

SSIS

SSAS

Reporting

Version

Compatibility AlwaysOn

compatibility SQL 2019?

compatibily mode SQL should be okay

Please provide vendor’s documentation

Already provided in omnitracker

AT ?

Capacity

What is the initial database size?

Provide database growth rate: What amount of data in MB\GB\TB or in Rows changes daily/weekly/monthly (provide one)? How much data usually added each year (in MB\GB\TB)? Can you provide examples based on other customers statistics.

Hardware requirements

SQL Server CPU

Memory

Storage

When/How

When application setup is scheduled and will be completed. This is required to make sure that a DBA is available in case of any issues during the installation?

How should the database be initially created?

Need an empty database, application will create database objects ?

There is vendor’s script to create database objects ?

There are data files or a backup provided by the vendor to initialize (attach or restore) the database ?

What is the suggested database name? Does application support a custom database name?

Operational Information

Do you need Auditing requirements ?

Connections strings and other database related application settings ?

Application operational information (For example: Automated processes run at night)

Are there any requirements to keep databases in sync with integrated system(s)?

Backup and Recovery requirements

How much data loss is acceptable?

99,99 is it enough of high availability ?

Cost

todo

Root cause issue