In .NET Framework 4.0+, use this StackOverflow answer to disable TLS 1.0 and force 1.1 or 1.2: ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; In prior .NET Framework […]
Flatten in SQL Server
CREATE TYPE [dbo].[SingleColumnText] AS TABLE ( [TextValue] NVARCHAR (MAX) NULL); create function dbo.Flatten( @input dbo.SingleColumnText readonly ,@delimiter nvarchar(max))returns nvarchar(max)asbegin return ( select stuff(( select @delimiter […]
Create Bootable USB from Windows
I’ve had amazingly bad luck with different programs and operating systems, just trying to create bootable thumb drives. In Windows, when creating a Windows bootable […]
Convert UTC to local time in SQL Server
Thanks to this StackOverflow answer: convert( datetime, switchoffset( convert(datetimeoffset, MyTable.UtcColumn), datename(TzOffset, sysdatetimeoffset()) )) as ColumnInLocalTime
Convert PDF to JPG
This is a pretty limited use case, probably something that will never be needed, but if you need to convert a PDF file to a […]
Convert MP4 to MP3
Using FFmpeg for Audacity command line tool, here’s a simple batch file that lets you drag a series of MP4 files on top of the […]
Catching SQL exceptions in .NET
Here’s one way of handling SQL errors from .NET: For expected errors, like data validation, raise an error with a specific error code and state. […]
Add view location
In ASP.NET Core MVC, here’s how to add a new default location to find views: services.AddControllersWithViews().AddRazorOptions(options => options.ViewLocationFormats.Add(“/Views/SpecialPlace/{0}.cshtml”))
Add response compression in .NET Core
services.AddResponseCompression(options => options.Providers.Add<GzipCompressionProvider>());app.UseResponseCompression();
SQL Merge Insert/Update with output
if object_id(‘tempdb..#joe’) is not null drop table #joe; go declare @results table (id int); create table #joe (id int not null identity, name varchar(100)); insert […]