 |
The Regular Expressions for MS SQL Server is a set of T-SQL User Defined Functions (UDF) that gives users full power to manipulate string data in SQL queries, stored procedures and Transact-SQL programming. Some of the common challenges that you can solve with the Regular Expressions are:
? Extracting information and data mining;
? Formatting string data;
? Parsing text data into sections;
? Validating user text input; password, e-mail, URL, ect.;
? Replacing values in text to clean or change content.
Features of the product are:
? easy to use;
? great productivity and reliability;
? 100% Unicode;
? 100% compatible with VBScript regular expressions;
? works with (N)CHAR and (N)VARCHAR data;
? 30 days free trail period of the full product version.
regular expressions ms sql server 2000 t-sql vbscript regexp udf user
|
 |
File Utility extended stored procedures adds to T-SQL capabilities of:
* Work with files and directories;
* Read and write files line-by-line or by arbitrary data blocks;
* Export and import BLOB data from the disk files to the table fields of TEXT/NTEXT/IMAGE datatype;
* Work with INI files;
* Format string templates.
write file read file file utils mssql sql server extended stored procedure ods open data services delphi xp xproc
|
 |
Visualize your code with flow charts. Paste in a procedure or a code snippet and Visustin shows its structure. Understand existing code. Review algorithms. Verify correctness of program logic. Document complex procedures. Visustin supports VB, VB.NET, VBA, QuickBASIC and other BASICs, C/C++, C#, Java, JavaScript, Pascal/Delphi, COBOL, Perl, T-SQL, PL/SQL and Ada. No matter what kind of code you need to document, Visustin can reverse engineer its underlying structure. All control flow structures such as conditionals, loops, jumps, premature exits and error handling statements are visualized in an easy-to-understand format. No new languages to learn - your existing code is all you need. If you see a real complex case, print it out as a mosaic and hang it on your wall. Visustin has an automatic layout feature which positions the chart elements for maximum readability. You can also use Visustin to create flow charts for Visio 2002, where you can edit them. Supported save file formats: BMP, JPG, PNG, HTML, Visio 2002, EMF, WMF and PostScript.
flow charts flow graphs diagramming sourcecode to flowchart vb vb-net vba quickbasic c c java
|
 |
DB3NF is a Rapid Web Application Development platform (RAD) designed for fast and easy creation of high performance, maintainable and scalable Web applications of virtually any kind. It also dramatically reduces development and QA time and provides a consistent look and feel throughout the application.
DB3NF consists of six main parts ordered as they appear in the development process:
DB3NF Administration console. It allows creating and maintaining application schema and business rules. It also provides application administration and deployment.
"Schema" database. Schema database structure is fixed and the data is manipulated by the Administration Console. It defines and stores application structure, business rules and basic presentation rules. This database contains a set of deployment stored procedures. They read data from the Schema database and automatically create in the target ("Data") database a third normal form table structure with all necessary tables, primary, check and foreign key constraints, indexes and stored procedures.
"Data" database. This database is created automatically and its structure depends on the application schema.
Stored procedures are created automatically by the "Schema" database procedures. No development work is required to create and modify them when application schema changes. DB3NF component "talks" to the "Data" database exclusively through these optimized stored procedures, which provides for high performance of the DB3NF platform.
DB3NF component. The component is completely generic and integrates seamlessly with both databases. No design work is required after application schema is created and deployed. DB3NF automatically "learns" application schema and rules when application starts. The component employs various caching techniques and is extremely fast and efficient.
The ASP code in DB3NF is very simple and straightforward. It is easy to write and maintain.
asp visual studio sql t-sql database iis session server script vb interdev sql server
|
 |
Session server for Windows has built-in fail-over protection and load balancing which allows use of up to 1000 session servers with an unlimited number of web servers. A session "sticks" to a session server not by IP as in the case of a local director, but based on session ID so that the browser is guaranteed to maintain its session. In practice, since a single session server is capable of maintaining tens of thousands of sessions, the scalability of the web farm is unlimited.
asp visual studio sql t-sql database iis session server script vb interdev
|
 |
SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver.
free sql odbc database db script editor access ms access microsoft access sql server
|
 |
SQLExecMS is a lightweight but powerful tool for Microsoft® SQL Server DBAs and database developers.It supports MS SQL Server 7, 2000 and MSDE. Unique all-in-one interface for management, tuning up, development, deployment and data manipulation. Ultimate tool for MSDE developers and administrators. SQLExecMS doesn't require any additional installation, just 'drop and run', that is why it is almost perfect to be built in to your DB product. SQLExecMS doesn't use DMO or any other ActiveX components, this is one of the reasons why it works much faster than other similar tools. Finally, this application has been created based on long experience of development and of support DB systems.
Llist of features divided by categories:
-for DBA - Monitor active connections, oldest transactions and vital SQL server performance counters;Check utilization of proc cache;Watch locks; Review space used by DB files, tables and indexes; Manage DB file and filegroups;Turn on and off trace flags;Manage scheduled jobs; Change SQL server and database options;Backup and restore databases; Analyze fragmentation of tables; Analyze wait statistics; Manage indexes and analyze the selectivity of an index; Attach/Detach databases; Review error logs of SQL server; Manage extended stored procedures; Manage logins and users;Use bulk insert.
-for Developers-Execute any T-SQL statements;Review estimated execution plan;Find substring in objects DDL; Use SQL history of your sql statements; Use quick reference and assistant; Easily view the table and view data;Manage triggers;Manage indexes;Compare scripts of two databases; Review objects dependencies in tree-like view; Review object properties; Find an object by its ID;Generate SQL script for your DB.
And many other handy features....
ms sql msde t-sql query analyzer enterprise manager sql tool dba unique all-in-one interface
|
 |
Orbital's SQL Decryptor is the first product to decrypt SQL triggers, views, user defined functions and stored procedures in an easy to use Enterprise Manager-like graphical interface. It works quickly to decrypt items in Microsoft® SQL Server 7.0, SQL Server 2000 and MSDE. Orbital's SQL Decryptor allows for easy viewing of decrypted code with T-SQL syntax highlighting and multiple format exportation.
Features Include:
Works with Microsoft® SQL Server 7.0, SQL Server 2000 and all versions of the Microsoft® Database Engine (MSDE). No more loading up multiple programs and having to manipulate different scripts for each server.
Decrypts Objects of any size
Uses Unicode technology during the decryption process which allows for International use.
Simple point-and-click decryption. Does not require any T-SQL scripting knowledge.
Full T-SQL syntax highlighting for faster, easier reading.
Exports decrypted objects to SQL scripts or Rich Text Format (RTF) with syntax highlighting for easy portability and display to others.
Employs intelligent wizard technologies that allow for the decryption of entire databases with just a few simple mouse clicks.
Fully integrated WYSIWYG printing capabilities with T-SQL syntax highlighting.
Reduces time and money spent restoring lost source code to encrypted SQL objects. Never pay another developer to recreate and debug all of your lost SQL source code.
decrypt sql unencrypt decryptor unencryption decryption decode trigger view udf user defined function
|
 |
A graphical overview of your database solution.
*** Don't spend hours trying to understand your database, see it with SQL Diagrams. ***
For the first time you can graphically understand, how your tables, views, SPs, UDFs, triggers and other database objects interact.
Graphically understand, how your tables, views, SPs, UDFs, triggers and other database objects interact, and more. Upcoming are command flow diagrams, data flow diagrams, permissions diagrams, conceptual database model and other features.
Current and upcoming features:
- all relationships and dependencies diagrams - graphically understand, how your tables, views, SPs, UDFs, triggers and other database objects interact
- /upcoming/ command flow diagrams - represents the structure of your code for any T-SQL object (SPs, UDFs, triggers) with UML-like Activity Diagrams
- /upcoming/ data flow diagrams - layout the data flow in your database application by creating a easy to understand diagram
- /upcoming/ permissions diagrams - see the users in your database server and its permissions
- /upcoming/ conceptual database model - how the business world sees your information in the database
- current DBMS support - SQL Server 2000, MSDE 2000
- future DBMS support - SQL Server 2005 (Yukon and Express), 7.0, Oracle, MySQL, PostgreSQL, Sybase and other DBMS solutions
Diagrams - specific features:
- zooming
- overview window
- printing with print preview
- code preview
- automatic diagram layout
- add objects with drag-and-drop
- save diagram in project
- publish diagrams to web (in SVG format) for sharing over an Intranet or Internet
User interface features:
- friendly, hi-color GUI
- VS.NET-like tabbed interface
- docking toolbars
- docking tool windows
sql server diagrams sql diagrams sql diagramming sql server diagramming sql server diagrams sysdepends diagram dont spend hours
|
 |
Team Remote Debugger is a new revolutionary distributed application development tool, which allows you and your team to trace any number of code units of any kind ( ASP, MTS, T-SQL, COM+, ActiveX Exe, DLL, COM, Thread, CFML ), written in any language ( ASP, VB, VC++, Delphi, T-SQL, VJ, CFML ) residing on multiple shared and dedicated servers at the same time, without ever attaching to process!
For more information and to test-drive Team Remote Debugger check out:
http://www.RemoteDebugger.com/team_remote_debugger.asp
debugger asp debugger debug asp mts com com plus t-sql vb vc ms
|
|
|
