How to view documents using Visual Studio

View documents in Visual Studio with an amazing tool

Xpath Axes

A very useful trick for automation

Review: Spire.DataExport for .NET

A great tool for exporting data in .NET

How to install Arch Linux, step by step, for VMware Workstation (Part I)

First part of a installation tutorial for this beloved OS

How to setup a local repository in Ubuntu

The steps to have a local repo in Ubuntu

Sunday, November 13, 2016

Microsoft exam 70-466 free material





The 70-466 exam is the hardest exam for many people because your skills in MDX and DAX are tested.

MDX is a very complex multidimensional query language. There are few experts on that language. DAX tries to be easier and it tries to be similar to Excel, but when the query is complex DAX can be very tricky.

Optimizing the performance is also a really hard task because it can be a problem in hardware, design or just the query. There are many aspects to verify to improve it.

The easiest section is Reporting Services. It is easy to learn and configure.

Another topic is Tabular Databases. Microsoft is now offering a new Database model alternative to the traditional multidimensional.  Tabular uses DAX, but the topic in general is not so hard to understand and learn.

There is no Microsoft Training Kit book for this exam and the MVA course is not enough to pass the exam.

However, there is a nice free exam to practice here:

http://www.boson.com/bee-webdemo/selectwebdemo.aspx?d=MIC-ES-70466-01

There is also a paid version of the simulator exam that includes 150 questions, answers including useful references for the exam:

http://www.boson.com/practice-exam/70-466-implementing-data-models-reports-microsoft-sql-server?r=1

You need to press add to cart to purchase the simulator exam.


Thursday, November 3, 2016

Performance testing with JMeter: My first Test Plan


A good performance is one of the main goals of any software projects. Taking that into account, chances are that you'll eventually end up doing some performance testing. For web pages, this is critical. If an online application have performance problems, this will have an important impact on the user experience.

So, in this article I'll show how to create a basic test case with JMeter, a performance testing tool by Apache.

Requirements:
Install Apache JMeter

1. Extract the .zip or .tgz file. I extracted mine to C:\jmeter.
JMeter path

2. Go to that path and you should see the apache-jmeter-3.0 folder.

Running your first test script

1. Open the JMeter path > bin.
2. Double click jmeter.bat. The JMeter UI will be displayed.
JMeter dashboard
3. Each test plan (which is a a series of steps JMeter will execute when run) can be saved as a .jmx file. So, for this first example, we can use one of the sample scripts that come with JMeter. So, go to File > Open.
4. Double click 'examples' and select CSVSample.jmx.
File selection
5. Click 'Open'. The file will be loaded in the left pane of the dashboard.
Loaded sample
6. Finally, to run this script, press Start.
Start script
7. You won't see much happening, but click 'View Results in Table' and you'll see the test results:
Results in table

Creating a test plan

Now we will create our own test plan. This will be a simple plan, just to show you how you can construct more complex Test Plans once you got familiarized with JMeter.

1. Click 'New'.

2. If you don't want to save the current items, click No.
3. Enter a name for the test plan. I'll call mine 'Testools Test Plan'


4. Right click Testools Test Plan > Add > Threads (users) > Thread Group.
5. Right click Thread Group > Add > Sampler > HTTP Request. This will add an element that will allow us to do a GET request to a page:

6. In 'Server Name or IP' enter www.testools.net. We will do a simple GET request to the Testools page in this step.
HTTP request configuration
7. Now we need to add a listener. This will catch the results and display them. Right click Thread Group > Add > Listener > View Results Tree.
8. Save the Test Plan. To do that, go to File > Save. Select a folder and enter a name for the file. In this case, I'll call it TestoolsTestFile.jmx, and I'll save it at C:\jmeterScripts. Then click Save.
Test Plan Script
9. Press Start.
10. The test won't take long. Notice that a new item was created in 'View Results Tree', in the left pane. Click it to see the details:
Results

And that's it! You can add more elements to the Thread Group to achieve your testing goals. In future articles I'll cover more of the functionality of JMeter, but this should be enough to get you started.