-
-
Code | MSSQL | MSSQL - Audit | SQL
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/
-
Code | MSSQL | MSSQL - Audit | 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 query and it will generate…
-
Excel Rand
Great if you are creating random passwords, more examples at the reference link below. Reference: http://excel.tips.net/T003872_Generating_Random_Strings_of_Characters.html
-
Excel – Find Comma Replace With LineBreak
Selected the range of cells you need to replace. Go to Home > Find & Select > Replace or Ctrl + H Find what: , Replace with: CTRL + SHIFT + J Click Replace All Somehow CTRL + SHIFT + J is registered as a linebreak. Reference: http://stackoverflow.com/questions/14856501/substitute-a-comma-with-a-break-link-in-a-cell
-
Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.7 | SQL
Ektron Show duplicate content
If you have more than one person in the site administration you can sometimes get duplicates, this script will help you find them.
-
Concatenate Address Columns In One Column
In many databases the address is properly separated into various columns but in a report you want to concatenate them. This simple script will pull them together in one column without causing extra spaces
-
Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.7 | SQL
Ektron Menu Item List
List out all items in an Ektron menu
-
Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.7 | SQL
Ektron Content List
This is a collection of a few other scripts that I’ve posted here but this script concatenates widget and alias listings into one column so that you only have one row per content item.
-
Ektron List Widgets On Content
This is another Ektron audit script that will help list PageBuilder content items that have a widget placed on them. The script below is very similar to Ektron Alias With Folder Name