TSQL Business Days
Exclude weekends. Account for holidays.
Author
TSQL Encrypt By Pass Phrase
Encrypt data with a passphrase using the TRIPLE DES algorithm with a 128 key bit length. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbypassphrase-transact-sql?view=sql-server-2017
Tableau: Show Last 30 Days
You can use your date field as a filter and choosing the relative filter format.
Microsoft Xamarin
Xamarin is a Microsoft-owned San Francisco-based software company founded in May 2011 by the engineers that created Mono, Xamarin.Android and Xamarin.iOS, which are cross-platform implementations of the Common Language Infrastructure and Common Language Specifications. .NET is a developer platform made up of tools, programming languages, and libraries for building many different types of applications. Xamarin... » read more
IIS does not list a web site that matches the launched URL.
Error: Resolution: Run as Administrator Source:https://stackoverflow.com/questions/10716956/iis-does-not-list-a-website-that-matches-the-launch-url
Debugger is not properly installed. Run setup to install or repair the debugger.
Error: Fix: Turning off Silverlight debugging Go to the web application’s Properties. On the Web tab, turn off Silverlight. Source: https://stackoverflow.com/questions/42943239/vs2017-the-debugger-is-not-properly-installed-cannot-debug-the-requested-type
Find the Report Definition Schema Version (SSRS)
A report definition file specifies the RDL namespace for the version of the report definition schema that is used to validate the rdl file. When you open an .rdl file in a report authoring environment such as Report Designer in SQL Server Data Tools (SSDT), Visual Studio, or Report Builder. If the report was created... » read more
Unable to start debugging on the web server. The remote server returned an error: (405) Method Not Allowed.
Error message as “Unable to start debugging on the web server. The remote server returned an error: (405) Method Not Allowed.” when running ASP.net web project on Microsoft visual studio 2017. This error is due to the IIS Installation and configuration on the machine. To resolve the issue, need to update the IIS installation with... » read more
TSQL Date Format
Letter Note yyyy 4 Digit Year MM 2 Digit Month dd 2 Digit Day HH 2 Digit Hour (24 hour format) mm 2 Digit Minute Sources: https://www.mssqltips.com/sqlservertip/2655/format-sql-server-dates-with-format-function/
Set IDENTITY_INSERT On and Off
Cannot insert explicit value for identity column in table ‘sometableWithIdentity’ when IDENTITY_INSERT is set to OFF