More power to the your SQL Server with CLR

What is Power CLR?

THE Power CLR is a library of more than 200 functions and procedures written in C# and published directly to your SQL Server database. With Power CLR, you extend T-SQL to do things that would normally only be possible with external applications.

Compatibility

Compatible with SQL Server 2005 or higher in all editions, including Express and Azure SQL Managed Instance.

Main features

• Files: text, CSV, Excel, binaries, ZIP
• HTTP REST: GET, POST, PUT, DELETE and other verbs directly from T-SQL
• FTP/SFTP: upload, download and list without leaving the bank
• Validation: CPF, CNPJ, State Registration, Email, Zip Code, Telephone
• Formatting: strings, dates and numbers
• Encryption: modern algorithms, hashing and digital signature
• ChatGPT: native integration straight from SQL
• E-mail: sending without Database Mail, HTML export
• Active Directory: groups, members and permissions
• Analysis Services: metadata, backup, restore, processing
• SQLAgent: list, run, stop and backup jobs
• Windows: Registration, Event Viewer, Services and Processes

Instance pricing

Custom features are quoted separately.

What we deliver

• 200+ C# functions and procedures published directly in SQL Server
• Reading and writing text, CSV, Excel and binary files
• HTTP REST calls (GET, POST, PUT, DELETE and others)
• FTP/SFTP operations: uploading, downloading and listing
• Data validation: CPF, CNPJ, State Registration, Email, ZIP Code and Telephone
• Formatting strings, dates and numbers
• Advanced encryption and hash generation
• Integration with ChatGPT directly from SQL
• Exporting HTML tables to email
• Sending email without Database Mail
• Active Directory integration (groups, members, permissions)
• Analysis Services: metadata, backup, restore and cube processing
• SQL Server Agent: list, run, stop and backup jobs
• Reading and writing the Windows Registry
• Reading and writing in the Event Viewer
• List of Windows Services and Processes