
SQL SERVER DBA and Azure
1000 FOLLOWERS
This blog is to learn and share SQL DBA and Azure knowledge among people by Bandaru Ajeyudu
SQL SERVER DBA and Azure
1w ago
Use below mentioned code for resolving this issue.
Use [SQLDBANOW]
ALTER DATABASE [SQLDBANOW] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [SQLDBANOW] SET MULTI_USER
GO
www.sqldbanow.com ..read more
SQL SERVER DBA and Azure
2w ago
Database Solution - SQL Server Cloud Migration Strategy
The below mentioned table provides a side-by-side comparison of SQL Server features supported on Amazon RDS and Amazon EC2. Use this information to understand the differences between the two services and to choose the best approach for your use case.
www.sqldbanow.com ..read more
SQL SERVER DBA and Azure
2M ago
SQL Server 2022 new features
The new features in SQL Server 2022 include:
Parameter Sensitive Plan Optimization
Query Store enhancements
Link to Azure SQL Managed Instance
Contained Availability Groups
Azure Synapse Link for SQL
Multi-Write Replication
Azure Active Directory authentication
Azure Purview integration
SQL Server Ledger
AWS S3 storage integration
www.sqldbanow.com ..read more
SQL SERVER DBA and Azure
2M ago
Page Life Expectancy (PLE) in SQL Server:
Page Life Expectancy is the number of seconds a page will stay in the buffer pool without references.
If your page stays for more time in the buffer pool your PLE is high which leads to high performance. Every time request comes there are more chances that it may find its data in the cache itself, instead of going to the hard drive to read the data.
PLE measures in seconds.
PLE is one of the performance counters of SQL Server.
Higher the PLE, performance of SQL Server is good.
As per recommendation, the value of PLE counter is around 300 seconds ..read more
SQL SERVER DBA and Azure
2M ago
An IT Professional, who is responsible for Installation, Configuration, Upgrading, Administration, Monitoring, Maintenance and Security of Databases in any organization.
Phases of a DBA Career path (not limited to these only)
Junior DBAs
Mid-level DBAs
Senior DBAs
DBA consultants
Manager or director of database administration/information technology
Data Architects
Release Managers
Change Managers
Main Responsibilities
Installing and upgrading the database server tools
Planning future storage requirements for the database systems
Modifying the database structure based on information giv ..read more
SQL SERVER DBA and Azure
5M ago
https://docs.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances
www.sqldbanow.com ..read more
SQL SERVER DBA and Azure
6M ago
Top Sites for Education and Career Enhancement
➢ FREELANCING
➢http://www.fiverr.com/
➢http://www.upwork.com/
➢http://www.odesk.com/
➢http://www.elance.com/
➢http://www.99designs.com/
➢http://www.freelancer.com/
➢http://www.guru.com/
➢http://www.peopleperhour.com/
➢http://www.freelanced.com/
➢http://www.ifreelance.com/
CAREER
➢https://www.linkedin.com/
➢https://www.indeed.com/
➢https://www.naukri.com/
➢https://www.monster.com/
➢https://www.careercloud.com/
➢https://www.dice.com/
➢https://www.careerbuilder.com/
➢https://www.jibberjobber.com/
➢https://www.glassdoor.com/index.htm
  ..read more
SQL SERVER DBA and Azure
6M ago
Now the DBA can have peace of mind by giving access to these roles if any user requested for performance or monitoring tools access .
Now no need of giving SA access to such requests.
Below is 2019 SQL SERVER roles.
SQL SERVER 2022 SERVER ROLES:
Fixed server-level role
Description
##MS_DatabaseConnector##
Members of the ##MS_DatabaseConnector## fixed server role can connect to any database without requiring a User-account in the database to connect to.
To deny the CONNECT permission to a specific database, users can create a matching user account for ..read more
SQL SERVER DBA and Azure
7M ago
SQL DBA Checklist/Activities
Daily Checklist
1) Backups
2) SQL Server Error Logs
3) SQL Server Agent Jobs
4) HA or DR Logs
5) Shift Handover (New/Pending Tickets)
6) Implementing planned Change Tickets
Weekly Checklist
1) Integrity Checks (DBCC CHECKDB)
2) Index Maintenance
3) Updation of Statistics
4) Cycle SQL Server Error Logs
5) Reporting of Tickets Handled
6) Planning of Change Tickets
7) If any Weekly Meetings, then Prepare MOM (Minutes of Meeting).
8) Attending CAB Meetings and taking approvals for Changes.
Monthly Checklist
1) Backup Validation Test.
2) Capacity Planning: Disk, C ..read more