TSQL

TSQL –

SQL :- Many Flavors (PostGreSQL).

By Joseph Kravis on March 2, 2024 • ( 1 )

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

By Joseph Kravis on February 17, 2024 • ( 1 )

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

A digital illustration showcasing a SQL Server database environment with abstract data tables and user accounts, symbolizing schema and user management

Find database Schema Users

By Joseph Kravis on January 21, 2024 • ( 0 )

This script is designed for SQL Server and it helps manage user accounts and schemas in databases that have been imported or migrated to SQL Server 2012 or newer.

BACKUP AND RESTORE SQLSERVER MULTI-PART DB

By Joseph Kravis on March 22, 2019 • ( 0 )

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 :- Find Schema Uses And Roles

By Joseph Kravis on November 28, 2017 • ( 0 )

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 ›