TotallySQL Universal Bundle - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

TotallySQL Universal Bundle by TotallySQL

URLs: totallysql-universal-bundle, totallysql universal bundle, totallysqluniversalbundle, totallysql

A comprehensive range of CLR function libraries and management tools to extend the T-SQL language. TotallySQL Universal Bundle includes all products available from TotallySQL. It includes the Assembly Manager application and all 8 function libraries (SQLDistributions, SQLEngineering, SQLFile, SQLFinancials, SQLMath, SQLRollingStats, SQLStatistics and SQLUtilities). The libraries enable advanced processing to be carried out within the database itself.

TotallySQL Universal Bundle includes:

Assembly Manager is a Windows application for Microsoft SQL database administrators and developers that greatly simplifies the task of managing CLR (Common Language Runtime) assemblies in a live database environment. CLR integration - first released with SQL 2005 - offers a rich, powerful and safe way to extend native SQL functionality that delivers high performance and flexibility compared with conventional scripted T-SQL functions and other objects. However, the native administration capabilities provided within SQL Server Management Studio make it difficult to manage and control significant numbers of CLR-defined objects across multiple databases and servers. Assembly Manager provides a much higher degree of visibility and control - making it very easy to add and remove CLR-defined objects, perform upgrades, maintain consistency between databases, enforce policy, implement and manage security schema, generate change and rollback scripts and so on.

SQLDistributions extends and enhances your T-SQL programming environment by adding full-featured and highly accurate SQL implementations of 28 probability distributions. For each of these distributions the following functions are available: probability density function (pdf) and its inverse; cumulative density function (cdf) & its complement; quantile (inverse cdf) and its complement; hazard function; cumulative hazard function (chf), mean; median; mode; variance; standard deviation; skewness; kurtosis; percentile; percentilerank, flags: symmetric; unimodal; discontinuous (on left or right); strictly increasing / decreasing; inverted, minimum & maximum defined values for x; minimum & maximum supported values for x; minimum & maximum values of pdf, high-performance scalar and table-valued random variate generators (to generate random numbers that are distributed as per the distribution).

SQLEngineering extends and enhances your T-SQL programming environment by adding a suite of 110+ advanced mathematical functions for scientific and engineering use, including: complex numbers with full math library; unit & number base conversions; Bessel functions; elliptical integrals; Legendre, Laguerre & Hermite polynomials; spherical harmonics; error functions and more.

SQLFile extends and enhances your T-SQL programming environment by exposing the full range of .NET Framework file & directory management functions - and adds the ability to directly import and export data, and to compress both binary and text data stored internally in the database. SQLFile functions include: read & write binary, text & delimited files (e.g. CSV); check for, create, move, copy & delete files & directories; encrypt & decrypt files; compress & decompress file images in the database; manage file access & audit rules; check & alter file attributes; get disk information.

SQLFinancials extends and enhances your T-SQL programming environment by adding 50+ powerful new financial functions and aggregates that faithfully replicate and extend all the financial analysis features available in Microsoft Excel. SQLFinancials includes: 29 functions for calculating yields, rates, coupon periods etc. for corporate and government bonds, 7 functions for calculating depreciation on various bases, 15 functions for calculating interest payments, rates, principal payments, durations, present and future values etc. for loans or investments, 3 functions for calculating internal rates of return for a series of cashflows and 2 functions for converting between dollar fractions and decimal values.

SQLMath extends and enhances your T-SQL programming environment by adding sequence generators; matrices; matrix arithmetic; trigonometric & hyperbolic functions; prime numbers; factorials; GCD/LCM; logs, powers exponents & roots; rounding, truncation & modular arithmetic and more.

SQLRollingStats is a solution for SQL Server that extends and enhances your T-SQL programming environment by adding 30+ statistical window functions - allowing the computation of results per row that depend on values in other rows. All functions are capable of taking into account all rows so far processed, or just the last n rows where n is the specified window size. Functions include: sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous, average (mean), variance (sample & population), standard deviation (sample & population), geometric mean, harmonic mean, quadratic mean, median, quartile, inter-quartile range, tri-mean, percentile, percentile rank, exponential average (mean), exponential variance, exponential standard deviation, weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.

SQLStatistics extends and enhances your Transact-SQL programming environment by adding 80+ powerful new functions and aggregates. Functions include a portfolio of tests and metrics of correlation, similarity or dependence between datasets, including chi-squared tests of independence and goodness of fit; covariance metrics; F-tests to compare variances; paired and unpaired Student's-T tests to compare means; Pearson's product moment correlation coefficient and its square; the Fisher transformation; and the Z-test. SQLStatistics also includes a broad range of descriptive statistics including geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of both continuous and discrete data; medians, quartiles, percentiles, percentile rank and absolute rank; skewness and kurtosis; weighted averages, variances, standard deviations and power means; range, mid-range, inter-quartile range, nth largest, nth smallest and more.

SQLUtilities extends and enhances your T-SQL programming environment by adding: 21 date and time related functions, including a table-valued date and time sequence generator; random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion, 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions., 3 useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function and 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.

A comprehensive range of CLR function libraries and management tools to extend the T-SQL language.

Pricing: TotallySQL Universal Bundle - CAL (Client Access License) V1.0 1 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 5 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 10 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 25 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 50 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 1 Year Support & Maintenance 1 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 1 Year Support & Maintenance 5 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 1 Year Support & Maintenance 10 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 1 Year Support & Maintenance 25 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 1 Year Support & Maintenance 50 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 3 Year Support & Maintenance 1 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 3 Year Support & Maintenance 5 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 3 Year Support & Maintenance 10 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 3 Year Support & Maintenance 25 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 3 Year Support & Maintenance 50 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 5 Year Support & Maintenance 1 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 5 Year Support & Maintenance 5 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 5 Year Support & Maintenance 10 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 5 Year Support & Maintenance 25 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) V1.0 with 5 Year Support & Maintenance 50 CAL License, TotallySQL Universal Bundle - CAL (Client Access License) 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, TotallySQL Universal Bundle - CAL (Client Access License) 5 Year Support & Maintenance Re

Evals & Downloads: Read the SQLUtilities help file, Read the Assembly Manager help file, Read the SQLEngineering help file, Read the SQLMath help file, Read the SQLRollingStats help file, Read the SQLFile help file, Read the SQLDistributions help file, Read the SQLFinancials help file, Read the SQLStatistics help file, Read the TotallySQL License Agreement, Download the SQLUtilities V1.0 evaluation on to your computer - Expires After 30 Days, Download the Assembly Manager V1.0.1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLEngineering V1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLMath V1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLRollingStats V1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLFile V1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLDistributions V1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLFinancials V1.0 evaluation on to your computer - Expires After 30 Days, Download the SQLStatistics V1.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component, Application

Component Type: .NET Class, 100% Managed Code

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: TotallySQL Universal Bundle

totally sql

Product Suites Suite bundles bundle

File Handling

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541812-388425 541812-388425 PC-541812-388426 541812-388426 PC-541812-388427 541812-388427 PC-541812-388428 541812-388428 PC-541812-388429 541812-388429 PC-541812-388430 541812-388430 PC-541812-388431 541812-388431 PC-541812-388432 541812-388432 PC-541812-388433 541812-388433 PC-541812-388434 541812-388434 PC-541812-388435 541812-388435 PC-541812-388436 541812-388436 PC-541812-388437 541812-388437 PC-541812-388438 541812-388438 PC-541812-388439 541812-388439 PC-541812-388440 541812-388440 PC-541812-388441 541812-388441 PC-541812-388442 541812-388442 PC-541812-388443 541812-388443 PC-541812-388444 541812-388444 PC-541812-388445 541812-388445 PC-541812-388446 541812-388446 PC-541812-388447 541812-388447 PC-541812-388448 541812-388448 PC-541812-388449 541812-388449 PC-541812-388450 541812-388450 PC-541812-388451 541812-388451 PC-541812-388452 541812-388452 PC-541812-388453 541812-388453 PC-541812-388454 541812-388454 PC-541812-388455 541812-388455 PC-541812-388456 541812-388456 PC-541812-388457 541812-388457 PC-541812-388458 541812-388458 PC-541812-388459 541812-388459 PC-541812-410614 541812-410614 PC-541812-410615 541812-410615 PC-541812-410616 541812-410616 PC-541812-410617 541812-410617 PC-541812-410618 541812-410618 PC-541812-410619 541812-410619 PC-541812-410620 541812-410620 PC-541812-410621 541812-410621 PC-541812-410622 541812-410622 PC-541812-410623 541812-410623 PC-541812-410624 541812-410624 PC-541812-410625 541812-410625 PC-541812-410626 541812-410626 PC-541812-410627 541812-410627 PC-541812-410628 541812-410628 PC-541812-410629 541812-410629 PC-541812-410630 541812-410630 PC-541812-410631 541812-410631 PC-541812-410632 541812-410632 PC-541812-410633 541812-410633 PC-541812-410634 541812-410634 PC-541812-410635 541812-410635 PC-541812-410636 541812-410636 PC-541812-410637 541812-410637 PC-541812-410638 541812-410638 PC-541812-410639 541812-410639 PC-541812-410640 541812-410640 PC-541812-410641 541812-410641 PC-541812-410642 541812-410642 PC-541812-410643 541812-410643 PC-541812-410644 541812-410644 PC-541812-410645 541812-410645 PC-541812-410646 541812-410646 PC-541812-410647 541812-410647 PC-541812-410648 541812-410648