Did you know that Microsoft SQL Server is used by 19% of the world’s relational databases as of 2023? It’s the third most popular after Oracle and MySQL1. Also, a 2021 survey showed that over 34% of tech pros use SQL Server in their work1. This shows how trusted SQL Server is as a strong and flexible database system made by Microsoft. It helps businesses of all sizes manage and protect their important data.
This guide will dive deep into SQL Server. We’ll look at its main parts, advanced tools, and how it makes managing data easier for companies. It’s known for its high uptime, 99.995% on average, in both cloud and on-premises setups1. SQL Server is a top pick for businesses needing a dependable and growing database solution.
Key Takeaways
- SQL Server holds a 19% market share, positioning it as the third most popular RDBMS globally.
- Over 34% of tech professionals incorporate SQL Server into their professional stack.
- SQL Server boasts an exceptional 99.995% average uptime, ensuring reliable data management.
- SQL Server’s comprehensive features and robust performance make it a premier choice for enterprises.
- This guide will explore SQL Server’s key components, advanced features, and how it streamlines data management.
Introduction to SQL Server
SQL Server is a key tool for managing data in today’s world. It’s a top choice for businesses and groups. It helps users handle, keep safe, and organize lots of data2.
Powerful Database Management Capabilities
SQL Server is known for its strong features. It’s great for companies needing a dependable way to store and process data. It offers tools for getting data and keeping it safe3.
SQL Server’s Role in Modern Data Management
SQL Server is a leader in managing data. It helps companies use their data well and make smart choices3. It’s chosen for many projects, big and small4.
“SQL Server is a relational database management system that provides businesses with an efficient and secure platform for creating, deploying, and managing critical applications.”
SQL Server Components
SQL Server is a powerful tool for managing data. It has two main parts: the Database Engine and the SQLOS (SQL Server Operating System). The Database Engine takes care of storing, processing, and securing data. SQLOS manages the use of resources like memory, processors, and storage.
Database Engine and SQLOS
The Database Engine is the heart of SQL Server. It handles tasks like making queries faster, executing them, and managing transactions. SQL Server offers tools like Performance Monitor and Task Manager for monitoring server applications.5
SQLOS is key to managing the resources SQL Server uses. It makes sure the system uses memory, CPU, and disk efficiently for the best database performance.
Subsystems, Processes, and Services
SQL Server includes subsystems, processes, and services within the Database Engine and SQLOS. Tools for monitoring include Extended Events and SQL Server Profiler.5
SQL Trace and SQL Server Profiler are no longer used.5 Extended Events save data to files, counters, histograms, and buffers.5 Distributed Replay and SQL Server Profiler can replay trace data.5 Trace templates set the event capture settings.5
SQL Server is vital for businesses and developers needing efficient data management.6 It includes the Database Engine, Management Studio, and more, working together smoothly.6
The Database Engine manages databases and procedures. Management Studio helps create and monitor databases.6 Integration Services handle data from various sources. Analysis Services are for detailed analysis.6 Reporting Services create reports that can be scheduled and shared.6
SQL Server has been around for over 30 years. SQL Server 2019 introduced Big Data clusters.7 SQL Server 2017 supports Linux, and it comes in different editions.7
Microsoft and Sybase launched SQL Server in 1989. SQL Server 2008 brought new services and a master data system.7 SQL Server’s architecture includes the Protocol Layer and the Storage Engine with Primary and Secondary files.7 SQL Server can run independently to save costs.7
Database Engine: The Core Processing Unit
At the heart of SQL Server is the Database Engine. It’s responsible for running queries and managing data storage. This core part has two key parts: the Relational Engine and the Storage Engine8.
Relational Engine and Storage Engine
The Relational Engine is the brain, working on SQL queries. It turns user requests into plans that get data quickly and efficiently. The Storage Engine takes care of where data is stored and how it’s accessed, including things like caching and logs9.
These two engines work together to make SQL Server fast and reliable. The Relational Engine deals with the logical side of data, while the Storage Engine keeps the data safe and easy to get to9.
Query Optimization and Performance Tuning
SQL Server also has tools to make queries run better and faster. The SQL Query Optimizer looks at a query and picks the best plan. It considers things like indexes, data spread, and system resources9.
There are more ways to make SQL Server faster, like using indexes and managing memory. These help make getting and processing data super quick, even when it’s a lot10.
The Database Engine is key to SQL Server’s strength in managing data. It combines the Relational Engine’s smarts with the Storage Engine’s data handling skills8.
“SQL Server’s Database Engine is the core processing unit, seamlessly integrating the Relational Engine and Storage Engine to deliver unparalleled data management capabilities.”
SQLOS: The Foundational Component
At the core of SQL Server’s strength is the SQL Server Operating System (SQLOS). It’s the key part that handles how resources are shared and managed by SQL Server11. SQLOS is especially important for managing memory, which is vital for top performance12.
Memory Management and Buffer Management
SQLOS is key in balancing the need for memory. It makes sure SQL Server uses memory well, meeting the needs of different parts of the database engine12. This includes managing the Buffer Manager, which is in charge of keeping data in memory12.
The Buffer Manager uses smart methods to move data quickly between memory and disk, cutting down on slow disk operations13. This makes SQL Server run better and keeps the database reliable and consistent, by writing transactions safely to disk13.
By handling memory and buffers well, SQLOS helps SQL Server perform well, scale up, and keep data safe. These are key for today’s data-driven needs11. SQLOS makes sure the database engine works at its best, supporting a wide range of applications and scenarios11.
“SQLOS is the unsung hero of SQL Server, providing the robust foundation that enables the database engine to thrive and deliver exceptional performance to businesses of all sizes.”
| SQL Server Edition | Target Audience | Key Features |
|---|---|---|
| Enterprise Edition | Large enterprises | Advanced high availability, data warehousing, and security features |
| Standard Edition | Medium-sized businesses | Less advanced features than Enterprise Edition |
| Developer Edition | Developers | Great for app development and testing, often free or low-cost |
| Express Edition | Developers and small businesses | Has limits on database size and memory, but free |
| Web Edition | Web-centric scenarios | Basic database functions, cheaper than other editions |
SQLOS is the hidden star of SQL Server, giving the database its strong base for success11. It manages memory, buffers, and other key resources well, making SQL Server handle today’s complex data tasks easily12. As the base of SQL Server, SQLOS is crucial for unlocking the full power of this database solution111213.
SQL Server Editions and Features
The SQL Server database system has many editions for different business needs. From the powerful Enterprise edition to the simple Express edition, it has features for all kinds of businesses14.
The Enterprise edition is for big, important projects. It has unlimited virtualization and top datacenter tools. It also has business intelligence solutions14. You can try it for 180 days before fully using it14.
For smaller groups or departments, the Standard edition is a good choice. It has basic tools for managing data and doing business intelligence. The Web edition is made for web hosts. It’s affordable and scalable for web apps14.
The Developer edition has everything the Enterprise edition does, perfect for developers. The Express edition is free for small projects and learning. There’s also Express LocalDB, a quick and easy version for fast setup and coding14.
| Edition | Key Features | Deployment Options |
|---|---|---|
| Enterprise | Unlimited virtualization, high-end datacenter capabilities, end-to-end business intelligence | 180-day evaluation, production deployment |
| Standard | Basic data management and business intelligence | Production deployment |
| Web | Cost-effective scalability and affordability for web hosters | Production deployment |
| Developer | All Enterprise edition features, for development and testing | Development and testing purposes |
| Express | Free, entry-level database for small applications and learning | Production deployment |
| Express LocalDB | Lightweight version of Express edition with fast installation and programmability | Production deployment |
SQL Server also has many tools like the SQL Server Database Engine and SQL Server Management Studio (SSMS). These tools help manage data, configure settings, monitor, and develop. They help businesses use SQL Server fully14.
“SQL Server offers a comprehensive suite of data management and business intelligence solutions, catering to the diverse needs of organizations of all sizes.”
SQL Server Security and Compliance
SQL Server focuses on keeping data safe and secure. It follows the ACID rules to keep data consistent and reliable15. It has strong security tools like user checks, access control, and encryption to protect data from unauthorized access15.
ACID Compliance and Data Integrity
SQL Server sticks to ACID rules to protect data15. It uses encryption and data masking to keep data safe15. Row-Level Security lets users see only their data, making it more secure15. Transparent Data Encryption protects data at rest and in backups15.
SQL Server supports many ways to log in, like Windows and SQL Server accounts15. Audit policies help track sensitive data, making sure it’s secure15.
Improving security means using roles, AD groups, and strong passwords15. Using more than one way to prove who you are and keeping data in history helps keep data safe15.
SQL Server has tools to check security and find ways to protect data better15.
For extra security, keep servers in locked rooms and store backups safely offsite16. Keep your server updated and use firewalls to boost security16.
SQL Server faces threats like SQL injection and unauthorized access17. To fight these, limit what you install, manage accounts well, and use strong network security17.
With SQL Server’s strong security and compliance, companies can protect their data and meet rules15.
SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) is a key tool for data integration and transformation. SSIS helps companies move data from different sources into one place. This includes databases, files, and web services18. It makes managing data easier, helping businesses use their data better for making decisions18.
SSIS started with Microsoft SQL Server 2005, replacing an older tool called Data Transformation Services (DTS)19. Now, it’s part of the “Standard”, “Business Intelligence”, and “Enterprise” editions of SQL Server19.
SSIS has many built-in transformations, like Aggregation and Data conversion19. This means users can work with data without needing to write a lot of code. It also has tools like DTEXEC and DTUTIL for managing packages from the command line19.
SSIS Installation and Configuration
You can install SSIS with or without other SQL Server parts on one computer18. You need to think about hardware and software requirements for a successful setup18. You can install SSIS on a new computer or alongside an existing SQL Server18. Upgrading SSIS keeps the old version too18.
To set up an ETL server, install a local SQL Server Database Engine and Integration Services18. By default, SSIS doesn’t log some events, but you can change this18.
SSIS isn’t in the Express edition but can be added with the Developer Edition18. It comes with extra tools like the SSIS Catalog and Scale Out feature18. You also need SSDT for designing and deploying SSIS packages18.
With the Feature Pack, SSIS can connect to Azure services like Azure Blob Storage and Synapse Analytics18. There are also connectors for Oracle and SAP BW available18.
| SSIS Capability | Description |
|---|---|
| Data Integration | Seamlessly extract, transform, and load (ETL) data from various sources into a centralized data warehouse or other target systems. |
| Data Transformation | Leverage a wide range of built-in transformations to cleanse, standardize, and enrich data for better analysis and decision-making. |
| Data Migration | Efficiently migrate data from legacy systems or databases to modern data platforms, ensuring a smooth transition. |
| Data Warehousing | Facilitate the creation and maintenance of data warehouses, enabling advanced analytics and reporting capabilities. |
SSIS on Cloud SQL needs a host for installation and running, like a Compute Engine VM20. Cloud SQL works well with SSIS without extra setup20. But, SSIS on Cloud SQL has some limits, like not supporting the SSISDB catalog20. You can use a non-Cloud SQL SQL Server instance for SSISDB catalogs20.
“Cloud Data Fusion offers code-free ETL and ELT data pipelines, with a library of over 150 preconfigured connectors and transformations at no extra cost20. Recommendations include including ETL/ELT pipelines in the solution for using with SQL Server to leverage the benefits of Cloud Data Fusion20.”
In summary, SQL Server Integration Services (SSIS) is a powerful tool for data integration. It helps companies manage their data better, from getting it to putting it into centralized places. With its many features, SSIS is key for modern data management, helping businesses make better decisions with their data181920.
SQL Server Analysis Services (SSAS)
At the core of Microsoft’s SQL Server is SQL Server Analysis Services (SSAS). It’s an OLAP engine that helps organizations use their data fully21. SSAS lets users build multidimensional data models. This way, they can look at data from different angles and make better decisions21.
Working with SSAS means making a data model, putting it on a server, and filling it with data21. You can use data warehouses from SQL Server or Oracle for this21. Tabular models work with more data sources21.
SSAS supports various data models like tabular, multidimensional, data mining, and Power Pivot for SharePoint21. This lets organizations pick the best fit for their data and analysis needs. It also works well with their BI tools21.
The SSAS guide is available for different platforms and levels of expertise21. It covers SQL Server Analysis Services, Azure Analysis Services, and Analysis Services in Power BI. This ensures everyone understands this powerful BI tool well21.
Since the 1990s, SSAS has changed the game for big data processing22. It offers fast analytics, flexible analysis, works with other BI tools, and is easy to learn for users22.
However, SSAS has its limits with big data, like heavy processing and storage issues22. Solutions like AtScale offer new ways to do fast, less heavy data analytics for businesses22.
SSAS is key to Microsoft’s Business Intelligence stack, offering OLAP solutions23. It lets users create “cubes” for deep data analysis. These cubes have dimensions and facts for faster insights23.
To make a cube with SSAS, you read data into a model, set up the schema, and add dimensions and measures23. Then, you fine-tune the cube and deploy it23. Users can use MDX to explore and analyze the data, finding insights for better decisions23.
Mastering SSAS boosts an organization’s data analysis and BI skills. It sets them up for success in a data-driven world212223.
“SQL Server Analysis Services (SSAS) has been a game-changer for organizations seeking to unlock the full potential of their data. This powerful OLAP engine enables sophisticated multidimensional analysis, empowering users to uncover insights that drive informed decision-making.”
| Feature | Description |
|---|---|
| Multidimensional Models | SSAS supports the creation of multidimensional data models, allowing for the analysis of data from multiple perspectives. |
| Tabular Models | SSAS also supports tabular data models, which can be leveraged for data analysis and reporting. |
| Data Mining | SSAS provides advanced data mining capabilities, enabling users to uncover hidden patterns and trends in their data. |
| Power Pivot for SharePoint | SSAS integrates with Power Pivot, a self-service BI tool, to provide enhanced data modeling and analysis functionalities within the SharePoint environment. |
In conclusion, SQL Server Analysis Services (SSAS) is a key part of the SQL Server suite. It helps organizations use their data better and make smarter decisions212223.
SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS) is a top-notch reporting tool that helps businesses make and manage reports24. It’s easy to use for creating, making, and sharing reports. SSRS turns data into insights that help make better decisions and share important business info24.
SSRS can send reports in many formats like Excel, PDF, and HTML25. It also works great on mobile devices, making reports easy to view anywhere24. This makes sure people can check reports on different devices easily.
Since SQL Server 2016, SSRS has gotten even better24. It now has a modern web portal that makes finding reports easy24. This portal lets you manage reports like Paginated, KPIs, and Mobile reports in one place24.
SSRS has improved Paginated reports a lot24. Now, you can use new styles and colors, and even send reports to PowerPoint24. Plus, it works well with Power BI, letting you add SSRS reports to your dashboards24.
SSRS also lets you customize and extend its features to fit your needs26. You can manage reports and automate tasks with PowerShell, making reporting easier26.
Overall, SSRS is a powerful tool for business reporting24. It’s easy to use, has great features, and works well with Microsoft tools25. It’s a key tool for businesses to make the most of their data and make smart decisions25.
| Feature | Description |
|---|---|
| Paginated Reports | New styles, color palettes, updated Parameter pane, and ability to export reports to PowerPoint with live, editable visualizations24. |
| Hybrid Power BI/SSRS Experience | Users can pin visuals from SSRS reports to Power BI dashboards, enabling a unified reporting experience24. |
| Mobile Reports | Responsive layouts adaptable to different devices and orientations, based on Datazen technology24. |
| Modern Web Portal | Redesigned and enhanced version of the traditional Report Manager, offering a more intuitive user experience24. |
Want to learn more about SQL Server Reporting Services? Check out these resources:
- Create, Deploy, and Manage Mobile and Paginated
- SQL Server Reporting Services on Wikipedia
- Reporting Services Tools
“SQL Server Reporting Services is a comprehensive reporting platform that empowers organizations to transform their data into actionable insights, enabling informed decision-making and effective communication of key business metrics.”
High Availability and Disaster Recovery
SQL Server has strong features for keeping data available and reliable. It uses failover clustering and database mirroring to reduce downtime. These tools protect important data from sudden problems or disasters.
Failover Clustering and Database Mirroring
Failover clustering moves SQL Server to a backup server if the main one fails27. It ensures high availability at the server level. You can use Azure shared disks, Storage Spaces Direct, Premium file share, and partner clustering tech28. It can also be paired with availability groups for extra protection28.
Database mirroring copies data from a main to a backup database in real-time27. This keeps businesses running smoothly and helps with disaster recovery. If the main database goes down, you can switch to the backup quickly28. You can set it up to mirror data in sync or not, based on how fast you need to recover data27.
SQL Server also has Always On, log shipping, and backup to Azure Blob storage for more protection28. These tools help create a strong plan to keep data safe. This way, businesses can keep running even when things go wrong29.
“Failover clustering and database mirroring are key for a strong SQL Server plan. They help keep businesses running and protect their important data.”
Performance Monitoring and Tuning
Keeping SQL Server applications running smoothly is key. SQL Server has strong tools for monitoring and tuning performance. These tools help find and fix performance issues. They use advanced query optimization and indexing to make data faster to access30.
By always checking and adjusting SQL Server, businesses keep their apps quick and efficient. Even when data grows and more users come, SQL Server has tools to help. These include SQL Server Profiler, Database Engine Tuning Advisor, and Extended Events31.
Query Optimization and Indexing Strategies
Getting queries to run well is crucial for a fast database. SQL Server’s optimizer makes plans that run fast, using parallel processing to speed things up30. Good indexing also makes data quicker to get, which helps users wait less30.
DBAs need to keep an eye on SQL queries and understand what the app and data need30. This helps them spot bad queries, see if indexes are needed, and make smart tuning choices30.
| Metric | Description |
|---|---|
| Response Time | The time it takes to get the first result to the user30. |
| Throughput | How many queries the server can handle in a set time30. |
More users mean more competition for server resources, making things slower and handling fewer queries30. Watching user actions and knowing what the app needs is key to making SQL Server better30.
It’s important to keep an eye on performance as things like user numbers and data size change30. By setting up baselines, finding bottlenecks, and fixing database issues, DBAs can keep SQL Server running smoothly for the business30.
“Watching SQL queries helps figure out if queries or indexes need changes. Good management of network traffic, disk I/O, and CPU usage is key for a fast database.”30
In summary, SQL Server’s strong tools for monitoring and tuning help keep applications fast and efficient. By using advanced query optimization, good indexing, and ongoing performance checks, businesses can keep their data solutions running well303231.
Conclusion
SQL Server is a top choice for managing data in businesses of all sizes33. It has a strong Database Engine and key components like SQLOS. These features make it easy to handle data and find important insights3433.
SQL Server keeps businesses running smoothly with its high availability and strong security33. It also helps make better decisions by keeping data safe and running fast33. As a top database system, SQL Server keeps up with new data trends and helps businesses succeed online35.
SQL Server is great at solving complex problems and handling tough tests34. It works well with many programming languages and business tools33. This makes it a full-featured platform for managing data.
FAQ
What is SQL Server?
SQL Server is a powerful database system made by Microsoft. It helps businesses of all sizes manage and protect their data.
What are the key components of SQL Server?
SQL Server has two main parts: the Database Engine and SQLOS (SQL Server Operating System). The Database Engine handles data storage and security. SQLOS manages the resources SQL Server needs.
What is the role of the Database Engine in SQL Server?
The Database Engine is the main part of SQL Server. It runs queries and manages data storage. It includes the Relational Engine for query analysis and the Storage Engine for data storage.
How does SQLOS contribute to SQL Server’s functionality?
SQLOS manages SQL Server’s resources. It focuses on memory management to balance memory use for the best performance.
What are the different editions of SQL Server?
SQL Server comes in various editions for different business needs. Each edition offers different levels of performance, security, and features.
How does SQL Server ensure data security and compliance?
SQL Server focuses on security and follows the ACID principles for data reliability. It uses user authentication, access control, and encryption to protect data.
What is SQL Server Integration Services (SSIS)?
SSIS is a tool in SQL Server for data integration and transformation. It helps move data from sources to a data warehouse or other systems.
What is SQL Server Analysis Services (SSAS)?
SSAS is an OLAP engine for advanced data analysis in SQL Server. It creates data models for insights and decision-making.
What is SQL Server Reporting Services (SSRS)?
SSRS is a reporting platform for creating and managing reports. It offers tools for designing, generating, and sharing reports with various features.
How does SQL Server ensure high availability and disaster recovery?
SQL Server has features like failover clustering and database mirroring for high availability and disaster recovery. These help keep business running smoothly and protect data.
How does SQL Server optimize performance?
SQL Server has tools for monitoring and improving performance. It uses query optimization and indexing to make data access faster.
Source Links
- What is SQL Server? A Guide to Understanding Database Management – https://clumio.com/rto/what-is-sql-server-a-guide-to-understanding-database-management/
- Tutorials for SQL Server – SQL Server – https://learn.microsoft.com/en-us/sql/sql-server/tutorials-for-sql-server-2016?view=sql-server-ver16
- Introduction to SQL Server – https://www.quackit.com/sql_server/sql_server_2016/tutorial/sql_server_2016_introduction.cfm
- Introduction to SQL Server – https://www.scholarhat.com/tutorial/sqlserver/introduction-to-sql-server
- Monitor SQL Server Components – SQL Server – https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitor-sql-server-components?view=sql-server-ver16
- The Top Components of SQL Server with Definition & Examples – https://www.theknowledgeacademy.com/blog/components-of-sql/
- SQL Server Architecture Explained: What is SQL Server & Its Components? | Simplilearn – https://www.simplilearn.com/what-is-microsoft-sql-server-architecture-article
- Install SQL Server Database Engine – SQL Server – https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-database-engine?view=sql-server-ver16
- How a SQL Database Engine Works – https://medium.com/@grepdennis/how-a-sql-database-engine-works-c67364e5cdfd
- What is Microsoft SQL Server? | Definition from TechTarget – https://www.techtarget.com/searchdatamanagement/definition/SQL-Server
- What is SQL Server? Types, Components & How it Works – https://sitechecker.pro/what-is-sql-server/
- SQL Server Architecture – DatabaseOrg – https://databaseorg.com/knowledgebase/sql-server-architecture/
- How It Works: Bob Dorr’s SQL Server I/O Presentation – https://techcommunity.microsoft.com/t5/sql-server-support-blog/how-it-works-bob-dorr-s-sql-server-i-o-presentation/ba-p/316031
- Editions and supported features of SQL Server 2019 – SQL Server – https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16
- SQL Server security best practices – SQL Server – https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-server-security-best-practices?view=sql-server-ver16
- Securing SQL Server – SQL Server – https://learn.microsoft.com/en-us/sql/relational-databases/security/securing-sql-server?view=sql-server-ver16
- SQL Server Security Best Practices – https://www.netwrix.com/sql-server-security-best-practices.html
- Install SQL Server Integration Services – SQL Server Integration Services (SSIS) – https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16
- SQL Server Integration Services – https://en.wikipedia.org/wiki/SQL_Server_Integration_Services
- SQL Server Integration Services (SSIS) – https://cloud.google.com/sql/docs/sqlserver/ssis
- SQL Server Analysis Services overview – https://learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
- SQL Server Analysis Services (SSAS) – https://www.atscale.com/glossary/what-is-ssas/
- SQL Server Analysis Services (SSAS) Tutorial – https://mssqltips.com/sqlservertutorial/2000/sql-server-analysis-services-ssas-tutorial/
- What is SQL Server Reporting Services? – SQL Server Reporting Services (SSRS) – https://learn.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports?view=sql-server-ver16
- SQL Server Reporting Services – https://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
- Tools available in SQL Server Reporting Services – SQL Server Reporting Services (SSRS) – https://learn.microsoft.com/en-us/sql/reporting-services/tools/reporting-services-tools?view=sql-server-ver16
- Business continuity and database recovery – SQL Server – https://learn.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver16
- High availability, disaster recovery, business continuity – SQL Server on Azure VMs – https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/business-continuity-high-availability-disaster-recovery-hadr-overview?view=azuresql
- SQL Server High Availability and Disaster Recovery Plan – Simple Talk – https://www.red-gate.com/simple-talk/databases/sql-server/learn/sql-server-high-availability-and-disaster-recovery-plan/
- Monitor and Tune for Performance – SQL Server – https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitor-and-tune-for-performance?view=sql-server-ver16
- SQL Server Performance Tuning made simple – https://www.sqlshack.com/sql-server-performance-tuning-made-simple/
- Performance Monitoring and Tuning Tools – SQL Server – https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver16
- Microsoft SQL Server: Everything you need to know – https://datascientest.com/en/microsoft-sql-server-everything-you-need-to-know
- MS SQL Server for logical conclusion | Codementor – https://www.codementor.io/@borisovke/ms-sql-server-for-logical-conclusion-s82ssbnlp
- How bad is opening and closing a SQL connection for several times? What is the exact effect? – https://stackoverflow.com/questions/1404261/how-bad-is-opening-and-closing-a-sql-connection-for-several-times-what-is-the-e