Search: none
Add a search phrase to search resource page titles and descriptions. Different keywords are ANDed with tags.
 

MSDN Archive

Target and filter your gallery search using the following dynamic dialogues.
1-8 of 8Resources < Previous 1 Next >
Resource Page Name and Description Current Release
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...
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 defaults. You can easily set the target objects and triggering events for both DDL and DML triggers. You can set permission sets for assemblies, and it will automatically set up the required logins to allow EXTERNAL or UNSAFE assemblies on databases without having to set the TRUSTED flag (but you can also toggle this). All changes are queued up into a set of change actions that can be executed straight away or saved for later use (you can see what the effect will be when run before actually committing the changes). All changes, once committed, can be rolled back using sets of rollback actions that can also be saved to files. Alternatively both change actions and rollback actions can be generated as T-SQL scripts which can be run from within Assembly Manager, launched within SSMS or saved to file or clipboard.
Popular tags: CLR, SQL CLR, SQL Server, SQL Functions
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.1.0
Jun 2 2011
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 m...
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 compare means; Pearson's product moment correlation coefficient and its square; the Fisher transformation; and the Z-test. - Descriptive statistics such as geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of 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. - Complete and partial beta and gamma functions and their inverses, complements and derivatives. - Confidence tests using normal and Student's-T distributions. - Functions for linear and exponential regression and extrapolation, forecasting, error estimation, slope and intercept estimation. - Combinations and permutations.
Popular tags: SQL Functions, SQL Server, SQL CLR, CLR, Function library
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 12 2011
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 transpo...
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 vector) arithmetic including 20 matrix-based functions and operations. - 7 table-valued numerical series generators including arithmetic, geometric and harmonic series, alternating harmonic series, the p-series, prime numbers up to 263, and the Fibonacci sequence. - 28 other general functions covering areas such as prime numbers, factorials, greatest common divisors, least common multiples, summation of series, and logs, powers, exponents and roots.
Popular tags: Function library, CLR, SQL CLR, SQL Server, SQL Math functions, SQLCLR
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 15 2011
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...
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 inputs and outputs. Also included are: - Number base conversions between decimal, hexadecimal, binary, octal and base64. - Unit conversions for over 196 different units of measure (including distance, velocity, acceleration, area, volume, mass, density, pressure, flow, energy, power, time, temperature, flux, angle etc). Includes full support for all metric prefixes. - Cylindrical and Spherical Bessel / Neumann functions. - Laguerre, Legendre, Hermite polynomials and Spherical Harmonics. - Elliptical integrals. - Error functions. - Exponential integrals.
Popular tags: Library, SQL Server, SQL CLR, CLR, Complex numbers, Engineering
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 15 2011
SQLDistributions extends the T-SQL scripting environment to by adding support for modelling and analysing probability distributions directly within the database. Performing data analysis from wit...
SQLDistributions extends the T-SQL scripting environment to by adding support for modelling and analysing probability distributions 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. The distributions are all implemented as CLR-based user-defined types, each supporting a broad range of methods for calculating descriptive statistics (mean, median, mode, skewness, kurtosis etc) and other distribution characteristics. Each distribution also provides a random-number generator which uses modified ziggurat methods to enable high-speed, high-volume generation of random variates that fit the distribution profile. Supported distributions include: (Continuous) - Beta - Cauchy - Chi-squared - Exponential - F - Gamma - Gumbel - Inverse chi-squared - Inverse gamma - Laplace - Logistic - Log-normal - Non-central beta - Non-central chi-squared - Non-central F - Non-central T - Normal - Pareto - Rayleigh - T - Triangular - Uniform - Weibull (Discrete) - Bernouilli - Binomial - Hypergeometric - Negative binomial - Poisson
Popular tags: Distributions, Function library, CLR, SQL CLR, SQL Server
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 15 2011
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 data...
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 list of available functions includes: ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYS, COUPDAYSBS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMIPRINC, DAYCOUNT, DAYSINYEAR, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EFFECT, FV, FVSCHEDULE, INTRATE, IPMT, IRR, ISPMT, MDURATION, MIRR, NOMINAL, NPER, NPV, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RATE, RECEIVED, SLN, SYD, TBILLEQ, TBILLYIELD, VDB, XIRR, XNPV, YEARFRAC, YIELD, YIELDDISC, YIELDMAT
Popular tags: SQL Server, SQL CLR, CLR, Function library, Financial Functions, SQLCLR, SQL Financial
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 15 2011
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 que...
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 & 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.
Popular tags: SQLCLR, Moving Average, Running total, Running Totals, CLR, SQL CLR, SQL Server
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 15 2011
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 proced...
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 function similar to the one in MS Excel, and a RANDOM function that does not require seeding between query rows in order to generate distinct random numbers. In addition there are three relative-column reference functions that allow you to eaily retrieve the value of one column from the row in which the maximum value, the minimum value, or a specified value of another column occurs.
Popular tags: SQL Server, SQL CLR, CLR, Function library, Sequence generator, SQLCLR
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 12 2011
Updating...
Page view tracker