SSRS RDS File
Shared Data Sources file. SQL Server Connection string:
Author
SSRS Expression
Field01 String Sum of Field01. If statement. Global Date Currency Switch Running Value https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-runningvalue-function?view=sql-server-2017 Bit Number
Could not load file or assembly. The system cannot find the file specified.
Error: Resolution: If you use custom DLL in your SSRS reports, make sure the DLL is copied over to the shared DLL folder. For VS2017 Community Edition, copy over the DLL to this folder… Other Locations: Sources: https://stackoverflow.com/questions/43520437/ssrs-custom-assemblies-could-not-be-loaded-under-visual-studio-2017
SSRS Report Data Panel
In Reporting Services Report Designer in SQL Server Data Tools (SSDT), the Report Data pane displays a hierarchical view of data objects that you can use in a report, including data sources, datasets, fields, parameters, and images. Data sources in this view can be embedded or references to shared data sources that are displayed in... » read more
Visual Studio: Build vs Rebuild
Build solution only builds those projects which have changed in the solution, and does not effect assemblies that have not changed, ReBuild first cleans, all the assemblies from the solution and then builds entire solution regardless of changes done.
Installing Services Application
Command Line Make sure you open up Command Prompt and run in administrator mode. App should now appear in Services. App should now be removed from Services. Batch File InstallMyAppAsService.bat UninstallMyAppAsService.bat Sources: https://docs.microsoft.com/en-us/dotnet/framework/tools/installutil-exe-installer-tool
TSQL Business Days
Exclude weekends. Account for holidays.
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