Skip to content

Instantly share code, notes, and snippets.

Avatar

Bob Pusateri BobPusateri

View GitHub Profile
@BobPusateri
BobPusateri / Luhn_Algorithm.ipynb
Created Feb 19, 2020
An implementation of the Luhn Algorithm in PowerShell. Demonstrates certain scenarios where digit transposition results in identical checksums.
View Luhn_Algorithm.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@BobPusateri
BobPusateri / PSNotebookCommentBehavior.ipynb
Created Jan 31, 2020
Demonstrating behaviors of PowerShell notebooks that contain both functions and comments
View PSNotebookCommentBehavior.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@BobPusateri
BobPusateri / All_File_Info.sql
Created Jun 24, 2015
Displays info for all files and filegroups in the current Microsoft SQL Server database
View All_File_Info.sql
SELECT
fg.data_space_id AS FilegroupID,
fg.name AS FileGroupName,
f.file_id AS FileID,
f.name AS LogicalName,
f.physical_name,
fileproperty(f.name,'SpaceUsed')/128 AS Used_MB,
(f.size-fileproperty(f.name,'SpaceUsed'))/128 As Free_MB
FROM
sys.database_files f