▼

SQL Server auto generate UNIQUEIDENTIFIER

›
 Insert data into a table ✅ Have SQL Server auto-generate both: Id (as INT IDENTITY ) RowGuid (as UNIQUEIDENTIFIER , using NEWID()...

different advanced topics — each with a real-world use case, code example, and detailed explanation. These examples build on what you already know (SELECT, JOIN, INSERT, UPDATE), but show how to go further with SQL Server's features.

›
  🔸 1. Common Table Expressions (CTEs) ✅ Use Case: Get the second most recent order per customer. WITH OrderRanks AS ( SELECT ...

How can increase SelectPdf 5 limits to 10 pages using PdfSharp.Pdf with examples Dot Net

›
SelectPdf Free Edition supports up to 5 pages per document. That’s why we generate two parts and merge. Install these  dotnet add package Se...

using SQL Server, and you want to import 20+ tables from Production into UAT in one go, here’s a streamlined process using SQL Server Management Studio (SSMS).

›
  Goal: Import All Tables from Production into UAT (One Time) 🔧 Method 1: Generate Scripts (Schema + Data) This is the cleanest way to ex...

Useful VS Code Extensions / Packages

›
  Name What it does Why helpful for checking commits / trees GitLens Enhances built‑in Git support: inline blame, commit graph, file history...

HiQPdf – Convert URL to PDF and Stream to Browser (ASP.NET)

›
 using System; using System.Web; using HiQPdf; public class PdfController : System.Web.UI.Page {     protected void Page_Load(object sender,...

commonly used in modern ASP.NET Core apps more examples using fetch + Blob in JavaScript to download files PDF, Excel

›
 Let’s explore real-world examples using the fetch + blob pattern, targeting different file types and scenarios. ✅ 1. Download Static PD...