𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 𝗔𝗱𝗺𝗶𝗻𝗶𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻 | 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗖𝗿𝗲𝗮𝘁𝗶𝗼𝗻

-

 🗄️ 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 𝗔𝗱𝗺𝗶𝗻𝗶𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻 | 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗖𝗿𝗲𝗮𝘁𝗶𝗼𝗻


Creating a database in SQL Server looks simple:

"CREATE DATABASE TAZDemo;"

But for a Database analyst or DBA, database creation is much more than running just a command.
Before creating a production database, we need to think about:
🔹 MDF, NDF and LDF files
🔹 Initial data and log file sizing
🔹 Autogrowth configuration
🔹 Fixed MB vs percentage growth
🔹 Data and transaction log placement
🔹 Database owner
🔹 Recovery model
🔹 Storage capacity and future growth
🔹 Backup and recovery requirements

One principle worth remembering:
💡 Autogrowth is a safety mechanism, not a capacity-planning strategy.

In my latest Technical Architects Zone (TAZ) article, I’ve explained database creation step by step using both SSMS and T-SQL, along with practical checks and production considerations.

📖 𝗥𝗲𝗮𝗱 𝘁𝗵𝗲 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗮𝗿𝘁𝗶𝗰𝗹𝗲:
👉 SQL Server administration - Database creation

More practical SQL Server Administration topics coming next.
𝗟𝗲𝗮𝗿𝗻 → 𝗣𝗿𝗮𝗰𝘁𝗶𝗰𝗲 → 𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 → 𝗕𝘂𝗶𝗹𝗱


Author: Ajit Kumar Patnaik
Technical Architects Zone (TAZ)
Practical Solutions | Real-World Experience | Continuous Learning


Comments

Post a Comment

Popular posts from this blog

SQL Server Interview Questions & Answers: 200 Questions from Fundamentals to Architect Level

-
Image
Technical Architects Zone (TAZ) SQL Server Interview Preparation SQL Server Interview Questions & Answers 200 Questions from Fundamentals to Advanced DBA and Architect-Level Scenarios Introduction Preparing for a SQL Server interview is not only about remembering definitions, commands and feature names. As database professionals move into Senior DBA, Technical Lead and Database Architect roles, interviews increasingly focus on how production problems are investigated, how technical decisions are made and how critical database situations are handled. To make interview preparation more practical, Technical Architects Zone provides a structured collection of 200 SQL Server Interview Questions & Answers . The questions progress from core SQL Server fundamentals to advanced production scenarios covering troubleshooting...
Read more

SQL Server Storage Architecture Explained: How SQL Server Stores Data Internally

-
Image
  Introduction Have you ever wondered what happens when you insert a row into a SQL Server table? Where does the data actually go? How does SQL Server find free space? How are indexes stored? Why do DBAs talk about Pages, Extents, GAM, SGAM, PFS, and IAM? Understanding SQL Server Storage Architecture is one of the most important skills for any DBA, Database Architect, or Performance Engineer because almost every performance issue eventually leads back to how data is stored internally. In this article, we will simplify SQL Server's internal storage mechanism using practical examples. Why Storage Architecture Matters Understanding storage internals helps you: ✅ Troubleshoot performance issues ✅ Understand index fragmentation ✅ Optimize large tables ✅ Reduce disk I/O ✅ Improve backup and restore strategies ✅ Analyze space usage ✅ Perform advanced DBA troubleshooting The Foundation: Data Pages SQL Server stores all data in Pages . A Page is the smallest unit of storage. Page Size -...
Read more

SQL Server Performance Troubleshooting: Essential Scripts Every Database personnel or Architect Should Have

-
Image
TECHNICAL ARCHITECTS ZONE SQL Server Performance Troubleshooting A practical collection of SQL Server scripts and diagnostic techniques for investigating CPU, I/O, blocking, waits, memory, TempDB and query-performance issues. Performance issues are among the most common challenges handled by SQL Server DBAs. A typical incident starts with a broad statement such as “the application is slow,” but that statement does not identify whether the underlying problem is blocking, CPU pressure, storage latency, memory pressure, TempDB contention or an inefficient query. Effective troubleshooting begins by collecting evidence from SQL Server before making configuration or application changes. This article provides practical Dynamic Management View queries that can help identify where to begin. TAZ Practical Note Capture evidence ...
Read more