APEXSQL BLOG LABELS
PRODUCT SPECIFIC
LINKS
MOST RECENT
Product Update Alert - ApexSQL Clean 2005.09.0127
Product Update Alert - ApexSQL Clean 2005.08.0126
Database Maintenance through ApexSQL Clean
Review of Apex SQL Clean posted
Product Update Alert - ApexSQL Clean 2005.07.0122
Product Update Alert - ApexSQL Clean 2005.05
ApexSQL Clean/Dep Viewer Design Jam Session
Apex SQL Clean 2005.02 - Product Update Alert (Maint/Fix)
Apex SQL Clean 2005 - Product Update Alert
|
Apex SQL Tools Blog Product announcements, promotions, discussions, and other ApexSQL Tools news Product Update Alert - ApexSQL Clean 2005.09.0127 A Minor Fix version of ApexSQL Clean 2005.09.0127 has been released. Use the following link for downloading. Here are the complete release notes for the new version. Auto-updater should work for this version. Product Update Alerts will be posted on this blog. For automatic notification pls subscribe to RSS Feed. The product will also automatically check for and notify users of new versions (as well as allow for automatic update via the application interface). Labels: ApexSQL Clean ...Product Update Alert - ApexSQL Clean 2005.08.0126 A Medium Fix version of ApexSQL Clean 2005.08.0126 has been released. Use the following link for downloading. Here are the complete release notes for the new version. Auto-updater will work for this version. Product Update Alerts will be posted on this blog. For automatic notification pls subscribe to RSS Feed. The product will also automatically check for and notify users of new versions (as well as allow for automatic update via the application interface). Labels: ApexSQL Clean ...Tell Us What You Want--Most The next big releases of ApexSQL tools are in the works--and we want your opinion! Visit any of the following surveys to share your ideas on what features you’d like to see MOST in the next versions of our products. ApexSQL Audit ApexSQL Clean ApexSQL Code ApexSQL Diff ApexSQL Doc ApexSQL Log ApexSQL Report ApexSQL Script Get your developers the tools they need to do the job fast and right - ApexSQL Developer Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: Announcement, ApexSQL Audit, ApexSQL Clean, ApexSQL Code, ApexSQL Diff, ApexSQL Doc, ApexSQL Log, ApexSQL Report, ApexSQL Script, Road Map ...Database Maintenance through ApexSQL Clean A new review has been posted for ApexSQL Clean here. Get your developers the tools they need to do the job fast and right - ApexSQL Developer Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...Review of Apex SQL Clean posted New Review of Apex SQL Clean posted Labels: ApexSQL Clean ...Product Update Alert - ApexSQL Clean 2005.07.0122 A Minor Fix/Feature version of ApexSQL Clean 2005.07.0122 has been released. Pls see link for release notes. Auto-updater should work here for the previous release. However it may not work for the older versions. This release requires .net 2.0 run time distributable. Product Update Alerts will be posted on this blog. For automatic notification pls subscribe to RSS Feed. The product will also automatically check for and notify users of new versions (as well as allow for automatic update via the application interface). Labels: ApexSQL Clean ...Product Update Alert - ApexSQL Clean 2005.05 A MAJOR new version of ApexSQL Clean has been released. Pls see link for release notes and/or Product Page for updated screen gallery. Labels: ApexSQL Clean ...ApexSQL Clean/Dep Viewer Design Jam Session We've got a ton of feedback from our BUnit Crew of ApexClean Beta Testers and part time Design Gurus ... here are the conclusions from this Blue Ribbon Panel of Software Experts Everyone is in agreement that a stand alone design viewer (although cool looking) is largely useless to accomplish any real tasks or actually provide value (hmm.. there's a concept). The power of the product will be how several value added features are integrated from linear presentation, to dependency browsing (grid/linear) and visually, to Risk Free delete to actually accomplish something useful to sql developers. (later db level find/replace and impact analysis) to complete this first phase of integrating Dep Viewer into core ApexSQL Clean app. so that it will add some real value here are the central tenets. 1) Scalpel vs. Shotgun: Dep Viewer should be single object and subset focused vs. steering user to automatically view entire db (although this will still be offered). Entire DB view is performance intensive and visually untenable at larger dbs - is graphic of 30,000 tables possible for human eye to even analyze? The preferred path is to improve and encourage use of schema explorer (we plan to add free grouping of columns). we already offer column level sorting, object type grouping.  and then offer 3 options view deps for this object view deps for all selected object view deps for DB 2) Don't hide my filter: if Dep viewer IS used at the entire DB level - object filter should be more apparent. all the default options scream "don't use us!". AND they should inherit object selections from linear view. the addition of object browser in the dep viewer also makes it much more useful if you happen to come in with a lot of objects and want to drill down to a subset  3) Select This: Object selections in linear view are useful to delete objects only. This restriction should be eliminated so they can be used for a) drops b) reports and exports c) dep viewer 4) Dependency Level What?: Dependency levels are confusing at the entire DB level. At the single object level concepts of "Parents and Children" (see below)  vs. "Children Only"  is apparent. But when all objects are shown the concept becomes confusing and irrelevant. All objects are going to be shown anyway since they were selected. But as soon as one object is deselected then the concept could become relevant, if it was a Child object and not a Parent object for example. In this case toggling these objects would have some effect 5) Follow ApexSQL Edit : We need to add the drill down capability that exists in ApexSQL Edit. This is a pretty cool idea Ashton came up with to take a large diagram and drill down to one object. In this context, dependency level becomes relevant. Since you might want to see All descendants of a particular object or it's Children only (or other options) 6) Grid is too Dead : The liner presentation is great - particularly with column level dependencies added but it doesn't lend itself to interactivity. To "browse" one MUST use the dep viewer. Instead we need to add callback to the Parent and Children grids at bottom. So double clicking them will select that object in top level drill. This is Drill "Up". Also we need to add the Dependency Treeview in Dep Viewer to Main grid  Please feel free to post additional feedback on the ApexSQL Clean forum. Look for a new version of the beta with many of these changes implemented shortly. Once the dep viewer functionality solidifies we look to add more 1) Impact Analysis and 2) Database level Find and Replace. Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...Apex SQL Clean Blog Index This is index for all Blog posts about Apex SQL Clean (more links will be posted here)test New ApexSQL Clean review posted ApexSQL Clean/Dep Viewer Design Jam Session Betas, Betas Everywhere! SQL Server 2005 Still has a Dependency Problem SQL Dependency Parser Update ApexSQL Clean 2005 - Dependency Viewer Update to Dependency Viewer (Video) Cross Database Dependencies Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...Apex SQL Clean 2005.02 - Product Update Alert (Maint/Fix) We have released a Maint release for Apex SQL Clean. It fixes some run-time errors and drammatically improves speed of the Dependency Viewer Next Scheduled release is a major new feature release scheduled for early May ---------------------------------------------------- RELEASE 2005.02.0110 DATE: 17 April 2006 DESCRIPTION: Medium Fix Release ---------------------------------------------------- Fixes: - saving images in dependency viewer - performance of loading dependency viewer - Stack Empty exception thrown in structure mode at db parsing stage - NotImplementedException thrown in structure mode at db parsing stage - Exception thrown for dbs having $ sign in object names in structure mode at db parsing stage Product Update Alerts will be posted on this blog. For automatic notification pls subscribe to RSS Feed. The product will also automatically check for and notify users of new versions (as well as allow for automatic update via the application interface) Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...Apex SQL Clean 2005 - Product Update Alert Apex SQL Clean 2005 has been released - SQL Server 2005 support - Visual Dependency Viewer - New proprietary dependency parsing engine (replaces dependency on sysdepends) - Totally rewritten UI, projects introduced ---------------------------------------------------- RELEASE 2005.01.0109 DATE: 15 March 2005 DESCRIPTION: Major Enhancement ---------------------------------------------------- Enhancement: - added opportunity to see dependences in graphical representation(Dependency Viewer). Where each object is submitted by a figure, and dependence a line between objects / figures. Before display of dependences the opportunity to choose required objects(with the help of a wizard). Only for database with 2000 and 2005-compatibility. - Supporting some sql2005 objects: DDL Triggers, Partition Functions, Partition Schemes, Synonyms, Assemblies, Contracts, Event Notifications, Fulltext Catalogs, Message Types, Queues, Routes, Services, Xml Schema Collections. The analysis of dependences occurs between objects of these types and also including objects sql server 2000. Added opportunity to select this objects for analyze as individual as by type. Objects of these types are included in drop script, xml export and html report. - Supporting of Command Line Interface Added switches: /help for print help message /server for choose server name /database for choose database name /user for choose login /password for choose password /output_format for choose output format (sql drop script, xml export, html report) /output_name for choose output filename /project - specified XML project file /argfile - specified XML file with set of arguments with values /selection_profile - specified XML file with information about selected object types and selected objects /file_dir - specified directory for searching files for analyzing dependences in application files /include_subdir option that to allow include subdirectory for pattern search /force option that to allow override existing file of same name /verbose for choose verbose output mode /test option that to allow output parsed options without taking any action - Added option to include transaction handling in generated drop scripts. - Added option to include backup/restore_on_error action in generated drop scripts. - Added option to exclude comments in files and scripts in dependencies search. - Added option to highlight references in Script Shower when viewing scripts/files in Children grid. - Added option Match Whole Word Only to exclude partial matching from dependencies search. - Added opportunity to choose object types for looking in grid via filter toolbar - Using wizard for creating drop script. Wizard contains several steps: Step 1: Choose General Options: include transaction handling, opportunity to select backup action Step 2: Customize script with custom header as well as indicating preference for print statements and header Step 3: Script preview Step 4: Choose output action: show script in editor, save to file or execute directly - Using wizard for creating project. Wizard contains several steps: Step 1: Choose action - New project, Edit project, Open project. Step 2: Choose data source - connection information(server, database, login, password,etc) Step 3: Options. Indicate the comment delimiters associated with the client program for file analysis Step 4: Options. Search settings Step 5: Chose object types and manage sub selections of specific objects via object selection profiles. Opportunity to select types of objects for analysis. Group of steps for choose individual objects. Opportunity to select objects for analysis. Last step: Select files for analyze - Using project paradigm. Project contains connection information, object selections, options of the analysis of dependences, script generation options, etc. - Added opportunity to select objects for drop. Objects get out in the main form of the app. It is possible to choose only not referenced objects. - The analysis of dependences occurs to use of a new method ("Dependency Parser"). In case of occurrence of an error at analysis ddl the "Dependency Parser" of the analysis does not interrupt. In this case the analysis of dependences occurs to use of the text search. - Added opportunity to show script in SQL Server Management Studio Product Update Alerts will be posted on this blog. For automatic notification pls subscribe to RSS Feed. The product will also automatically check for and notify users of new versions (as well as allow for automatic update via the application interface) Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...ApexSQL Clean 2005 - Dependency Viewer ApexSQL Clean 2005 is in final round of testing - I'm the only one holding it up at this point. In the interim here are some scree shots    Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...Cross Database Dependencies I just got the new dependency viewer UI today from Ashton. well actually 5 minutes ago so 0 to Blog we pretty much instantaneous. He's polished up cross database dependency support which I've been after him for. Looks pretty good  This is a feature customers have been asking for in ApexSQL Clean for a long time so I know it's an important feature. We wanted to have this added prior to rollout of the viewer to production.As you can see from the screen capture the View "cross_db_view" references a table in another database with the following SQL: CREATE VIEW dbo.cross_db_view AS SELECT * FROM pubs_test.dbo.titles_2 Our dependency parser picks up the reference and the dependency type "select" although the object itself and owner are currently unknown. Normally with viewer objects u can click on them to travel accross dependencies. In this case the dependency trail runs cold ... or does it? In fact, you will be able to indicate "full server scan" in default options. If there has been no full server scan we might allow 2nd chance at this event - when user begins to travel out of current database. This project has been a team effort with Ashton an Apex Predator in the code consumer food chain. There are levels of custom DDL scripting, custom parsing and then integrating with drawing component to design the viewer. There are a couple other "consumers" of this component in the company who are using Ashton's API to make some cool variants to this - like different shapes for objects and fronting UI forms to Ashton's customization interface to allow users to customize this themselves. I have considered Ashton's suggestion for Pentagram as default shape for "Unknown Object" and have instead suggested a Shamrock. but with customization settings users can pretty much make the viewer look anyway they want. Look for release of this technology imminently - hopefully no more than a couple weeks. Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...SQL Dependency Parser Update Final version of dependency parser is in testing. Here is an updated screen shot  This shot illustrates that dependency type is also displayed DRI, Insert, Update, Select via color, text and tooltip. This parser doesn't depend on SQL Server sysdepends table but we rolled it ourselves. We plan to release this dependency functionality in a few forms accross a couple of different apps. Existing customers will benefit from free upgrades of affected products. ApexSQL Edit customers will benefit from advanced dependency analysis in a couple smaller features. ApexSQL Clean customers will benefit from a single, large dependency analysis module. In the larger implementation there will be an options form with a lot of customizable settings for colors, shapes, show text on relationship or not. In the UI a variety of visual settings can be displayed from Heirarchical, Tree, Circular and Force Layout. shown below  There are also several ways to show relationships 1 - Uses ChildrenOnly on Orders table 2 - Uses Descendents on Orders table 3 - Uses Parents+Children on Orders table 4 - Uses Parents+Desc on Orders table 5 - switches to full DB display Via the UI users will be able to specify what object types to show or not show (tables, procs etc) and also drill down to show only certain individual objects. The parser will be fast, accurrate and fully SQL2005 compliant by Dec timeframe Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean ...Update to Dependency Viewer (Video) We have a video documenting the latest update to dependency viewer that should be rolled out to production shortly as part of ApexSQL Clean and ApexSQL Edit. Click Here to watch the video Running Time: 4:00 Mins File Size: 25.3 MB Posted On: 11/07/05 Get your developers the tools they need to do the job fast and right - ApexSQL Develper Studio is the ultimate combat multiplier for SQL Developers. 7 Best of Class tools - one download, install and discounted price. Click Here for more info. Labels: ApexSQL Clean, ApexSQL Edit ... |
© 2007 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use