MSSQL
Microsoft SQL Server (MSSQL) is a widely used relational database management system designed for reliable, high-performance data storage, access and analytics. MSSQL plays a critical role in managing structured data across industries.
Orchestrate MSSQL with precision
Whether you’re running queries, monitoring table events or reacting to real-time data changes, Tidal builds your MSSQL jobs into a unified scheduling environment.
Automate SQL jobs
Schedule and run MSSQL queries in enterprise-wide workflows.
Monitor database events
Trigger workflows based on table, index or row-level changes.
Streamline operations
Coordinate MSSQL activity alongside other applications.
Powerful SQL automation, built for scale
Tidal’s MSSQL adapter enables you to automate, schedule and monitor SQL Server tasks across supported versions of Microsoft SQL Server. From executing stored procedures and SQL queries to reacting to real-time changes in your database, this adapter brings full workload automation capabilities to your SQL environment.
What the adapter enables
The MSSQL adapter for Tidal allows you to:
- Create, schedule and run Microsoft SQL queries and adapter jobs through Tidal
- Monitor database-level events, including table, index and row creation, modification and deletion
- Automate workflows triggered by changes in your SQL Server environment
- Run adapter jobs on any platform supported by the Tidal Master
How it works
The MSSQL adapter interacts directly with supported SQL Server instances to execute jobs and monitor activity. When an adapter job is triggered, Tidal sends the appropriate SQL commands to the database, tracks execution and collects status and output.
Controlling adapter jobs
Tidal’s scheduler provides full control over MSSQL jobs, including:
- Holding, resuming or aborting jobs
- Rerunning or modifying individual job instances
- Deleting jobs before they’ve run
- Making one-time changes to a specific adapter job instance
Working with Microsoft SQL events
You can configure Tidal to monitor for specific database events in SQL Server, including:
- Table creation, modification or deletion
- Index changes
- Row-level insertions, updates or deletions
These events can trigger workflows or downstream processing tasks, enabling responsive, event-driven automation.
Support your mission-critical jobs and processes
Automate and orchestrate across your unique environments and systems.
Tidal and MSSQL integration FAQs
-
What is Microsoft SQL Server used for?
Microsoft SQL Server is a relational database management system (RDBMS) used to store, retrieve and manage structured data in applications ranging from websites to enterprise systems. It’s commonly deployed in enterprise environments for handling everything from transactional processing (OLTP) to business intelligence (OLAP), data warehousing and reporting.
SQL Server integrates tightly with other Microsoft services, supports high availability and includes features such as stored procedures, views, triggers and robust security.
-
What is MSSQL vs SQL?
SQL is the language used to query and manipulate relational databases, and it’s supported by many database systems. MSSQL refers to Microsoft SQL Server, a specific implementation of Structured Query Language (SQL). While it uses SQL as its core language, MSSQL includes proprietary extensions and tools that distinguish it from other platforms.
SQL is the language, and MSSQL is a full-featured database product that uses SQL and expanded on it with Microsoft-specific functionality.