Group items tagged

If you want to do test-driven development for databases, SQL Test is the place to start. It lets you write database unit tests in T-SQL and run them in SQL Server Management Studio.

$369 per user

If you want to do test-driven development for databases, SQL Test is the place to start. It lets you write database unit tests in T-SQL and run them in SQL Server Management Studio.

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.

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.

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

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

What is tSQLt? tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt is compatible with SQL Server 2005 (service pack 2 required) and above on all editions.

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

One pretty easy way to include some “built-in” database documentation for your databases (which could be the beginnings of a data dictionary) is to add extended properties on your objects.

Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.

The specification was quickly followed by commercial release of Microsoft OLAP Services 7.0 in 1998 and later by Microsoft Analysis Services.

While it was not an open standard, but rather a Microsoft-owned specification, it was adopted by the wide range of OLAP vendors. This included both vendors on the server side such as Applix, icCube, MicroStrategy, NCR, Oracle Corporation, SAS, SAP, Teradata, Symphony Teleca, and vendors on the client side such as Panorama Software, PowerOLAP, XLCubed, Proclarity, AppSource, Jaspersoft, Cognos, Business Objects, Brio Technology, Crystal Reports, Microsoft Excel, and Microsoft Reporting Services.

P6Spy lets you monitor the JDBC queries by proxying your database driver. In addition to logging the prepared statements, it also logs the sql with parameters in place so you can copy and paste the exact sql into your favourite database client to test the results.

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.

{ _id: ..., public: true, groups: ['group1', 'group2',...], users: ['user1','user2',...], } You could now query for all documents visible to user X if you have a list of groups user X belongs to by querying: db.documents.find( { $or : [ { public : true }, { users : X }, { groups : { $in : [list-of-X's-groups] } } ] } )

SPUnit is (loosely) based on the xUnit family of Unit Test Frameworks. It is intended for testing MS SQL Server stored procedures using actual stored procedures.

TSQLUnit is a testing framework to write tests for applications written in Transact-SQL. It follows the tradition of the "xUnit" framework that is available for almost all programming languages.

Monitoring and Metrics

Automatic Software Patching

Automated Backups

Seamless integration with “Big Data” using PolyBase.

Up to 50x performance gains with the xVelocity updateable columnstore.