Welcome to your new site.
For more information about customizing your site check out learn.wordpress.com
Latest from the Blog
How to rename all .sql files in a folder to have a new running sequence using PowerShell
$files = Get-ChildItem -Path . -Filter “*.sql”$counter = 5foreach ($file in $files) {$newName = “{0:D2}-$file” -f $counterRename-Item -Path $file.FullName -NewName $newName$counter++} Original sql files in a folder After execution of above script, files are renamed.
First step in Python
Python One of my bucket list of this year, though delayed by almost 8 month, finally my first dive in Python, here it is all about. Python is the most powerful language where you can do anything and everything , let us first check if you already have Python installed in your system. Open command…
All Logins in sql server
–1–Get the list of all Logins in SQL Server –2–List of all SQL Logins only –3–Get the list of all Logins in SQL Server –4–List of all Windows Group Login Accounts only –5–List any specific windows principals or active directory –6–To check the default db of all logins
Get new content delivered directly to your inbox.
SQL Diary & my notes 