Skip to content

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Day: July 9, 2026

Photoshop

Photoshop: Master Keyboard Shortcuts for Speed

- 09.07.26 - ErcanOPAK comment on Photoshop: Master Keyboard Shortcuts for Speed

โŒจ๏ธ Photoshop Shortcuts = Speed Mouse is slow. Keyboard shortcuts are fast. Master Photoshop, work faster, be more productive. ๐Ÿ“ Essential Shortcuts # Tools V โ†’ Move Tool M โ†’ Marquee Tool L โ†’ Lasso Tool W โ†’ Magic Wand C โ†’ Crop Tool I โ†’ Eyedropper J โ†’ Spot Healing Brush B โ†’ Brush […]

Read More
Visual Studio

Visual Studio: Use Performance Profiler to Optimize Code

- 09.07.26 - ErcanOPAK comment on Visual Studio: Use Performance Profiler to Optimize Code

๐Ÿš€ Performance Profiler = Code Optimization Slow code is frustrating. Performance Profiler finds bottlenecks. CPU, memory, async โ€” optimize your app. ๐Ÿ“ Profiling Tools # Open Diagnostic Tools Debug โ†’ Open Diagnostic Tools (Alt+F2) # Profiling Options – CPU Usage – Memory Usage – Async Profiling – .NET Object Allocation – GPU Usage – Database […]

Read More
C#

C#: Use Span for High-Performance Memory Operations

- 09.07.26 - ErcanOPAK comment on C#: Use Span for High-Performance Memory Operations

โšก Span = Memory Performance Memory allocations slow down apps. Span provides safe, allocation-free access. High-performance, low-allocation code. ๐Ÿ“ Span Basics // Span from array int[] numbers = {1, 2, 3, 4, 5}; Span span = numbers.AsSpan(); // Slice Span slice = span.Slice(1, 3); // {2, 3, 4} // Modify via span slice[0] = 10; […]

Read More
C#

C#: Use Async Streams for Asynchronous Data Sequences

- 09.07.26 - ErcanOPAK comment on C#: Use Async Streams for Asynchronous Data Sequences

๐ŸŒŠ Async Streams = Asynchronous Data Sync streams block. IAsyncEnumerable is async. Process data as it arrives, non-blocking, efficient. ๐Ÿ“ Async Streams Basics // Async stream method async IAsyncEnumerable GenerateNumbersAsync() { for (int i = 0; i < 10; i++) { await Task.Delay(100); // Simulate async work yield return i; } } // Consume async […]

Read More
SQL

SQL: Master Transactions for ACID Compliance

- 09.07.26 - ErcanOPAK comment on SQL: Master Transactions for ACID Compliance

๐Ÿ”„ Transactions = ACID Compliance Data integrity matters. Transactions ensure ACID. Atomic, Consistent, Isolated, Durable โ€” reliable data operations. ๐Ÿ“ Transaction Basics # Basic transaction BEGIN TRANSACTION; UPDATE accounts SET balance = balance – 100 WHERE id = 1; UPDATE accounts SET balance = balance + 100 WHERE id = 2; COMMIT; # With error […]

Read More
Asp.Net Core

.NET Core: Master Logging with Serilog and NLog

- 09.07.26 - ErcanOPAK comment on .NET Core: Master Logging with Serilog and NLog

๐Ÿ“ Logging = Debugging & Monitoring Debugging is hard without logs. Serilog, NLog provide structured logging. Debug, monitor, analyze โ€” powerful logging. ๐Ÿ“ Serilog Setup # Install packages dotnet add package Serilog dotnet add package Serilog.Extensions.Logging dotnet add package Serilog.Sinks.Console dotnet add package Serilog.Sinks.File dotnet add package Serilog.Sinks.Seq # Program.cs using Serilog; var builder = […]

Read More
Git

Git: Automate Tasks with Git Hooks

- 09.07.26 - ErcanOPAK comment on Git: Automate Tasks with Git Hooks

๐Ÿ”ง Git Hooks = Automation Power Manual tasks are repetitive. Git hooks automate at Git events. Pre-commit, post-merge, pre-push โ€” automate your workflow. ๐Ÿ“ Available Hooks # Client-side hooks pre-commit # Before commit prepare-commit-msg # After commit message creation commit-msg # Before commit message final post-commit # After commit pre-rebase # Before rebase post-checkout # […]

Read More
Ajax

Ajax: Master API Authentication (JWT, OAuth)

- 09.07.26 - ErcanOPAK comment on Ajax: Master API Authentication (JWT, OAuth)

๐Ÿ” API Authentication = Secure Access APIs need security. JWT, OAuth, API Keys โ€” choose the right authentication. Protect your API, secure data. ๐Ÿ“ JWT Authentication // Login – Get JWT token async function login(email, password) { const response = await fetch(‘/api/auth/login’, { method: ‘POST’, headers: { ‘Content-Type’: ‘application/json’ }, body: JSON.stringify({ email, password }) […]

Read More
JavaScript

JavaScript: Use Generators for Iterable Functions

- 09.07.26 - ErcanOPAK comment on JavaScript: Use Generators for Iterable Functions

๐Ÿ”„ Generators = Iterable Functions Normal functions run completely. Generators pause and resume. Infinite lists, async flows, custom iteration. ๐Ÿ“ Generator Basics // Generator function function* numberGenerator() { yield 1; yield 2; yield 3; } // Using generator const gen = numberGenerator(); console.log(gen.next()); // { value: 1, done: false } console.log(gen.next()); // { value: 2, […]

Read More
HTML

HTML: Build Reusable Web Components

- 09.07.26 - ErcanOPAK comment on HTML: Build Reusable Web Components

๐Ÿงฉ Web Components = Reusable Elements Framework components are tied. Web Components are framework-agnostic. Reusable, encapsulated, standards-based. ๐Ÿ“ Web Component Basics // Custom Element class MyComponent extends HTMLElement { constructor() { super(); this.attachShadow({ mode: ‘open’ }); } connectedCallback() { this.render(); } render() { this.shadowRoot.innerHTML = ` <style> :host { display: block; padding: 20px; background: #f0f0f0; […]

Read More
CSS

CSS: Master Transforms for 2D and 3D Effects

- 09.07.26 - ErcanOPAK comment on CSS: Master Transforms for 2D and 3D Effects

๐ŸŽฏ CSS Transforms = 2D & 3D Effects Static elements are basic. CSS transforms enable 2D and 3D effects. Rotate, scale, skew, translate โ€” visual magic. ๐Ÿ“ 2D Transforms /* Translate (move) */ transform: translate(50px, 100px); transform: translateX(50px); transform: translateY(50px); /* Rotate */ transform: rotate(45deg); transform: rotate(0.5turn); transform: rotate(3.14rad); /* Scale (zoom) */ transform: scale(1.5); […]

Read More
Windows

Windows 11: Master Device Manager for Hardware Management

- 09.07.26 - ErcanOPAK comment on Windows 11: Master Device Manager for Hardware Management

๐Ÿ–ฅ๏ธ Device Manager = Hardware Control Hardware issues are frustrating. Device Manager manages hardware. Troubleshoot, update, enable/disable โ€” full control. ๐Ÿ“ Device Manager Basics # Opening Device Manager – Win + X โ†’ Device Manager – Search: “Device Manager” – Control Panel โ†’ Device Manager – Right-click Start โ†’ Device Manager # Device Status Icons […]

Read More
AI

AI Prompt: Automated Code Review Assistant

- 09.07.26 - ErcanOPAK comment on AI Prompt: Automated Code Review Assistant

๐Ÿ‘€ AI Code Review Assistant Code reviews take time. AI reviews code โ€” quality, bugs, suggestions. Faster reviews, better code. ๐Ÿ“ The Prompt Review the following code and provide: Language: [Programming language] Code: [Paste your code] 1. Code Quality Assessment – Overall quality rating (1-10) – Readability – Maintainability – Performance 2. Issues Found – […]

Read More
Docker

Docker: Essential Security Best Practices

- 09.07.26 - ErcanOPAK comment on Docker: Essential Security Best Practices

๐Ÿ”’ Docker Security Best Practices Containers have security risks. Docker security protects your apps. Minimal images, least privilege, secure configuration. ๐Ÿ“ Image Security # Use official images FROM node:18-alpine # Official, minimal FROM postgres:15 # Official, trusted # Use specific versions (not latest) FROM python:3.11-slim FROM nginx:1.25 # Scan for vulnerabilities docker scan nginx:latest docker […]

Read More
Kubernetes

Kubernetes: Use PodDisruptionBudget for High Availability

- 09.07.26 - ErcanOPAK comment on Kubernetes: Use PodDisruptionBudget for High Availability

๐Ÿ›ก๏ธ PodDisruptionBudget = High Availability Pods fail, nodes upgrade. PodDisruptionBudget ensures availability. Minimum pods running, safe operations. ๐Ÿ“ PDB Basics apiVersion: policy/v1 kind: PodDisruptionBudget metadata: name: app-pdb spec: minAvailable: 2 # Minimum 2 pods running selector: matchLabels: app: myapp — # Or use maxUnavailable apiVersion: policy/v1 kind: PodDisruptionBudget metadata: name: app-pdb spec: maxUnavailable: 1 # […]

Read More
Wordpress

WordPress: Start Selling with WooCommerce

- 09.07.26 - ErcanOPAK comment on WordPress: Start Selling with WooCommerce

๐Ÿ›’ WooCommerce = E-commerce Power Selling online is essential. WooCommerce adds e-commerce to WordPress. Products, payments, shipping โ€” all in one. ๐Ÿ“ Setting Up WooCommerce # 1. Install WooCommerce – Plugins โ†’ Add New – Search “WooCommerce” – Install and Activate # 2. Setup Wizard – Store details – Industry type – Product types – […]

Read More
Photoshop

Photoshop: Master Compositing for Epic Images

- 09.07.26 - ErcanOPAK comment on Photoshop: Master Compositing for Epic Images

๐ŸŽจ Compositing = Epic Image Creation One photo is limited. Compositing combines multiple images. Create anything, blend seamlessly, realize your vision. ๐Ÿ“ Compositing Process # Step 1: Planning – Concept sketch – Source images – Lighting reference – Color palette # Step 2: Collection – Find/stage images – Consistent perspective – Similar lighting – High […]

Read More
Visual Studio

Visual Studio: Use Code Cleanup for Consistent Formatting

- 09.07.26 - ErcanOPAK comment on Visual Studio: Use Code Cleanup for Consistent Formatting

๐Ÿงน Code Cleanup = Consistent Code Messy code is hard to read. Code Cleanup formats, organizes, and styles. One click, consistent code. โŒจ๏ธ Code Cleanup Shortcuts Ctrl + K, Ctrl + D โ†’ Format document Ctrl + K, Ctrl + F โ†’ Format selection Ctrl + . โ†’ Quick actions Ctrl + R, Ctrl + […]

Read More
Page 2 of 2
ยซ Previous 1 2

Posts pagination

« Previous 1 2
July 2026
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Jun    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (960)
  • How to add default value for Entity Framework migrations for DateTime and Bool (898)
  • How to make theater mode the default for Youtube (858)
  • Get the First and Last Word from a String or Sentence in SQL (840)
  • How to select distinct rows in a datatable in C# (814)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (597)
  • Add Constraint to SQL Table to ensure email contains @ (582)
  • Average of all values in a column that are not zero in SQL (545)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (512)
  • Find numbers with more than two decimal places in SQL (460)

Recent Posts

  • C#: Use Using Statements for Resource Management
  • C#: Use Lambda Expressions for Concise Code
  • SQL: Use GROUP BY for Data Aggregation
  • .NET Core: Master Routing for Clean URLs
  • Git: Use Reset to Undo Local Changes
  • Ajax: Use Axios for HTTP Requests
  • JavaScript: Understand Hoisting
  • HTML: Use Web Storage for Client-Side Data
  • CSS: Use Filter Effects for Visual Magic
  • Windows 11: Unlock God Mode for All Settings

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (960)
  • How to add default value for Entity Framework migrations for DateTime and Bool (898)
  • How to make theater mode the default for Youtube (858)
  • Get the First and Last Word from a String or Sentence in SQL (840)
  • How to select distinct rows in a datatable in C# (814)

Recent Posts

  • C#: Use Using Statements for Resource Management
  • C#: Use Lambda Expressions for Concise Code
  • SQL: Use GROUP BY for Data Aggregation
  • .NET Core: Master Routing for Clean URLs
  • Git: Use Reset to Undo Local Changes

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com