Software Listing of Author : "Totallysql Ltd"
- Assembly Manager
- License: Shareware
- Price: 199


Assembly Manager is a windows application aimed at both SQL CLR developers and SQL DBAs that solves the problems of trying to manage CLR assemblies using just Visual Studio or SSMS. It allows you to see in a tree-structured view all installed CLR assemblies and the objects that they define (functions, stored procedures, aggregates, triggers, types) across multiple servers and databases. Within assemblies you can see all the defined objects whether they are installed in the database or not. You can easily install, remove and configure these objects using drag/drop, cut/copy/paste and menu-based operations. You can copy assemblies between databases and servers, and store collections of assemblies in saved libraries. You can choose which functions to install, change the names and schemas they are installed with, and set parameter...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 7480 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLEngineering
- License: Shareware
- Price: 199


SQLEngineering extends the T-SQL scripting environment to add direct support for technical, engineering and scientific applications at the database layer. Performing data analysis from within the database tends to be much faster and more efficient than transporting the data across the network to a client application, and also allows simpler and cleaner application architectures. The functions can be used within your T-SQL scripts and stored procedures in exactly the same way as built-in T-SQL functions such as EXP, SQRT, POW etc, and are equally as fast even across large datasets. Included in SQLEngineering is a comprehensive implementation of complex number arithmetic including a full set of 53 trigonometric, hyperbolic, logarithmic, exponential and arithmetic functions that support complex, imaginary or real numbers as...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 522 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLFile
- License: Shareware
- Price: 199


SQLFile extends and enhances your T-SQL programming environment by adding a suite of 117 functions to support direct access to the file system from within T-SQL scripts and stored procedures. SQLFile capabilities include: * Easy processing and manipulation of path and file names (this can be done without file system access). * Directory contents listings as table-valued functions or results sets with optional subdirectory recursion and pattern matching. * Testing for existence of files and folders and retrieving attributes, access control settings, file sizes and timestamps. * Copying, moving, replacing, renaming and changing the attributes of files and directories. * Simple import of file contents as binary objects, text files or one-column tables (using a table-valued function). * Simple import and parsing of...
- Publisher: TotallySQL Ltd
- Date Released: 01-06-2011
- Download Size: 182 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLFinancials
- License: Shareware
- Price: 199


SQLFinancials extends the T-SQL scripting environment by adding financial analysis functions similar to those found in the MS Excel analysis toolpack, but which can be used directly within the database. Performing data analysis from within the database tends to be much faster and more efficient than transporting the data across the network to a client application, and also allows simpler and cleaner application architectures. All the financial functions which have an equivalent in Excel are numerically faithful to a very high degree of accuracy, enabling easy migration of Excel-based business operations to a database environment. In addition, however, many of those functions are effective over a broader range of input values than their Excel counterparts, and there are some additional functions not found in Excel. The...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 522 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLMath
- License: Shareware
- Price: 199


SQLMath extends the T-SQL scripting environment so you can perform mathematical operations on your data from within the database itself. This tends to be much faster and more efficient than transporting the data across the network to a client application, and also allows simpler and cleaner application architectures. The functions can be used within your T-SQL scripts and stored procedures in exactly the same way as built-in T-SQL functions such as SUM, MAX, STDEV etc, and are equally as fast even across large datasets. Functions include the following: - 17 additional trigonometric and hyperbolic functions that complement the 8 built-in trigonometric functions in T-SQL. - 12 advanced rounding, truncation and modular arithmetic functions. - A comprehensive implementation of matrices as SQL types and of matrix (and...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 522 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLRollingStats
- License: Shareware
- Price: 199


SQLRollingStats extends the T-SQL scripting environment with 31 windowed or cumulative functions (in which results for each row depend on previous rows) that can be used as regular functions in queries. This allows metrics such as running totals or moving averages to be easily calculated within simple queries - something that has hitherto been a significant challenge in SQL Server. All the functions support windowing (such that only values from the last n rows are included in the input set - where n is the window size), cumulative operation (where all prior values are counted), and tiling (so the accumulation is restarted for each distinct value of a given column). Functions include: - Sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous. - Average (mean), variance (sample &...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 522 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLStatistics
- License: Shareware
- Price: 199


SQLStatistics extends the T-SQL scripting environment so you can carry out statistical tests, calculate metrics and perform analyses on your data from within the database itself. This tends to be much faster and more efficient than transporting the data across the network to a client application, and also allows simpler and cleaner application architectures. The functions can be used within your T-SQL scripts and stored procedures in exactly the same way as built-in T-SQL functions such as SUM, MAX, STDEV etc, and are equally as fast even across large datasets. Functions include the following: - 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...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 522 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
- SQLUtilities
- License: Shareware
- Price: 199


SQLUtilities extends the T-SQL scripting environment by adding 64 new general-purpose functions for text, date/time and numeric processing that can be used directly within queries and stored procedures at the database layer. Date and time functions include table-valued sequence generator functions that can generate 'on-the-fly' date and/or time sequences of any length with any step interval (these can be used directly in joins, for example), random date and/or time generators, various working days calculations that take into account specified weekend days and holidays, and other general date and time arithmetic functions to complement what's already available in SQL. Numeric functions include a table-valued numeric sequence generator that can generate 'on the fly' numeric sequences of any length and interval, a RANDBETWEEN...
- Publisher: TotallySQL Ltd
- Date Released: 03-05-2011
- Download Size: 522 KB
- Download
- Platform: Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64
