What is SQL Server and how does it work - SQL Server 101
Read and learn about the most common SQL Server services running under your OS (operating system). Tibor writes about five SQL Server database types that each perform a specific role. He also provides detailed overviews of each database type and explains data file, table and index architecture, including a deep dive into details such as pages and columns.
Read SQL Server 101 and learn more about SQL Server’s architecture and management basics. This useful guide also covers:
- Working with the SQL Server optimizer and execution plans
- Keeping track of used and free space in your server, and maintaining transaction logs
- Using APIs to manage SQL Server databases and enabling secure SQL Server access for users by assigning roles and permissions
- And more!