BACKUP AND RESTORE OF MULTI-PART backup files are actually pretty simple to work with and this is just a quick refresher of statement construction. Once your statement is constructed it will be easy for you to automate the process.
TSQL
TSQL –
TSQL :- Find Schema Uses And Roles
I’ve done and on occasion import databases from others. Both, as a way to send content and receive content. To keep things in sync with users and to ensure that I’ve captured the right users I run this script that… Read More ›
SQL :- Many Flavors (PostGreSQL).
SQL :- Many Flavors (PostGreSQL). Recently I installed PostGreSQL on windows so, I can work on a little project that I’ve been wanting to do. The objective was to learn PostgreSQL and since I’ve started to dig into the free… Read More ›
Certificate :- Test Website SSL Protocols
I’ve recently noticed that so many certificates are expiring on web sites I’m visiting and it’s occurring on an assortment of sites. I use a tool that popups when I encounter issues with certificates. PowerShell Functions
Find database Schema Users
I’ve imported and migrated a tremendous amount of databases into SQLServer versions 2012 and above. Finding and identifying old owners as they would be orphans now or users that should not have access can be made easier by running or… Read More ›