Tags » Database Administrator
It’s very common practice a database administrator guy has two login as WINDOWS authentication and a SQL’s sysadmin at database box. DBA guy always connect DB Server from their own working workstation (Desktop/Laptop) via SQL Server Management Studio (SSMS). 256 more words
I was asked by a developer to grant them access to view Triggers within the database. There is no “read only” option to view triggers. Shown below are the only options to give the user or role. 18 more words
This is how I resolved this warning message.
1. Log onto the standby database and stop the redo apply by issuing this command, alter database recover managed standby database cancel; 24 more words
A database administrator’s perspective
Paul Button has been a database administrator since he completed his postgraduate studies in computer science 13 years ago. A database administrator is an information technology professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organisation. 170 more words
Hi Guys, Today when I was just doing some R&D with SQL server 2016 CTP2, got a new feature in “SQL Server Import and Export Wizard”. 118 more words