Run these commands on the master table. First get the existing rules Based on the above query if there are any rules you need to remove get the name and replace Client with the appropriate name If you need to add an IP rule go to https://www.kittell.net/ip.php and update the…
Category: MSSQL – Audit
MSSQL – List Users With Permissions
Sometimes you really just need to know how many users you have on your database, the below script will give a quick report for your database. Note: This script is designed to run on a selected database, you will have to select the database first and then run the script.
Azure – MSSQL Server Information
Same as MSSQL Server Information but is specific to what will work in Azure
MSSQL Server Information
If you have ever started a new job and we told to “Dig into the database and learn” these scripts likely have come to mind whether or not you knew/know them. References & Credit: http://www.pinaldave.com/ / http://blog.sqlauthority.com/ https://www.simple-talk.com/sql/database-administration/exploring-your-sql-server-databases-with-t-sql/
MSSQL Table Backup Script
This is a quick way to backup table structure and data, this will go out to the system table and query all tables then provide a script to recreate the tables. This is a bit of a hack but works to backup all the rows in your tables. Run the…
Find Table Differences And Sync Tables
Have two databases with the same table schema and need to keep both up to date? First, let us look at the differences between the two databases. The query below will show the differences between the development database table tbl_zip_code and the production database table tbl_zip_code. Ideally the differences should…
Count All Rows In All Tables
There are a few ways to count all of the rows in all of your tables in a database. The “Fastest Option” actually pulls the information from the database where the numbers are stored rather than taking time to count rows.
MySQL – Table/View Column Information
Similar to MSSQL – Table/View Column Information, this post will help with MySQL tables and columns. This query is a quick query to give you the pertinent information about a specific table.
Ektron File Extension Asset Inventory
Following the logic in a previous post, File Extension, this query will list Ektron asset file extensions and count them.