Essential Tools to find bugs... before they get to production

Developers now have access to free and inexpensive developer tools that can help find and fix many common application problems. These new APM tools are now an essential part of every developer’s tool set. Show me the tools!

Code Search - Visual Studio Text Editor Extension - v1.1 Update

It's been about a month since I blogged and released the Code Search - Visual Studio Text Editor Extension. The original release of this extension allowed you to use Microsoft's Code Search directly from ...

Sql Server: How do I get the filegroup, data file name, size and path of a database?

-- start with this:SELECT dbfile.name AS DatabaseFileName, dbfile.size/128 AS FileSizeInMB, sysFG.name AS FileGroupName, dbfile.physical_name AS DatabaseFilePath FROM sys.database_files AS dbfile INNER ...

Microsoft Dynamics GP Stuck Batches

In all financial systems, Dynamics GP included, from time-to-time batches will get stuck during posting. I have experienced this problem in every financial system I have supported, and I’ve supported a ...

SharePoint Saturday Charlotte–2017 Edition

Another SharePoint Saturday Charlotte happened yesterday (8/26/2017) and, IMHO, it was a great event. Thank you goes out to all of the speakers, sponsors, and event organizers! A lot of behind the scenes ...

Visual Studio 2017 Version 15.4 Preview

This article is copied from Visual studio blog, It has been removed from the main place. I have no attachment with Microsoft. So Words like "I'm" and "We" are not meant for myself. It's means of OP at ...

SQL Server: Why is it taking so long to take a database offline?

There are probably open sessions on the database you are attempting to bring offline. SQL Server is trying to roll back any existing workloads in-flight for that database. Issue the sp_who2 command from ...

Azure Functions Visual Studio 2017 Development

The development tools and processes for Azure Functions are ever changing. We started out only being able to create a function through the portal which I did a series on. We then got a template in VS2015, ...

SQL Server: How can I get a distinct count(*) with multiple columns?

To get a count(*) of distinct column combinations, do the count(*) over the distinct select statement.Example:SELECT count(*) FROM (SELECT DISTINCT ColumnA, ColumnB, ColumnC FROM YourTable ) x ...

Query Application Insights REST API To Create Custom Notifications

Application Insights is one of those tools that has been around for a number of years now, but is finally getting understood as more companies move to Azure as a cloud solution. It has become an amazing ...

New Visual Studio 2017 Extension - Code Search (VS Text Editor)

It's been quite some time since I've cracked open Visual Studio to create an extension freebie for all my fellow engineers. If you're keeping up with the latest and greatest in the Microsoft Engineering ...

Ok it has been about 7 years since my last post

Ok it has been about 7 years since my last post. I have moved 3 times so far (current one is due family issues). Have worked for almost 2 years with Wal Mart and various part time jobs (I am currently ...

My blog has moved.

You can find my new blog site over here: https://blog.liamwestley.co.uk/

Worrying conclusions of Google's latest analysis of programmatic advertisin

One of the problems that have become one of those issues that generate tensions within the online advertising industry is fraud in advertising, especially where it is purchased programmatically. When an ...

How Game of Thrones measures the emotions to decide what to publish in social networks

HBO is employing feelings-measuring technology to establish the emotional reactions that are generated while viewers watch Game of Thrones as discussed by dissertation writing service.If there is an element ...

Replicating SharePoint Online Lists to SQL Server

We all know that accessing SharePoint data can be challenging, specifically for SharePoint Online implementations. The SharePoint SDK requires advanced software development knowledge, and SharePoint Online ...

Can't Start NiFi from Ambari, How do I spin up NiFi service in Hortonworks sandbox?

If you've followed the instructions to spin-up NiFi from Ambari, however, the service still does not appear to have started up (read: Ambari shows the service as "red" or stopped; the http URL http://sandbox.hortonworks.... ...

How to study effectively?

Psychologist Heddy López Díaz , accompaniment leader - MAIE School of Education of the Minuto de Dios University Corporation (Uniminuto) discussed the most effective study techniques as shared by dissertation ...

mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)

Here is the solution for the error:mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)Solution:Make sure that your password doesn't have special characters and just keep a plain ...

Pi Zero W - Streamer - Gains A Lego Case

So I’ve added a Lego Case To My Music Streamer Its working great. Our boys can wander in with their tablets/phones and just wirelessly play what they like. Music should just be like this. Accessible and ...

Legacy Projects, Technical Debt and NDepend

Unless every project you've worked on has been green field and / or built with no time pressure, you'll have found yourself working on a legacy project at some point. Unwieldy methods, mystery sections ...

SQL Azure as part of availability group, but not really doing any real work

Wouldn't it be nice to have SQL Azure as part of high availability group, but not really doing any real work? I'm looking for a set up of Active/ReadOnly/DR-Azure. So far I have no luck finding information ...

SSMS 17.1 missing features

Just noticed that SSMS 17.1 (current version) does not support drag and drop of a SQL file.  Reverted back to SSMS 17 RC3 and that feature is back.  Going to check on other features.

How Do I Open a Port in Windows 10 (refused connection) ?

If you are seeing the "connection refused" message when attempting to set up a localhost access port, the chances are good that the port is blocked from allowing connections through Windows. To open the ...

WordPress 101 - Plugins!

This blog series covers just a few of the many features of WordPress from a developer's perspective.WordPress 101 - Setup/Configuration!WordPress 101 - Plugins!WordPress 101 - Themes!"WordPress powers ...

Creating a SharePoint DataLake with SQL Server using Enzo Unified

In this blog post I will show how you can easily copy a SharePoint list to a SQL Server table, and keep the data updated one a specific frequency, allowing you to easily create a DataLake for your SharePoint ...

Wordpress change permalinks to Postname cause Page Not Found

When you select postname in permalinks of wordpress admin page, it might not work sometimes.Following are the reasons.* If in the admin permalinks page itself if it shows some message saying "if you have ...

If I Made a New Web App over the Last 12 Years

Have you thought about how you've built web applications in the past and how you want to do it now?Please visit me at http://bit.ly/ifIMadeANewWe... for my reflections ...

Show off your API with a little Swagger...

So you've built yourself a ground-breaking RESTful .NET Web Api that's effectively going to change the world... awesome!You've even sold and marketed the idea to maybe your boss or potential client... ...

The TDLR; on easily managing .NET concurrent asynchronous threads

Ever had the requirement for your code to perform some series of background actions, say to query an API for weather data for various locations, but your provider caps you at having only 2 max concurrent ...

The 10 Commandments of Good SEO Hipster Version

I do not know about you, but to all those who are dedicated to online marketing, do not you think, what ever Google is more like a religion? , A little rather yes, right? And if the Catholics have the ...

Get Custom Fields using Quickbooks SDK

I was attempting to get a custom field that a customer had added to Items.It took me a while to figure out it is simple but obscure and basically just requires adding a child element of OwnerID = 0.Once ...

SSIS project foreach loop editor does not show configuration for ADO or ADO.NET enumerator

UPDATE on 2017-05-31:It seems to be a bug with version 17.1 (build 14.0.61705.170). I uninstalled that version (including some prerequisite and other components from program list), did a repair on Visual ...

Writing a Voice Activated SharePoint Todo List - IoT App on RPi

Ever wanted to write a voice activated system on an IoT device to keep track of your “todo list”, hear your commands being played back, and have the system send you a text message with your todo list when ...

MS SQL - bcp to export varbinary to image file

I don't do much SQL in regular day to day basis but when it comes to it then it gets really exciting. Here is one of the odd days where I wanted to push out a image file from SQL which was sorted as varbinary(MAX) ...

This blog has been moved to https://medium.com/@anirugu

Hello everyone, Good evening ! It’s my pleasure to use this blog to write stuff about technical stuff and things that I do or use in my daily life. This blog have a lot of technical issue in past. It’s ...

What’s New in C# 7.0 Article in Code Magazine

My What’s New in C# 7.0 article in Code Magazine is out now. You can find it online, at: http://www.codemag.com/arti... Or you can download the PDF of the entire issue, at: http://bit.ly/2ppnSCH ...

Getting SQL Server MetaData the EASY Way Using SSMS

So, you are asked to find out which table uses up the most index space in a database. Or how many rows are in a give table. Or any other question about the metadata of the server. Many people will immediately ...

Raspberry Pi Zero W - Media Streamer

So I’ve been wanting to update my media streamer for a while. In our kitchen I have an amp and speakers, and I have a Raspberry Pi One acting as a media streamer, primarily for use with Air Play. It sounds ...

Video Editing PC Build - Ryzen 8-Core Processor

Hello everyone! It's an exciting day. The first shipment of parts has arrived for the new AMD Ryzen 7 1700X Processor Video Editing PC Build! This fresh new shiny piece of technology grabbed my attention ...

MyGet Command Line Authentication for Windows NuGet

When using Windows and the NuGet package manager:

nuget.exe sources Add|Update -Name feedName -UserName user -Password secret

Adopt a SQL orphan

All DBAs have been asked to copy a database from one SQL instance to another. Even if the instances are identical, the relationship (SID) between the logins and table users are broken. Microsoft includes ...

Deleting old AZURE backups with Powershell

As companies begin migrating to AZURE, DBAs are tempted to save terrestrial (non-AZURE) backup files to “the cloud” to leverage the unlimited amount of space that is available. No more alarms in the middle ...

SQL server AlwaysOn Availability Group data latency issue on secondary replicas and synchronous state monitoring

This article explains how data synchronization works on SQL Server AlwaysOn Availability Group and some details about how to use sys.dm_hadr_database_replic... table to check replica states.I borrowed ...

So you want to go Causal Neo4j in Azure? Sure we can do that

So you might have noticed in the Azure market place you can install an HA instance of Neo4j – Awesomeballs! But what about if you want a Causal cluster? Hello Manual Operation! Let’s start with a clean ...

MS Dynamics CRM Adapter now available on Enzo Unified

I am proud to present our first third party adapter created by Aldo Garcia. With this adapter, you can communicate to Microsoft Dynamics CRM Online directly from SQL Server Management Studio, and from ...

Redirect Standard Error to Output using PowerShell

We use LiquiBase for Database change control and Octopus for deployment to downstream environments in our CICD pipeline. Unfortunately, the version of LiquiBase we use writes information messages to standard ...

BizTalk Server best articles

To simplify navigation on the BizTalk articles, I've selected only the best articles. Study Big ThingsBizTalk Internals: Publishers and SubscribersPart 1: Zombie, Instance Subscription and Convoys: DetailsPart ...

Nested Enumerable::Any in C++/CLI (difficult++)

I frequently use the construct in C# (C-Sharp) to cross-reference the contents of two repositories simultaneously with one compound command: IEnumerable<string> arr_strSources = new string[]{"Alpha", ...

How to use Bower to install packages

In VS 2017, you have choice to install ui components by using bower. If you work previously in asp.net mvc project in visual studio you know all we use is nuget to install anything from jQuery to Newtonsoft.json. ...