Adding Error Handling and Transaction to Stored Procedure
Error Handling Error Handling with Transaction
Passing Table Type to Stored Procedure
User-Defined Table Types Stored Procedure Code Note: Need to make sure the type type has the right access permissions.
Power BI: Import vs DirectQuery
The differences between selecting Import and DirectQuery are the following: Import – the selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. You must refresh the data, which imports the full data set again, to see any changes that occurred to the underlying data since the initial... » read more
Power BI URL Filters
Query string parameter syntax for filtering With parameters, you can filter the report for one or more values, even if those values contain spaces or special characters. The basic syntax is fairly straightforward; start with the report URL, add a question mark, and then add your filter syntax. URL?filter=Table/Field eq ‘value‘ Table and Field names are case-sensitive, value isn’t. Fields that... » read more
Passing In Filters to Embedded Power BI Charts
Customizing your embed experience using URL Settings The ability to create experiences without advanced coding skills, what’s know as low-code, is truly special with this capability. The embed URL supports several input settings that help you customize your user’s experiences. If you’re using the HTML snippet provided, make sure you update the URL in the... » read more
Try Catch with Transaction
Try Catch in SQL with Transaction. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/error-message-transact-sql?view=sql-server-2017
Password Protect File
To password protect file, use WinZip encryption.
SQL Server Build Verions
RTM SP1 SP2 SP3 SP4 Most Recent Version ↓SQL Server 2019 15.0.1600.8 (CTP 3.0) ↓SQL Server 2017 14.0.1000.169 14.0.3192.2 (CVE-2019-1068) ↓SQL Server 2016 13.00.1601.5 13.0.4001.0 13.0.5026.0 13.0.5366.0 (CVE-2019-1068) ↓SQL Server 2014 12.00.2000.8 12.0.4100.1 12.0.5000.0 12.0.6024.0 12.0.6293.0 (CVE-2019-1068) ↓SQL Server 2012 11.00.2100.60 11.0.3000.0 11.0.5058.0 11.0.6020.0 11.0.7001.0 11.0.7469.6 (FIX for SP4) ↓SQL Server 2008R2 10.50.1600.1 10.50.2500 10.50.4000 10.50.6000 10.50.6560.0 (KB4057113) ↓SQL Server 2008... » read more
Database Backup Encryption
Restoring encrypted database on another server (using Backup Encryption). Only works with SQL Server 2014 and later. Backup If a certificate is not backed up prior to backing up a database in T-SQL the following warning will be displayed in the results: Warning: The certificate used for encrypting the database encryption key has not been... » read more
Path
System.IO.Path Path.* Path.Combine Sources: https://docs.microsoft.com/en-us/dotnet/api/system.io.path.combine?view=netframework-4.8