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-2 of 2Resources < 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 Functions, SQL Server
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 Server, SQL Functions, SQL CLR, CLR, Function library
Downloads: 0 | Started: May 20 2011  | Contributors: 1
1.0.2
Jul 12 2011
Updating...
Page view tracker