More power for your SQL Server with CLR

What is Power CLR?

Power CLR is a library of over 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 later in all editions, including Express and Azure SQL Managed Instance.

Key features

• Files: text, CSV, Excel, binary, ZIP
• HTTP REST: GET, POST, PUT, DELETE and other verbs from T-SQL
• FTP / SFTP: upload, download and listing without leaving the database
• Validation: CPF, CNPJ, State Registration, Email, ZIP code, Phone
• Formatting: strings, dates and numbers
• Encryption: modern algorithms, hashing and digital signatures
• ChatGPT: native integration directly from SQL
• Email: sending without Database Mail, HTML export
• Active Directory: groups, members and permissions
• Analysis Services: metadata, backup, restore, processing
• SQL Agent: list, execute, stop and backup jobs
• Windows: Registry, Event Viewer, Services and Processes

Pricing per instance

Custom features are priced separately.

What we deliver

• 200+ C# functions and procedures published directly to SQL Server
• Read and write text, CSV, Excel and binary files
• HTTP REST calls (GET, POST, PUT, DELETE and others)
• FTP / SFTP operations: upload, download and listing
• Data validation: CPF, CNPJ, State Registration, Email, ZIP code and Phone
• String, date and number formatting
• Advanced encryption and hash generation
• ChatGPT integration directly from SQL
• HTML table export for email
• Email sending without Database Mail
• Active Directory integration (groups, members, permissions)
• Analysis Services: metadata, backup, restore and cube processing
• SQL Server Agent: list, execute, stop and backup jobs
• Windows Registry read/write
• Event Viewer read/write
• Windows Services and Processes listing