With this tool you can load test any SQL Database hitting a given procedure, with test data from a csv. Some of the salient features are given below. When used with Query Store it can help resolve multiple SQL Performance and Bottleneck issues

  • Can hit any SQL Database.
  • Dynamic connection check before execution.
  • Ability to read test data from CSV (details below)
  • Ability to fetch store procedures from database dynamically.
  • Support MARS, and both Integrated Security and uid/pw options.
  • Provide overall metrics viz: Execution Time, Max, Min
  • Provide metrics per execution which can be logged to a file for further analysis.
  • Provide detailed logging.
  • Automatic Handling for multiple resultsets returned.

Download Link provided at the end of post. If you want to cut the long story short, watch the video ab bottom of this page.

Background

I have been looking in the the QuertStore as provided by the SQL 2016 in all features. So I fired up my SQL Azure db and cracked in code, but i could not see any data in there. First thing i tried out, was to run some queries manually, but no luck. On further analysis get to know that you need to have some significant amount of queries executed for it to give some result. For this i got the idea to build this tool.

Continue reading

 

BitCoins have been there since around 2009-2010, but, when the recent Ransomware WannaCry hit, people get to know about it and it reached a boom instantly. The prices have almost upped 3 Times in last 2-3 months, and the trend is expected to continue.

I have been compleetly off, because of some personal emergencies, and after a long time putting this video in multi video series is intended to provide users who are completely new with a basic understanding of what bitcoins are and how they work.

Also more to come in next videos is how to buy, sell, trade, create offline wallets and more. So remain connected to get more , learn more.

INFO: Please note the audio is little bad due to my mic not working and forced to use system mic.

Checkout the new MongoDbConfiguration Provider for ASP5. https://www.nuget.org/packages/MongoDb.Asp.ConfigurationProvider/ with support for blank and null keys.

Install-Package MongoDb.Asp.ConfigurationProvider

Usage: Use the single line config to load the configuration:

builder.AddMongoDbConfiguration(“mongodb://localhost”,”ConfigDatabase”,”SettingsCollection”,”SettingType”, “SettingValue”);

 

A brief blog post on implementation and open source GIT Path shall soon follow.

Azure Application Insights provides a detailed Telemetry about the Application during its lifecycle. It can manage all details for application from Exceptions to CPU and Performance Counters.the level of Instrumentation is completely customizable.

In this Podcast, we plan to have a base understanding, with a short demo including the setup and and configurable alerts.

Please ignore the little not so good sound quality issues because of bad mic. will try to fix in next podcast.

Recently started with TypeScript with Visual Studio for the AngularJs and landed into a deep problem. The problem was that i was on a blank solution/project with no changes, and still there was a build error. The transition was assumed to be ok, but it didn’t turned out. So here  are the steps I did:

  1. Create a new MVC project in Visual Studio 2015. Added references for Angular using the PM Console.
    Command: install-package angularjs

    PM> install-package angularjs
    Attempting to gather dependencies information for package 'angularjs.1.5.0' with respect to project 'AngularTestTypeScript', targeting '.NETFramework,Version=v4.5.2'
    Attempting to resolve dependencies for package 'angularjs.1.5.0' with DependencyBehavior 'Lowest'
    Resolving actions to install package 'angularjs.1.5.0'
    Resolved actions to install package 'angularjs.1.5.0'
    Adding package 'angularjs.1.5.0' to folder 'c:\users\vineetyadav\documents\visual studio 2015\Projects\AngularTestTypeScript\packages'
    Added package 'angularjs.1.5.0' to folder 'c:\users\vineetyadav\documents\visual studio 2015\Projects\AngularTestTypeScript\packages'
    Added package 'angularjs.1.5.0' to 'packages.config'
    Successfully installed 'angularjs 1.5.0' to AngularTestTypeScript
  2. At this point solution should compile well.
  3. Install the DefinitrlyTyped typings for TypeScript for angularjs from PM Console.
    Command: install-package angularjs.typescript.definitelytyped

    PM> install-package angularjs.typescript.definitelytyped
    Attempting to gather dependencies information for package 'angularjs.typescript.definitelytyped.5.4.0' with respect to project 'AngularTestTypeScript', targeting '.NETFramework,Version=v4.5.2'
    Attempting to resolve dependencies for package 'angularjs.typescript.definitelytyped.5.4.0' with DependencyBehavior 'Lowest'
    Resolving actions to install package 'angularjs.typescript.definitelytyped.5.4.0'
    Resolved actions to install package 'angularjs.typescript.definitelytyped.5.4.0'
    Adding package 'jquery.TypeScript.DefinitelyTyped.0.0.1' to folder 'c:\users\vineetyadav\documents\visual studio 2015\Projects\AngularTestTypeScript\packages'
    Added package 'jquery.TypeScript.DefinitelyTyped.0.0.1' to folder 'c:\users\vineetyadav\documents\visual studio 2015\Projects\AngularTestTypeScript\packages'
    Added package 'jquery.TypeScript.DefinitelyTyped.0.0.1' to 'packages.config'
    Successfully installed 'jquery.TypeScript.DefinitelyTyped 0.0.1' to AngularTestTypeScript
    Adding package 'angularjs.TypeScript.DefinitelyTyped.5.4.0' to folder 'c:\users\vineetyadav\documents\visual studio 2015\Projects\AngularTestTypeScript\packages'
    Added package 'angularjs.TypeScript.DefinitelyTyped.5.4.0' to folder 'c:\users\vineetyadav\documents\visual studio 2015\Projects\AngularTestTypeScript\packages'
    Added package 'angularjs.TypeScript.DefinitelyTyped.5.4.0' to 'packages.config'
    Successfully installed 'angularjs.TypeScript.DefinitelyTyped 5.4.0' to AngularTestTypeScript
  4. Once installed, the solution should still compile ok, because as of now there is no TS file in the solution that should be compiled.
  5. Add a .ts file to the project and add a simple function. This would initiate the TSC to come in picture and compile ts bindings.
    function doSum(a, b) {
        return a + b;
    }
  6. Now building the solution gives a whole lot of compiler errors and compiler fails. The main errors are TS2304, TS2411, TS2320, . I get around 482 of such errors. The error loig from visual studio is attached below:Continue reading

The Problem

Managing the configuration data have always been troublsome. Although Microsoft did provided and also updated/upgraded a lot of options from time to time, yet it remains  a challenge most of time. Things get more critical when the configuration data we are concerned is the confidential data like connection string, smtp passwords, API keys etc becase at some point of time, they do get checked in source code or shared across other developers. In one of my prev project faced a similar issue when private key and the Code Signing certificate was accidentally checked in by a developer. The customer had to revoke the certificate which invalidated all the production builds which were deployed to end users as well.

The Solution: ConfigurationBuilder()

With ASP.net there are some pretty cool enhancements that Microsoft added especially with the Configuration Builder. Earlier whole of .net relied on System.Configuration Namespace to get the configuration data. With the current version it has been greatly re-architeced which now provides a simple key value pair from multiple sources prebuild or even custom providers (like azure or mongoDb) which we shall try out in next post.

Continue reading

By the end of First project we already have a WebApi Self Hosted in Windows Service, but on HTTP. In this post i shall try to add a SSL layer over the top if it to provide additional transport layer security. Things are much easier with IIS, which provides default and simple settings and configurations for all settings like SSL or others.But moving things out of there can be a little tricky. Also, in this post, we shall not be using the developer certificate generated by the IIS, but an actual one issue by CA. For this we shall first register an CA Certificate and then SSL. So let’s roll.

The Tools

We shall be using the following tools provided by Microsoft that can be accessed from developer command line tools.

  • makecert
  • pvk2pfx
  • netsh (provided by windows)

PS: If you can get a proper SSL Certificate from a commercial CA, you can directly move here.

Creating the CA

All the certificates are issue by Certifying Authority or a CA. So for creating an CA, fire up the “Visual Studio Command Line Tools” and run as administrator. I would recommend create a new folder and browse to that so that things dont mix up.

Type in the following command to generate a new CA certificate.

Continue reading