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!

SQL Server: How do I get the size of a database?

use [databaseName]goSELECT database_name = DB_NAME(database_id) , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2)) , row_size_mb = CAST(SUM(CASE WHEN type_desc ...

Top 6 Java Web Development frameworks for mobile apps

Java is certainly a mainstream programming language which is an essential part of the most famous Android app development. It is the most popular programming language used for Android app development like ...

SQL Server: Find existing temp tables on a server.

-- query the server to examine all the existing temp tablesselect name, object_name(object_id) As ObjName,* from tempdb.sys.objects where name like '#%' ...

Top Reasons Why Your Business Needs a Mobile App in 2018

If you are running a business and your business still does not have a mobile app then you need to get one fast. Nowadays having an online presence through website is no longer sufficient, as online activity ...

SQL Server: How do look at the dataypes/lengths of columns in a temp table?

To view that information, there are 2 primary ways:select * from tempdb.INFORMATION_SCHEMA.C... where table_name like '#MyTempTable%'select * from tempdb.sys.columns where object_id = object_id('tempdb..#mytempt... ...

Simple Image Manipulation - Brightness

Last time I played with played with Pixels - Color Effect with HTML5 and JShttp://geekswithblogs.net... this short post, let's go back to basics. Let us try ...

Playing with Pixels - Color Effect with HTML5 and JS

I've been playing with HTML5 and JS when I feel bored, and I love taking pictures. So Tried putting them together in this mini project <3 SOURCE CODE - https://jsfiddle.net/Humpre... ...

SQL SERVER: How do I find all the tables that have had an update in a database?

This query will bring back the last user update to every table in the database you're connected to.use [dbname]goSELECT last_user_update, t.name FROM sys.dm_db_index_usage_stats us JOIN sys.tables t ON ...

Visual Studio Code - On Mac Talking to SQL Server

So, this has taken a whileOnly tonights install of Visual Studio Code update (aka after Build Keynote???)... I can finally run SQL Server queries from Visual Studio Code on my Mac. I followed this guide ...

Cloud Friday Nashville–May 2018

I had the good fortune to attend, and speak at, Cloud Friday Nashville on May 4th, 2018. It was a great event and I hope to attend next year as well. Here’s my presentation: How Atrium Health Implemented ...

Power BI Presenting JSON data from SQL 2014 Table

SQL 2016 or later and SQL Azure both support JSON function in native SQL. However, people using SQL 2014 or below are out of luck.However, if we just need a quick report, PowerBI can provide that functionality. ...

SQL Remove Duplicates without Using Temp Table or Modifying Existing Table

Up until now, the way I understood to "fix" a table with duplicate data and no primary key or unique key is either:Modify the existing table, add a column and populate with unique key data, then delete ...

oData and Big Floats

Today, I made an interesting discovery.I’m synchronising data to Microsoft NAV, from an iOS app, using oData.My iOS app, makes JSON requests to pull/push records in and out of NAV.Todays discovery was ...

How to deploy the dialogflow bot to Facebook app.

read my article on linkedin,

Google to Launch new Gmail Design Help Of Custom Web Development

Recently Google has sent an email to its G Suite Customers to tell them that the company has been working since long to launch a brand new version of Gmail for the web. Other than a fresh design, Gmail ...

postincrement and preincrement in c#

Today I was working in C# and I write a code like this. Read more ...

Scikit Learn Quickref for Machine Learning

Scikit LearnScikit-learn ( http://scikit-learn.org ) is a free software Machine Learning lib for the Python programming language. It features various classification, regression and clustering algorithms ...

How to check crash issue in C# apps ?

Recently I was working on a C# application. Suddenly someone asks “Are you able to remove all the dll in bin folder”. read more ...

Trane XE70 furnace wont start

I have a 20 year old Trane XE70 that is still going strong. But it has needed parts and they are easy to replace. 1) if you turn on the power and it cycles through you should see a glow of the ignitor. ...

All you need to know about Android Wear SDK and Emulator

People are always on the lookout of new features and updates related to the most advanced devices, especially by the giant industry leaders like Android and Apple Inc. as well. In this write up, we will ...

Evolution of the World Wide Web From Web 1.0 to Web 5.0

WWW (The World Wide Web) “www” stands for the World Wide Web which is a part of the internet. It links and connects documents and websites together which can be searched on web browsers like Google Chrome ...

Time To Reboot

It has been nearly six months since I blogged last. Thankfully this means I have been busy working on client projects. It is a new year and just back from spring break so I think it is time to start digging ...

Windows to Go With the Spyrus USB Drive

What we need is a good bootable live USB stick for Windows. I've said this many times over the years, and hacked together things to make that very thing happen, but nothing that worked really well. So ...

How to implement AMP on your website.

Recently I used AMP on one of my website. The site was already live and I need to implement the AMP functionality on the website. In your post page you define a amphtml tag which have url of the amp page. ...

Benefits of customized .NET Application Development

Websites are the most desired tools of promotion for every brand and company that wants to reach more audience and increase the potential of the lead generation. Well, there are many options to choose ...

Which Distribution of Linux Should I Use?

I'm often asked this question: "hey, you're a Linux guy right? What Linux should I use? I have this friend who recommends _____ and I want to know what you think?" I usually reply with the same question: ...

How to open URL in browser in C# ?

In C# sometime we need to open URL in browser, for opening we can use following code.
Read more

SQL Server: How do I pull the ASCII value for each character in a column name?

This is a handy script to cycle through every character in a column to determine what each ascii value is. This is especially useful when a string match isn't matching. Often times, there is a hidden space, ...

Common Code Smells

You may have heard the term "code smells" lately, it seems its being talked about frequently again. In this short post I'll explain what they are, and a few of them you may run across. What is a Code Smell? ...

7 Essential Principles to know: iPhone App Development

iPhones are definitely the most demanded smartphones with their unique features and dynamic UI /UX makes every iPhone user go in awe. Thanks to the amazing features of the iPhone coupled with awesome apps ...

My Latest Virtualization Setup

Like many geeks of the time I spent the 90s and 2000s with at least 2 or 3 old computers in a closet, connected by a switch running various operating systems with various services running on them. Giant, ...

Free Book Chapter

Here’s a free chapter from Programming the Microsoft Bot Framework, "Fine-Tuning Your Chatbot": http://bit.ly/2BJNcsZ @JoeMayo ...

DAX Studio 2.7.2 Released

The lastest update for DAX Studio is now live at http://daxstudio.org This release includes a number of small enhancements and fixes including the following:Enhancement: Allowing "Unlimited" Dataset sizes ...

Load Testing Your IIS Web Server

All the theory, calculations, and estimations in the world aren’t going to tell you how your website will truly perform under a load. If you’re deploying a new server or doing any kind of performance enhancements, ...

DAX Studio recent Win7 SP1 crashes

We've just found out that a recent security update to the .Net framework in January 2018 for Windows 7 SP1 has been causing crashes in DAX Studio when accessing the File menu. Unfortunately this issue ...

SQL Server: Moving DATA and LOG file to different location

The default location of the "data" and "log" files for SQL Server database is "C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQ... for version 2016 unless it is set differently during the ...

Unit Test for EF LINQ queries using Mocked DbSet

Goal: Create a unit test for a EF repository query. As we all know unit tests are infrastructure agnostic and therefore have no kowledge of for example external services, databases, etc. So how can we ...

Having trouble using GitHub with BI projects

I had existing solution built. I've attached a screenshot of local repository folder structure.So to get started in GitHub, I created a company repository called "DataServices", and uploaded the entire ...

C# Local Function

static void Main(string[] args) { int Sum(int x, int y) { return x + y; } int res = 5 + 2; Console.WriteLine(res); }This is a 5 line code to show how Local method works in C# ...

ICYMI: Programming the Microsoft Bot Framework

My latest book, Programming the Microsoft Bot Framework: A Multiplatform Approach to Building Chatbots, is now available. You can find more details on the Microsoft Press site. @JoeMayo ...

Released LINQ to Twitter v4.2.0

Today, I released the latest version of LINQ to Twitter. In addition to fixing bugs, the highlighted features of this release include support for DM Events, Extended Tweets and .NET Core. Here’s a demo ...

importing ssis flat files in redshift using copy

After trying a million combinations, I finally figured out how to export data in SSIS using an OLE DB source (SQL Server) and a flat file destination. In the end all I really should have done was use "ENCODING ...

creating a t-sql script to enable query store and auto tuning for each user database

select 'ALTER DATABASE [' + name + '] SET QUERY_STORE = ON ALTER DATABASE [' + name + '] SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON )'from sys.databases where name not in ('master','model','msdb','t... ...