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

www.sqldbanow.com ..read more

 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 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

 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

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

https://docs.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances www.sqldbanow.com ..read more

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

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 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