Skip to main content

Posts

.Net Core 3 Resoures

Resources     • .NET Core Documentation https://aka.ms/dotnet-docs     • SDK Documentation https://aka.ms/dotnet-sdk-docs     • Release Notes https://aka.ms/netcore3releasenotes     • Tutorials https://aka.ms/dotnet-tutorials
Post a Comment
Read more

List users associated to SQL Roles - T-SQL

Shows a list of users associated to database roles. SELECT DP1.[name] AS DatabaseRoleName,      isnull (DP2.[name], 'No members') AS DatabaseUserName      , DP2.[name]    , DP2.[type_desc]    , DP2.create_date    , DP2.authentication_type    , DP2.[sid]  FROM sys.database_role_members AS DRM   RIGHT OUTER JOIN sys.database_principals AS DP1     ON DRM.role_principal_id = DP1.principal_id   LEFT OUTER JOIN sys.database_principals AS DP2     ON DRM.member_principal_id = DP2.principal_id  WHERE DP1.type = 'R'   -- R indicates 'DATABASE_ROLE' , there's also S, SQL_USER ORDER BY DP1.name; 
Post a Comment
Read more

Configure git bash to use Windows Credential Manager

git config --global credential.helper manager       
Post a Comment
Read more

UFormat Date Formatting - Powershell

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 ...
Post a Comment
Read more

Wildcard Characters in T-SQL

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...
Post a Comment
Read more