Need to develop a powershell script (using DBATools module), to sync logins from Primary to Secondary servers on all MS SQL instances hosted on a single server. Steps: 1. Get all SQL instances hosted on a server. 2. Identify Primary instance, and its corresponding Secondary instance in Mirroring and AlwaysOn set-ups. 3. Get Login and SID details from Primary & its respective (all) Secondaries...
Hello, I need database professional to optimize my database table The table is with 1 million records and index ...optimize my database table The table is with 1 million records and index optimization is not enough Some columns have varchar with 4000 symbols Sample attached If you have MSSQL knowledge and read description please write Hello Yellow
...if you have experience with Windows and/or Linux server management. We need someone who can do the code, commission and configure Windows servers. Someone who understands MSSQL indexing and how to optimize queries. Someone who can work on their own with minimal supervision to get the job done. Your day-to-day responsibilities will be to do ASP.Net
I have Student Registration System (SRS) with below features -Sending alerts (Email/SMS) -Reports -Mark attendance ...System (SRS) with below features -Sending alerts (Email/SMS) -Reports -Mark attendance -Fiance handling -Mobile responsive/Web Technology (C# MVC5,WCF, Angular/KnockOutJS, MSSQL) If you need contact me (can be customizing on request)