Orphaned Users Script
Database administration Script. After a SQL Server database restoration, this script recreates the logins based on the users of the recently restored database in the new server, and based on the users of the ERP which are located in a table in the same database. It recreates the logins and binds them with the users, if the logins already exists only rebinds the logins with the users.
Mi perfil
15+ years of experience in Data Engineering, BI, SQL, reports/dashboards design and construction, ETL/ELT, Data Warehousing, Data Analytics, database administration/tuning/optimization, and related work. 7+ years of experience working remotely on project all around the world. Native Spanish speaker, and near-native English speaker, located in the American Central Timezone (GMT -05). Ideal for near-shore projects requiring constant communication during office hours. TECH STACK =========== MS SQL SERVER: - Transact-SQL - Administration - Tuning MS SQL SERVER BI ON PREM STACK: - Power BI: DAX, M - Reporting Services - Analysis Services: Tabular (DAX), OLAP(MDX) - Integration Services AZURE CLOUD DATA STACK: - Azure Data Factory - Synapse - Databricks - Data Lake SCRIPTING: - Python - VB.NET - C# - PowerShell OTHERS: - Snowflake - MS Excel: Formulas, VBA (Macros) - QlikView - Tableau - Oracle (PL/SQL) - MySQL - PostgreSQL - UNIX - XML - YML - JSON - Git - SCRUM ** Adjustable rates according to work complexity, urgency, and/or project size. **
