Contents tagged with database
-
Restore an existing availability group database participating in SQL Server Always On Availability Groups
https://www.sqlshack.com/restore-an-existing-availability-group-database-participating-in-sql-server-always-on-availability-groups/
https://mlichtenberg.wordpress.com/2016/02/02/how-to-restore-a- … more
-
Get the sample databases for ADO.NET code samples
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases more
-
How to create a new user in a SQL Azure database
In SQL Server Management Studio:
1) select the database from the database dropdown list
2) run the following script:
CREATE USER [myusername] WITH PASSWORD = 'mypassword';
ALTER ROLE [db_owner] … more
-
SQL Server: Prepare a Mirror Database for Mirroring
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/prepare-a-mirror-database-for-mirroring-sql-server?view=sql-server-ver15 more
-
Using PowerShell to Generate Logins, Server and Database Permissions
https://www.databasejournal.com/features/mssql/using-powershell-to-generate-logins-server-and-database-permissions.html more
-
RMAN Full Backup & Demo
https://blog.zeddba.com/2019/05/23/rman-full-backup-demo/ more
-
TSQLT, The Open Source Database Unit Testing Framework For Sql Server
https://tsqlt.org/ more
-
Free SQL Azure Database
There used to be a free tier for SQL Azure Database, as well as a free web app tier. But now the free SQL Azure Database tier seems to have disappeared.
https://renouncedthoughts.wordpress.com/201 … more
-
How Do You Export A Database In Azure Data Studio
https://www.scarydba.com/2019/02/25/export-a-database-in-azure-data-studio/ more
-
Force Oracle Database Listener to Listen on Specific IP Addresses For VPN Connections
1) First, add the IP address of the database server (the ip address of the machine on the VPN network) as a listening location in Net Manager, and also specify the Port Number to connect to the … more
-
Oracle Database Change Port
https://help.blackboard.com/Learn/Administrator/Hosting/Databases/Database_Ports_Oracle
http://sumations.net/i/doc/XEDBA/network005.htm
-
Hierarchy of Database Needs
https://www.brentozar.com/archive/2011/06/ozar-hierarchy-database-needs/ more
-
Developing a Web Service from a PL/SQL Package with JDeveloper
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/202336.htm
https://technology.amis.nl/2010/12/29/quickly-creating-reploying-and-testing-a-webservice-interface-for-adf-business- … more
-
Copy Database Data into Collection
public static ArrayList<Customer> getAllCustomer() throws ClassNotFoundException, SQLException {
Connection conn=DBConnection.getDBConnection().getConnection();
Statement stm;
stm = conn. … more