12,360 reputation
11038
bio website
location
age
visits member for 1 year, 11 months
seen 6 hours ago

I am a Sr.SQL Server and SybaseASE DBA working for a company that makes software for Investment Banks globally as well as does Hosting business. I love working on performance tuning, migration, baselining, process automation, Cloud (Azure), High availability as well as Disaster recovery technologies, etc. I firmly support SQL Server community and so being on this site is my way of gently giving back to the community of what I have earned over the years.


1d
reviewed Close How do I link two tables in access
1d
reviewed Close “Cannot insert the value NULL”, but there is no NULL values!
1d
reviewed Close How to run different MySQL-statements with parameters in a loop using Powershell 2.0?
1d
reviewed Close MySQL Join Clarification
1d
reviewed Close How to interpret undo statistics in Oracle AWR report?
1d
reviewed Close How to increase application performance with Centralised SQL Server
1d
reviewed Close Unable to connect to pgbouncer admin console
1d
reviewed Close How does SQL*Plus connect to Oracle without a listener?
1d
reviewed Close How to update sqlite database using given username not by id . .I tried with below code but its not working
1d
reviewed Close Lost all my Postgres database tables?
1d
reviewed Close MySQL record export and Import
1d
reviewed Close Postgresql restore data from file
1d
reviewed Close What's the best way to translate a website
1d
reviewed Close Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
1d
reviewed Close Do I need to stop the service to back up the database?
1d
reviewed Close Reference assembly in sqlproj not being deployed to server
1d
comment How to export all the security-related information from a SQL Server database
The stuff that @Anti-weakpasswords mentioned - Script DB Level Permissions v2.1 will do the job.
1d
comment Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
@MxyL A wild guess, close SSMS and open it as an Administrator and then try to attach the database. It should work.
1d
answered Loop through all databases and remove all users
2d
comment Slow performance of remote restore
Adding Instant File Initialization will help drastically reduce the restore time. Highly recommended to turn it on for servers running SQL Server