Being handed responsibility for a Microsoft SQL database for the first time can seem like a lot to take in. The good news is that once you understand the core tasks, the day-to-day management is much less overwhelming. Here’s a practical breakdown of what you need to know to get started.
Almost everything in MS-SQL management is done via SQL Server Management Studio (SSMS), the official database management tool from Microsoft. Get to know this first and then everything else will be easier.
With SSMS you can do:
Connecting to Your Database Server
Write and execute SQL queries
Create and edit tables
User and access management
Database backup and restore
Monitor performance and catch problems early
Consider this as the control room of your entire database setup.
First you have to get connected to manage anything. Here’s how:
Step 1— Get your connection details: server hostname, database name, username, password
Step 2— Open SQL Server Management Studio

Step 3— In the connection window enter your credentials
Step 4—Click Connect and you’re in.
If you are connecting from outside the server’s local network, you may need to speak with your hosting provider about firewall permissions or remote access settings that need to be configured first.

Your data is in tables—customers, orders, products, employees. You will, on an ongoing basis, be:
Growing your application, creating new tables
Re-arranging columns when requirements change
Adding indexes to keep the searches running fast
Getting rid of old data that makes things slower
Queries are how you talk to your database. A handful of the basic ones will take care of most everyday situations.

With queries you are able to:
Search & retrieve individual records
Create, update or delete records
Create reports on demand
Instantly pull order histories, inventory levels and user activity
Not everyone needs the same level of access. With MS-SQL you can:
Setup individual user account
Give permissions according to what each person actually needs
Limit access to sensitive information
Restrict full admin privileges
This is especially true if your database contains customer information or financial data.
This is the one habit worth developing from day one. How to Back up a database in SSMS:

Step 1 - Right click on the database name in the object explorer
Step 2 – Choose Tasks → Back Up
Step 3 — Choose your backup type and location
Step 4 — Click OK to execute
Automate backups on a schedule so you do not have to remember and always have a recent copy. In case of something gone wrong restore is similar via Tasks → Restore
As the database grows, keep an eye on the slow queries, server resource consumption, database size and index fragmentation. The sooner you catch these issues the better to avoid small issues becoming serious ones.
Use strong and unique passwords for all database accounts.
Limit administrative access to those who really need it
Keep SQL Server up to date with latest patches
Set up automatic backups, no questions
Restrict remote access where it is not required
Check for unusual login activity regularly
Getting to know SSMS, knowing the basic tasks, and building good security and backup habits from the start will hold you in good stead to confidently manage any MS-SQL database — whether it’s a small application or a large enterprise system.