Pauls Blog

git config --global credential.helper manager       

I found a great SQL version tool , SQL Delta, that is made by an Australian Company. sqldelta.com/

Notes By default, the date-time is displayed in long-date and long-time formats for the system locale. When you pipe a date to cmdlets that expect string input, such as the Add-Content cmdlet, Windows PowerShell converts the DateTime object to a string before adding it to the file. The default ToString() format is short date and long time. To specify an alternate format, use the -Format or -UFormat parameters of Get-Date . Here are the valid UFormat specifiers, each of which must be preceded by % , for example, Get-Date -UFormat %Y%m%d Format specifier Meaning Example A Day of the week - full name Monday a Day of the week - abbreviated name Mon B Month name - full January b Month name - abbreviated Jan C Century 20 for 2006 c Date and time - abbreviated Fri Jun 16 10:31:27 2006 D Date in mm/dd/yy format 06/14/06 d Day of the month - 2 digits 05 e Day of the month - digit preceded by a space <space>5 G ...

The underscore character, when used with the LIKE operator, matches any single character. When using wildcards as literals, you need to square bracket the character, like '%[_]%[_]%[_]%' See https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-2017#using-wildcard-characters-as-literals To help me limit the noise with the huge dataset, I employed a simple pattern match to bucket out returned rows.  I was more interested in the classifications and the broad relationships between the rows. I used something like CASE WHEN [Offering] LIKE '%_%_%_%' THEN 'XXX999_209999_X_X' My expectation was a field like 'AAA999_201600_A_B' would appear as 'XXX999_209999_X_X', and it did. But, it also changed 3 digit character entries like 'All' to 'XXX999_209999_X_X'. Turns out that _ is a single character wildcard, so '%_%_%_%' matched the word ‘Al...

Seems to be a good place for SSIS resources http://www.ssas-info.com/analysis-services-scripts/1197-powershell-script-to-list-info-about-ssas-databases

New-Item -ItemType file -Name filename.txt

The process to change the logical name for the database and the log file is  the same  ALTER DATABASE [ DataBaseName ]     MODIFY FILE ( NAME = OldLogicalName ,        NEWNAME =  New LogicalName   ); ALTER DATABASE [ DataBaseName ]       MODIFY FILE  ( NAME = OldLogicalNameLog ,        NEWNAME =  New LogicalNameLog   );