Group items tagged

Data governance is an emerging discipline with an evolving definition. The discipline embodies a convergence of data quality, data management, data policies, business process management, and risk management surrounding the handling of data in an organization. Through data governance, organizations are looking to exercise positive control over the processes and methods used by their data stewards and data custodians to handle data.

Data governance tools[edit] Leaders of successful data governance programs declared in December 2006 at the Data Governance Conference in Orlando, Fl, that data governance is between 80 and 95 percent communication.”[6] That stated, it is a given that many of the objectives of a Data Governance program must be accomplished with appropriate tools. Many vendors are now positioning their products as Data Governance tools; due to the different focus areas of various data governance initiatives, any given tool may or may not be appropriate, in addition, many tools that are not marketed as governance tools address governance needs.[7]

tappy provides tools for working with the Test Anything Protocol (TAP) in Python. tappy generates TAP output for your unittest test cases. You can use the TAP output files with a tool like the Jenkins TAP plugin or any other TAP consumer

we promise that your client application which uses the database is a separate work. To facilitate this, the mongodb.org supported drivers (the part you link with your application) are released under Apache license, which is copyleft free.

MongoDB Database Server and Tools¶ Free Software Foundation’s GNU AGPL v3.0. Commercial licenses are also available from 10gen, including free evaluation licenses. Drivers¶ mongodb.org supported drivers: Apache License v2.0. Third parties have created drivers too; licenses will vary there.

QLDoc Sharp is an interactive tool designed to generate the SQL Server 2005/2008 documentation. It allows you to export documentation to CHM format (Microsoft Compiled HTML Help).It is also easy and interactive, which allows multiple database documentation. For more details, please refer to http://www.amitchaudhary.com/. Background Finding the answer to, "Is there any free tool for generating documentation from SQL 2005/2008". Using the Code After running the application, the initial UI looks like below: Three steps required to generate the documentation. Step # 1 In the top section, provide the details about the SQL Server. It includes: Source: Instance Name of the SQL Server 2005/2008  If want to connect with SQL authentication then: User Name: Name of the user whose credentials you want to use Password: Password of the user whose credentials you want to use In case, to connect with Windows authentication then, only check the checkbox   (Integrated Security) and your current Windows credentials would be used to connect with the specified SQL Server Instance. Step # 2 Choose the database name from the Database dropdown list, whose documentation you want to generate and then click on the Fetch button. Meanwhile you can choose/change the File Name of the CHM file which would be generated. And also if required, you then choose to export the metadata/documentation in the XML format too. Step # 3 Click on the Generate button. And locate the CHM file at the path specified. After making the selection the SQLDoc Sharp, the UI should look like: Screen Shots of the Documentation Generated Index

SQLDoc Sharp is an interactive tool designed to generate the SQL Server 2005/2008 documentation.

Python Tools for Visual Studio includes support for discovering, executing and debugging unit tests. This allows you to author your tests and run them without having to switch to a command prompt.

This article will help to choose a proper SQL XML Documentation format for the future and help to convert these comments into Microsoft Help formats with minimal resources.

Microsoft SandCastle Command Line Interface (CLI) Tool used for creating MSDN-style documentation from .NET assemblies and their associated XML comments files. CodePlex SandCastle Help File Builder Graphical User Interface (GUI) for Microsoft SandCastle. Also contains command line based tools to build a help file in an automated fashion.

JSTest is focused on testing JavaScript, and NOT on UI validation. Unlike tools like JsTestDriver etc, JSTest can be run inside the unit testing framework of your choice; specifically MSTest, NUnit, xUnit etc.

JSTest is focused on testing JavaScript, and NOT on UI validation. Unlike tools like JsTestDriver etc, JSTest can be run inside the unit testing framework of your choice; specifically MSTest, NUnit, xUnit etc.

When considering implementing Operational BI solutions, many implementers first think of copying the operational data to an operational data store (ODS), data warehouse or data mart and analysing it there.  They are immediately faced with the problem of how to update the informational environment fast enough to satisfy the timeliness requirement of the users.  As that approaches real-time, traditional ETL tools begin to struggle.  Furthermore, in the case of the data warehouse, the question arises of the level of consistency among these real-time updates and between the updates and the existing content.  The way MongoDB is used points immediately to an alternative, viable approach--go directly against the operational data.

In the case of Operational BI, however, most experience indicates that the queries are usually relatively simple, and closely related to the primary access paths used operationally for the data concerned.

Access clear summary reports which allow you to drill down to screenshots, stack traces and video

Easily integrated with Continuous Delivery tools like TeamCity and Hudson

Facilitates all team usability and avoids silosBuilt for Agile - make your tests easily re-factored and robust to change

Selenium automates browsers. That's it! What you do with that power is entirely up to you. Primarily, it is for automating web applications for testing purposes, but is certainly not limited to just that. Boring web-based administration tasks can (and should!) also be automated as well. Selenium has the support of some of the largest browser vendors who have taken (or are taking) steps to make Selenium a native part of their browser. It is also the core technology in countless other browser automation tools, APIs and frameworks.

Visual Studio Editions' Support for SQL Server Unit Tests The SQL Server unit tests feature, which was added in the December 2012 update of SQL Server Data Tools, allows you to create, modify, and run SQL Server unit tests in Visual Studio 2010 Professional and Visual Studio 2012 Professional and higher editions.

The Team Foundation Build Extensions provide the ability to execute Ant or Maven 2 builds from Team Foundation Server and publish the results of the build along with any associated JUnit test results back to Team Foundation Server. 

Visual Studio 2012 includes the following command-line tools for testing purposes: VSTest.Console.exe You can use the VSTest.Console.exe program to run automated unit and coded UI tests from a command line. VSTest.Console.exe is optimized for performance and is used in place of MSTest.exe in Visual Studio 2012. MSTest.exe You can use the MSTest.exe program to run automated tests in a test assembly from a command line. MSTest is used for load tests and for compatibility with Visual Studio 2010 test projects. MSTest can also be used to view the test results from these test runs, save the results to disk, and save your results to Team Foundation Server. TCM.exe Tcm.exe is a command-line utility that lets you perform the following tasks: Import automated tests into a test plan Run tests that are part of a test plan from the command line View a list of test items and their corresponding IDs to use when you import tests or run tests You can also use tcm.exe to run test cases with associated automation from the command line using a test environment.

1 down vote I have a Jenkins cluster running different kinds of GUI testing, win32, swing, selenium. They are running thousands of tests in unattended manner 24x7

The solution so far is install VNC Server (I am using UltraVNC) as service and make sure it is started during log on.

Auto logon - there is a tool autologon.exe in SysInternalsSuite, run it on your slave

racle SQL Developer Data Modeler provides a model driven approach for database design and generation, implemented by integrated set of models – Logical, Data types, Dimensional, Relational, Data Flow diagrams and Physical models for supported Oracle Databases, Microsoft SQL Server 2000 and 2005

Cube Views metadata

Dimensional Models   Dedicated full featured Dimensional model – star and snowflake schema easily can be built and expressed on detailed and compact diagrams   Dimensions – support for merging (level can belongs to more than one dimension), shared, fact and role playing dimensions   Hierarchies – value based hierarchies (parent-child), and regular and ragged level based hierarchies   Measures – fully, semi and none additive; different aggregation functions on different dimensions ; fact dimension; calculated measures   Query wizard allows Select statements to be generated from the dimensional model   Support for Oracle OLAP. This includes specifics like cube partitioning, sparse dimensions, and compressed measures   Built-in wizards help to define all required object types and view definitions that enable SQL access to dimensional data in Oracle AW (using the OLAP_TABLE interface)   Bidirectional integration with Oracle physical model - Dimensional model can be created using SQL dimension definitions in physical model or the definitions can be created from the dimensional model

SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.

Document a database in a couple of clicks, from within SSMS

you can add further descriptions to your database objects if necessary.