What’s on our mind?

Exsilio Solutions is proud to introduce our new blog! Not only is this forum completely integrated with all our social networks, but it is also 100% responsive. Now, you can take Exsilio with you on your phone, tablet, and desktop - redefine what you thought possible!

SQL SERVER 2016 – ISJSON Function

In my first post, How to load data into SQL Server using JSON functionality, I discussed one of the key functions of SQL Server 2016 JSON support, which is OPENJSON.

Today we will see another built in function of JSON, which is ISJSON.

ISJSON - This function is used to test whether a string contains valid JSON or not. It returns 1 if the string is valid JSON. If not, it returns 0. It returns null if the expression is null. We will check all of these return values.

MORE

Switching Tables in a SQL Server Database to a New Filegroup

Sometimes you may find your SQL Server database is performing at suboptimal levels. After a lot of use, especially in a production environment, your database will have endured a high number of transactions, object creation and drops, and these can lead to fragmentation of the data at the disk level. You may also find that your database is quite large, but it has some empty space. However, when you attempt to shrink the database, you cannot do it. In this case, a common culprit is fragmentation.

MORE

Javascript Best Practices: Modules

As modern web applications become increasingly client heavy, it’s important to properly organize your client side code. In small applications, organization may not seem necessary, however, as your application grows and more people are involved with the project, proper organization becomes key to keeping the application maintainable. This is where Modules come in.

MORE

Software Testing Trends

In the past years, the trending of mobile technology, applications and the cloud has grown exponentially. It continues to grow today. Therefore, the demand for testers is growing as well. Security, performance, and usability testing are on top of their list to have a successful product.

The popularity of mobile technology and apps are insane. Along with it, the demand for mobile testing continue to trend exponentially every year. Based on the study published by Capgemini, Sogeti and HP in 2013 -2014 around global testing trends, there is an average of a 70% increase in mobile testing practices across industries. MORE

Work Around For ShellRunas With Office on Windows 8

At Exsilio we do a lot of consulting work.  As a result we often need to use client provided credentials on our Exsilio work stations.  This can be difficult if the credentials provided are active directory based, since most of us are running on an internal active directory domain.  To get around this we use a cool little Explorer extension called ShellRunas which is part of the Sysinternals Suite (a free collection of useful system utilities for Windows). MORE

Maps aren’t just for directions!

There’s a good chance that you looked at a map recently. Maybe it was the GPS in your car or on your phone. Or it may have been on an app to help you find a place to eat or fuel up at a gas station. Every time you use one of these maps you are utilizing a Geographic Information System. Until about 5 years ago, if someone said ‘GIS’ they were probably talking about ESRI’s ArcMap. Today, the term GIS is more ambiguous and can be applied to a lot of different solutions that involve a map. MORE

Mysterious “File Access Denied” in Windows 8

Often times in the past, I try to delete a file or folder only to be presented with a message kindly reminding me that I can’t delete because it has been locked by another application, So I find the program that has the file open and close it. That’s fine with me because I understand the kernel needs to protect the file to maintain stability.

MORE

Loading more content...