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!

Download now!

Your e-mail address is used to communicate with you about your registration, related products and services, and offers from select vendors. Refer to our Privacy Policy for additional information.