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!

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. ...

SQL Database is in use and cannot restore

USE masterGOALTER DATABASE <mydatabase>SET SINGLE_USER--This rolls back all uncommitted transactions in the db.WITH ROLLBACK IMMEDIATEGORESTORE DATABASE <mydatabase> FILE = N'mydatabase' FROM ...

asp.net core as a windows service

Posting this to remind myself that nssm just doesn't suck.If you want to run a windows service and it's asp.net do this.Publish your app to a folder on windows. Make sure dotnet 1.1 > is installed on ...

Zoho: Is it possible to get GeoLocation of user?

Problem: Many times we want latitude and longitude information of user who is currently filling the Zoho forms. Zoho doesn't provide any such object by which we can get this information & it also doesn't ...

Integrating ASP.NET Core With Webforms Using IIS URL Rewrite

I'm currently updating a legacy ASP.NET WebForms application to ASP.NET Core. Because big rewrites (almost) never work, it's a case of migrating sections of the site one at a time, having WebForms pass ...

AppDynamics Disk Space Alert Extension: Windows support

I've added a Powershell port of this shell script to support Windows servers, and Derrek has merged the PR back into the trunk:https://github.com/Ap... port is pretty faithful ...

Custom Role Claim Based Authentication on SharePoint 2013

We had a requirement in a project to authenticate users in a site collection based on Country claim presented by a User.Below powershell sample is to add a US country claim value to a Visitors group of ...

Powershell to monitor Server Resource and make html report for a set number of iteration and intreval

While building a SharePoint farm for a project, i did load testing with VSTS.Since my SharePoint farm was in a different domain than that of my Load test controllers, I had to monitor few performance counters ...

SQL Server - Kill any live connections to the DB

Often you need to restore a DB or take oit offline only to find out the process aborts due to active connected sessions to the DB. Here is a quick sript that will kill all active sessions to the DB.USE ...

Distributed TensorFlow Pipeline using Google Cloud Machine Learning Engine

OverviewTensorFlow https://www.tensorflow.org/ is an open source software library for Machine Learning across a range of tasks, developed by Google. It is currently used for both research and production ...

Keras QuickRef

Keras QuickRefKeras is a high-level neural networks API, written in Python that runs on top of the Deep Learning framework TensorFlow. In fact, tf.keras will be integrated directly into TensorFlow 1.2 ...

ENZO UNIFIED - DEV CONTEST 2017

Compete for a chance to win $2,000! That’s right. We are offering a $2,000 first prize for the most innovative use of our technology. Within just a few hours you will be surprised how much you can accomplish ...

Using Measure-Object to sum file sizes in Powershell

Be aware that this line: gci -r "C:\temp\test" | measure-object -property length -sum will throw an error if it encounters a folder whose only contents is another (empty) folder; this is because measure-object ...

Writing your first adapter for Enzo Unified

This blog post shows you how to write your first adapter using the Enzo Unified SDK, so that you can extend the capabilities of SQL Server and/or create a light-weight HTTP proxy for applications, IoT ...

How To Suppress DHCP Popups In NETUI

Working on a CE device that presented a kiosk application I wanted to find a way to suppress the following Windows CE Networking DHCP popups:"DHCP was unable to obtain an IP address. If the netcard is ...

Counting pages in Confluence

We're currently migrating our Confluence installation, and I was looking around for resources to provide some basic metrics, eg. the total number of (non-private) pages we are currently hosting. It appears ...

SQL Server: How do I split a comma delimited column into multiple columns or rows?

-- converting column with commas to multiple columns --declare @col1 varchar(500)set @col1 = 'I,Hate,Broccoli'DECLARE @Tmp TABLE ( Id int, Element VARCHAR(20)) INSERT @Tmp SELECT 1,@col1 SELECT Id, PARSENAME(REPLACE(Element,'... ...