840 skills found · Page 15 of 28
carolindata / SQL TutorialsScripts y archivos del curso de SQL (MySQL)
redfr0g / CVE 2023 20110PoC script for CVE-2023-20110 - Cisco Smart Software Manager On-Prem SQL Injection Vulnerability
ExcQL / ExcQLA web application transforming excel spreadsheets into SQL scripts
NordPerfEngg / OracleDBALiteApplication: DBALite Oracle Database Performance Summary App Application Purpose: Provide Oracle host and database performance info suitable for non-dbas. Target users are Non-dba performance engineers, testers, prod support staff and application team members who want to proactively and reactively monitor their databases. Licensing: Because this App queries the dba_hist_sqlstat AWR data, a license must exist for the Oracle Diagnostic Pack. Most facilities running Oracle databases have this license. Application Basic Structure: Four stored procedures run in the Oracle database. They read performance data tables and write it out to datafiles which are consumed by Splunk. Oracle Scheduler jobs execute the stored procedures at configurable intervals. The app also uses the Splunk Add-on for Unix and Linux to get host metrics. Dependencies: Splunk Add-on for Unix and Linux (http://docs.splunk.com/Documentation/UnixAddOn/latest/User/InstalltheSplunkAdd-onforUnixandLinux) Stored procedures and scheduler jobs running in Oracle Database 11.1 or higher (procedures scripts included in the setup files.) Index creation: Splunk Add-on For Unix and Linux will create the 'unix_metrics' index. This DBALite app will create the 'database' index. Sourcetypes: om:oracle:locks -- snapshot information about blocking locks om:oracle:memory -- Oracle sga and pga memory statistics om:oracle:osstat -- Operating System stats from v$osstat table om:oracle:sql -- top resource consuming sqls from dba_hist_sqlstat om:oracle:sqltext -- sqltext for the top resource consuming sqls om:oracle:sysevent -- wait event information om:oracle:sysstat -- performance statistics from v$sysstat table Installation: Oracle Setup: Copy all the sql scripts from the Oracle_Performance_Summary_For_Splunk/bin directory to your database server or run them in SQL Developer or other tool. Connect to your database. As sysdba, create the splunk sch_spl user. (Sysdba is required for this one script in order to grant privileges on DBMS_LOCK and UTL_FILE: @cr_sch_spl.sql Create a unix directory where you want Oracle to write the output files. Splunk will pick up the data from these output files created by the stored procedures. If the owner of the directory is not the ORACLE user, then make the ORACLE user a member of the Unix group for the directory so that Oracle can write to the directory. Make the permissions on the directory 774. Note: For a RAC database, just create the directory on one node. The app is not elaborate enough to provide failover capabilities, so in case of an outage of its node, the data would just not be written until the node came back online. Create an Oracle Directory called 'DIR_SPLUNK' using the above unix directory. Example: CREATE DIRECTORY dir_splunk as '/u01/perf/dbdashboard/data'; grant read,write on directory dir_splunk to sch_spl; As the splunk user SCH_SPL, create the stored procedures and scheduler jobs that will run them: @cr_procs_and_jobs.sql After 10 minutes, check the data files to confirm there is data being written to them. These data files should exist: dbd_locks.txt dbd_memory.txt dbd_osstat.txt dbd_sysevents.txt dbd_sysstat.txt dbd_top_sql_text.txt dbd_top_sql.txt To check the scheduler jobs, as SCH_SPL user, execute: 'SELECT job_name, actual_start_date, status, additional_info from user_scheduler_job_run_details order by actual_start_date;'
blindma1den / SqlScannerThis is a script that scans an IP address or URL for SQL Injection vulnerabilities. If any are found, it includes an extensive library of ready-to-use injection techniques, and you can also utilize your own custom injections.
QuentinAmbard / Databricks Sql ClonePython script to clone SQL dashboard from one workspace to another
SeriaWei / Mssql2mysqlThis tool is used to generate mysql script from microsoft sql server
Apocrathia / DISA SQL 2014 STIGA collection of PowerShell and SQL scripts to automate the STIG process of a Microsoft SQL 2014 Server.
bruce-dunwiddie / Tsql Depends.Net Library for Parsing Database Object Dependencies from T-SQL Scripts
spnda / Volvo Vida DbScripts and SQL statements for retrieving and working with data from the Volvo VIDA database
infovore / Mysql Backup ScriptsRuby scripts to back up every single mysql database on your system to .sql files, and to restore from them
toshiossada / LeitorExcelLeitor de Excel para gerar um TXT contendo script SQL, utilizando Threads
sotorrent / Db ScriptsSQL and Bash scripts to import the offical Stack Overflow data dump and the SOTorrent data set, to retrieve Stack Overflow references from the BigQuery GitHub data set, and to retrieve data from the SOTorrent dataset for analysis.
MiChaelinzo / Advanced Penetration Testing ScriptThe script is an advanced Python-based tool that can be used to test a website for various vulnerabilities such as SQL injection, cross-site scripting (XSS), cross-site request forgery (CSRF) and insecure file upload.
max-ieremenko / SqlDatabaseCommand-line tool and PowerShell module for MSSQL Server, PostgreSQL and MySQL.
janedallaway / SQL Server Helper ScriptsA collection of SQL scripts I've written/amended over the years
sokolsaiti / Oracle Dba Sql ScriptsVarious SQL scripts for Oracle RDBMS administration that can be used in conjunction with SQL*Plus utility
nkarag / Oracle Ready2run ScriptsReady to run Oracle scripts for day to day admin tasks, SQL Tuning and Performance Tuning.
TheMLC / Bwarm Data LoadA collection of SQL Scripts The MLC uses to load BWARM snapshots into Data Stores
kbranigan / Shapefile Converterthis script takes a shapefile (*.shp, *.dbf) and creates a (*.sql)
