Tag feed

#sqlserver

15 posts1 followers

Explore Hashnode

Alternatives

Trending tags this week

KSKay Sauterkayondata.comMar 8 · 6 min read

Publishing Powershell Azure SQL VM Toolkit

In 2021, I wrote a PowerShell script to automate most of the steps for deploying a SQL Server VM on Azure, but not everything. Also back then, the whole deployment process with the script took almost

0

ARAshifur Rahamansqlinsights.hashnode.devDec 8, 2025 · 4 min read

Database Design Guidelines: Naming & Data Types

Introduction The quality of a database is determined by two pillars: clarity (how easy it is to read) and efficiency (how well it performs). Naming Conventions ensure that the database is not a "black box" but a readable map for developers. Data Ty...

0

ARAshifur Rahamansqlinsights.hashnode.devNov 20, 2025 · 4 min read

SQL Server Internals: Storage Engine and Data Consistency

1. Physical Storage Architecture To the Operating System, SQL Server is simply reading and writing files. Internally, however, it manages a strict hierarchy of logical units. 1.1 File Structure Every database consists of two primary physical files lo...

0

MJMorteza Jangjoojangjoo.hashnode.devSep 17, 2025 · 4 min read

SQL Server Ledger Tables

Introduction Data integrity and tamper-proof auditing are critical in financial, healthcare, and government applications. Starting from SQL Server 2022, Microsoft introduced Ledger Tables, a blockchain-like feature that guarantees immutability and cr...

0

CRChitt Ranjan Mahto (Chirag)chiragtutorial.hashnode.devAug 22, 2025 · 6 min read

Speed Up Reads with Buffer Pool Extension (BPE) in SQL Server 2022 on Window Server 2025 Complete Working Example

inchirags@gmail.com Chirag SQL Server DBA Tutorial https://www.chirags.in ***************************************************************************************** Speed Up Reads with Buffer Pool Extension (BPE) in SQL Server 2022 on Window Server 20...

0

MMichaelmmuehlbeyer.hashnode.devAug 20, 2025 · 5 min read

Connect AWS RDS Custom for Oracle to SQL Server

To connect an Oracle database(this time we use an AWS RDS Custom for Oracle) with an SQL Server (Cloud or On-Prem) you could make use of the Oracle database gateway for SQL Server. In general the gateway serves as a link between Oracle and external s...

0

SCSQL CHANGE GUARDsqlchangeguard.hashnode.devJul 2, 2025 · 3 min read

Why SQL Change Management is Critical in Regulated Industries

In highly regulated industries like banking, healthcare, insurance, and government, managing changes to databases is not just a best practice—it’s a compliance necessity. Mishandled SQL changes can lead to catastrophic data loss, service outages, and...

0

RSRehan Shafiqrehanshafiq.hashnode.devJun 2, 2025 · 4 min read

A Step-by-Step Guide to Integrating SQL Server with Java on Windows

This guide walks you through integrating a Microsoft SQL Server database with a Java application on a Windows system using JDBC (Java Database Connectivity). Assuming you’ve already installed the necessary tools (JDK 8+, SQL Server Express, SSMS, JDB...

0

SSnehaifdaxbi.hashnode.devMay 31, 2025 · 4 min read

Demystifying IF Statements in DAX: How DAX Evaluates Logic

DAX (Data Analysis Expressions) is the formula language behind Power BI, Excel Power Pivot, and SSAS Tabular models. While it looks simple on the surface, DAX has some quirks—especially when it comes to evaluating conditional logic using the IF state...

0

RRishithathelearningcurve.hashnode.devMay 14, 2025 · 3 min read

🚀 Day 6: Data types in SQL

What Are Data Types? Each column must be assigned a data type, such as: Data TypeDescriptionUsage Example in a Table CHARstring(0-255), can store characters of fixed length. Eg: Alice, all 50 is reserved here. Extra memory is wasted after stor...

0

#sqlserver

Search Hashnode

#sqlserver

Explore Hashnode

Trending tags this week

Publishing Powershell Azure SQL VM Toolkit

Database Design Guidelines: Naming & Data Types

SQL Server Internals: Storage Engine and Data Consistency

SQL Server Ledger Tables

Speed Up Reads with Buffer Pool Extension (BPE) in SQL Server 2022 on Window Server 2025 Complete Working Example

Connect AWS RDS Custom for Oracle to SQL Server

Why SQL Change Management is Critical in Regulated Industries

A Step-by-Step Guide to Integrating SQL Server with Java on Windows

Demystifying IF Statements in DAX: How DAX Evaluates Logic

🚀 Day 6: Data types in SQL