Necessity is the mother of new PowerShell code :-)! Today, I had to unmask all the columns I had helped mask using Dynamic Data Masking. This simple post assumes that you are a privileged user with the ability to drop "Column Masking"! Identify Masked Columns The SQL to identify all masked columns is pretty simple … Continue reading PowerShell & SQL Server: Unmask All Masked Columns (Dynamic Data Masking) In Database
PowerShell: How To Reverse Alphabetical File Names & Rename
Recently I had shot a bunch of videos on a Video App on my iPhone. By default it saves the videos/photos within the App itself. Later, I can move them to iPhone "Photos". Why are file names in reverse order of how I shot them? In the case of this app, I just did "Select … Continue reading PowerShell: How To Reverse Alphabetical File Names & Rename
SQL Server: Disable/Remove Indexes Across Servers/Databases Using PowerShell & dbatools
This is something I had to do today. In this blog post, I am going to show you how you can disable or remove indexes matching certain name criteria or other condition(s) across multiple servers and databases in various tables. Usually, this is a very painful process if done by hand but with the fantastic … Continue reading SQL Server: Disable/Remove Indexes Across Servers/Databases Using PowerShell & dbatools
MySQL: Fix MySQL Error 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
This is a note for me and others who may find themselves running into this error when using a MySQL client such as MySQL Workbench or the MySQL shell connecting to a MySQL database The Error: You try to connect to MySQL from your client host (outside the server) using a MySQL client and get … Continue reading MySQL: Fix MySQL Error 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
SQL Server: Backup/Restore to/from NAS Shares with Username/Password
Traditional Permanent NAS Share We setup NAS shares all the time for SQL Server backups and the procedure is quite simple. Find the SQL Server Engine Service account Grant full-control privileges to the share for the account Restart the SQL Server Engine Service for permissions to take effect (if needed) #Get the service account name(s). … Continue reading SQL Server: Backup/Restore to/from NAS Shares with Username/Password