Monday, November 22, 2021

SQL Server - Drop indexes and stats

›
  Query to get the 'drop query for Stats' SELECT distinct 'DROP STATISTICS ' + sca.name + '.' + t.name + '....

SQL Server - Deleting the contents from log file

›
  You can shrink the log with the following Statements: USE [MyDatabase] GO ALTER DATABASE [MyDatabase] SET RECOVERY SIMPLE WITH NO_WAIT ...
Monday, July 5, 2021

Remove 'Powered by Shopify' from your store

›
From your Shopify admin, go to Online Store > Themes.   Find the theme that you want to edit, and then click Actions > Edit languages...
Wednesday, June 23, 2021

Adding Cache-Control headers to Static Files in ASP.NET Core

›
 Implement Caching to Static files in the asp.net core When you create a new ASP.NET Core project from the default template, you will find t...
Saturday, May 29, 2021

SEO for different countries

›
  There are 3 options for SEO in different Countries: 1.        Country Code Top Level Domains (ccTLDs) : a.        A ccTLD (Country Cod...
Thursday, March 11, 2021

Background color not showing in print preview

›
  The Chrome CSS property   -webkit-print-color-adjust: exact;   works appropriately. media print CSS in the body: @media print { body {-w...

503 This mail server requires authentication when attempting to send to a non-local e-mail address.

›
 Server error: '503 This mail server requires authentication when attempting to send to a non-local e-mail address. Please check your ma...
Wednesday, February 17, 2021

SQL SERVER - How to capitalize the first letter of a record in SQL

›
  Cast your ntext to nvarchar(max) and do the upper and left operations. Sample below. SELECT UPPER ( LEFT ( cast (Comments as nvarchar(ma...