Group items tagged

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.

Microsoft Compiled HTML Help is a Microsoft proprietary online help format, consisting of a collection of HTML pages, an index and other navigation tools. The files are compressed and deployed in a binary format with the extension .CHM, for Compiled HTML. The format is often used for software documentation.

Requirements Visual Studio Ultimate, Visual Studio Premium, Visual Studio Test Professional

After you have created any of the following types of automated tests by using Visual Studio, you can use Microsoft Test Manager or Visual Studio to run the tests: Unit tests. Coded UI tests. Load tests.

Running automated tests: You can run tests directly from Visual Studio, from Microsoft Test Manager, from Team Foundation Build, or from the command line. You can use mstest.exe to run your automated tests from the command line, or you can use tcm.exe to import your test methods into test cases. You can then run the test cases for specific configurations from the command line and save the results for the appropriate test plan.

Seamless integration with “Big Data” using PolyBase.

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

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.

This topic describes how to install and configure a test controller, and how to configure test agents so that you can run tests in a lab environment using Microsoft Test Manager.

Web performance tests are included in load tests to measure the performance of your web application under the stress of multiple users. You record a web performance test by browsing a website as if you were the end user.

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.

Significant investments were made in Visual Studio 2012 Unit Testing to make it extensible. A number of frameworks and test runners have built adapters for Visual Studio. Peter Provost maintains a list of Plugins here. For Javascript Unit Testing in Visual Studio, Matthew Mannela has released Chutzpah, an open source Javascript Test Runner.  Chutzpah has a test adapter for Visual Studio 2012. With this adapter, you can run QUnit & Jasmine tests in Visual Studio.

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.

You can use the MSTest.exe program to run automated tests in a test assembly from a command line. You can also view the test results from these test runs, save the results to disk, and save your results to Team Foundation Server.You can also use tcm.exe to run test cases with associated automation from the command line using a test environment.

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.

tcm testcase /import /collection:http://<Team Foundation Server Name>:8080/tfs/<team project collection name> /teamproject:DinnerNow /storage:TestProject1.dll /category:"ShoppingCart&SmokeTest" /syncsuite:3

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.