How to Remove “Restricted User” in SQL Server
SQL SERVER DBA and Azure
by
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
Visit website
Test Post
SQL SERVER DBA and Azure
by
2w ago
www.sqldbanow.com ..read more
Visit website
SQL Server - Choosing Between AWS EC2 vs AWS RDS
SQL SERVER DBA and Azure
by
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
Visit website
New and Enhanced Features in SQL Server 2022
SQL SERVER DBA and Azure
by
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
Visit website
Page Life Expectancy, Buffer Cache Hit Ratio
SQL SERVER DBA and Azure
by
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
Visit website
Who is a DBA?
SQL SERVER DBA and Azure
by
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
Visit website
Rev login
SQL SERVER DBA and Azure
by
5M ago
https://docs.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances www.sqldbanow.com ..read more
Visit website
Top Sites for Education and Career Enhancement
SQL SERVER DBA and Azure
by
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
Visit website
New security server roles in SQL SERVER 2022
SQL SERVER DBA and Azure
by
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
Visit website
SQL DBA Checklist/Activities
SQL SERVER DBA and Azure
by
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
Visit website

Follow SQL SERVER DBA and Azure on Feedspot

Continue with Google
OR