New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 00:29, 9 November 2019 Count Network Connections (hist) [412 bytes] Admin (talk | contribs) (Created page with "To get a count of the number of network connections on a Windows server, you can use the following batch script: <blockquote><pre> REM list network connections and write them...")
- 00:28, 9 November 2019 Tree Directory Listing (hist) [786 bytes] Admin (talk | contribs) (Created page with "A good way to list your files and folders. '''Syntax''' <blockquote><pre> Drive:\Path Drive Letter and Directory Name /f Displays File Names in each Director...")
- 00:28, 9 November 2019 Check Server UpTime (hist) [62 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> systeminfo | find "Time" </pre></blockquote>")
- 00:28, 9 November 2019 General (hist) [285 bytes] Admin (talk | contribs) (Created page with " Email Results of a Database Export Services Manipulation Count Network Connections | Count Network Con...")
- 00:25, 9 November 2019 Check Database Uptime (hist) [93 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sqlserver_start_time FROM sys.dm_os_sys_info; </pre></blockquote>")
- 00:25, 9 November 2019 Check Database Version (hist) [55 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT @@version; </pre></blockquote>")
- 00:24, 9 November 2019 Clone Role with Securables (hist) [451 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> declare @RoleName varchar(50) = '<ROLE_NAME>' declare @Script varchar(max) = 'CREATE ROLE ' + @RoleName + char(13) select @script = @script + 'GRANT ' + p.p...")
- 00:24, 9 November 2019 Check Mirror Status (hist) [791 bytes] Admin (talk | contribs) (Created page with "A handy SQL contributed by Andrew R. <blockquote><pre> SELECT left(a.name,50) 'Database' , CASE b.status WHEN 0 THEN 'Suspended' WHEN 1 THEN 'Disconnected'...")
- 00:24, 9 November 2019 Querying Active Directory Members for SQL Server Databases (hist) [1,016 bytes] Admin (talk | contribs) (Created page with "This is a rather convoluted way of approaching the task required, but does also provide a degree of flexibility. I needed to write a script to obtain a list of members of use...")
- 00:23, 9 November 2019 Various-Tasks (hist) [332 bytes] Admin (talk | contribs) (Created page with "Clone Role with Securables Check Database Version Check Database Uptime Check Mirr...")
- 23:54, 8 November 2019 Creating an Oracle Database with Apex on AWS RDS (hist) [5,512 bytes] Admin (talk | contribs) (Created page with "'''Steps to create an Oracle Standard Edition Two database on AWS with APEX as an option. These notes are for Apex version 5.1.2.v1''' '''PRE-REQUISITIES''' If you don't a...")
- 23:53, 8 November 2019 SQL Server Backup Script for AWS RDS (hist) [1,157 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> DECLARE @dbs TABLE (dbname VARCHAR(50)) DECLARE @currentDB VARCHAR(50) declare @SQL1 nvarchar(3000) declare @SQL2 nvarchar(3000) declare @BUCKET nvarchar(2...")
- 23:53, 8 November 2019 Auto Refresh of Oracle DB across VPCs (hist) [7,346 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> #!/bin/ksh # # Shell script for Snapshot of Databases # Nazim Merchant # 26 Jul 2018 # # Usage script.ksh instance-name source_db_name target_db_name e.g. or...")
- 23:52, 8 November 2019 Datapump Export to S3/Glacier (hist) [5,218 bytes] Admin (talk | contribs) (Created page with "Another script that has been documented for preservation more than anything else. '''Pre-requisites''' * ec2 Instance with Oracle XE installed * Access to the RDS Databases u...")
- 23:51, 8 November 2019 Dynamic Profile Creation Script (hist) [390 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> set serveroutput on declare cursor prof is select dbms_metadata.get_ddl('PROFILE', profile) as profile from (select distinct profile from dba_...")
- 23:51, 8 November 2019 Deploy Amazon Web Services Plugin to Cloud Control (hist) [1,135 bytes] Admin (talk | contribs) (Created page with "To monitor AWS RDS Database via Cloud Control (13c), a plugin needs to be deployed on OEM. Here are some rough notes, for my own reference. '''Download Plug-in''' <blockquot...")
- 23:50, 8 November 2019 Dynamic Tablespace Creation Script (hist) [1,606 bytes] Admin (talk | contribs) (Created page with "This script generates a dynamic Tablespace Creation (with multiple datafiles) script from my target database for my RDS instance. It deals with smallfile tablespaces. <block...")
- 23:49, 8 November 2019 Create a DB Link on RDS DB (hist) [234 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> create database link test connect to <username> identified by "<password>" using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip_address>)(PORT=1521))(CONNECT...")
- 23:49, 8 November 2019 General-Tasks (hist) [648 bytes] Admin (talk | contribs) (Created page with " Creating an Oracle Database with Apex on AWS RDS Dynamic Profile Creation Script [...")
- 23:46, 8 November 2019 Disable Auto SQL Tuning Advisor (hist) [121 bytes] Admin (talk | contribs) (Created page with "<pre> select * from dba_autotask_operation EXEC dbms_auto_task_admin.disable( 'sql tuning advisor', NULL, NULL ); </pre>")