I needed to search in all tables for a certain GUID, I used this SP in MS SQL Server 2016: Find a GUID (or anything) in ANY table in your database! | CSharpner.com
How to copy tables from one database to another in SQL Server
See heading: Using SQL Server Export / Import wizard
Solution for responsive images covering entire container and keeping aspect ratio
This solution is probably already out there somewhere on the interwebs, but I write it down for now.
I’ve been working with a Bootstrap 4 based website a lot lately.
Today I got the requirement to make an background image adjust to the height of its sibling column but at the same cover the entire background of its container.
I want the entire container box to be covered by the background image and still keeping its aspect ratio in various screen sizes, it’s ok with clipping and stretching (if image is to small). Here is a solution:
html:
<div class="row"> <div class="col-6"> <div class="teaser-container" id="teaser1"> ...column 1 html content... </div> </div> <div class="col-6"> <div class="teaser-container" id="teaser2"> ...column 2 other various height html content... </div> </div> </div>
css:
#teaser1 { height: 100%; background-image: url('/globalassets/top-image.jpg'); background-repeat: no-repeat; background-position: center; background-size: cover; }
Throttling your API in ASP.NET
Can someone DOS attack your API and bring down your webservice? Could I hit your API at 100 requests a second and bring down your server?
Source: Throttling your API in ASP.NET
How can I enable Assembly binding logging? – Stack Overflow
Automatic visual tests with Episerver: Test after a Deploy | Alf Nilsson talks
Optimisation and validation tools for web development – Growing with the Web
Using git-flow to automate your git branching workflow
Blazor: a technical introduction
What is Blazor? It’s a framework for browser-based (client-side) applications written in .NET, running under WebAssembly. It gives you all the benefits of a rich, modern single-page application (SPA) platform while letting you use .NET end-to-end, including sharing code across server and client. The announcement post covers more about the intended use cases, timescales, and so on.
Source: Blazor: a technical introduction
Azure VMs – Start/Stop during off-hours solution
Follow this link to setup daily start and stop of your Azure VMs (saves money for dev or test environments that only needs to be active during workhours for instance).
Start/Stop VMs during off-hours solution (preview) | Microsoft Docs
(Goto Marketplace and select Start/Stop VMs during off-hours [Preview] from the search results.)
When done, the above steps have created daily start and stops, to set monday-friday 07:00-19:00 (and off during holiday) go to Resource group -> Automation account -> Schedules.
Deactivate “Scheduled-StartVM” and “Scheduled-StopVM”. Edit “Sequenced-StartVM” and “SequencedStopVM” and set weekdays schedule using these.