
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.

There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn’t support this. You will

There are many times when you are running on low memory and want to limit the data in your transactions. Especially, when you are sure that you don’t need all
We create a lot of break points during our development cycle and might get lost in them as well. One of the features of Visual Studio that is seldom used
Annotations are similar to interfaces in that you can convey your own specifications that others will need to follow. Here we are defining an Annotation named ClassHeaderAnnote, which has few

The SQL FORMAT() function is used to format how a field should be displayed. You can format dates in a column in the following manner: SELECT FullNames, Surname, UserID, FORMAT(Now(),’YYYY-MM-DD’)
Assuming you have a column in a table of type DATETIME, and you want to filter it based on dates and time as well, BETWEEN will be helpful. Listing 1.
LINQ queries follow deferred execution. This means when you access a LINQ query, it will get executed. If not well designed, it will execute every time you access it. In
InputStream in = new FileInputStream(file);int q;while ((q = in.read()) != -1) { …} The code above reads a file byte by byte. Every read() method call on the stream causes
The link tag in HTML supports the media element that allows you to specify the media type, and additional conditions such as the width and load a specified CSS file.
Sometimes you will have a situation where you would want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis (or any time increment
You can create a column in a table in MySQL and make that column to auto-increment the value every time a record is inserted in the table. The catch is
With C# 6.0, you can control exceptions with a conditional if. See below for an example: Listing 1. Control Exceptions try{ //Code that creates an exception}catch (System.DllNotFoundException dllEx) if (version
“” + set.size()new Integer(set.size()).toString() The return type of the Set.size() method is int, but it is desired a conversion to String. These two lines do the conversion, but the first
You can use IF NOT EXISTS?to check whether a Primary Key is missing and add it as follows: IF NOT EXISTS (SELECT * FROM sys.tables tINNER JOIN sys.schemas s ON
Thread dump is a mechanism to view the various threads active in your application and also to know the current methods that they are active on. The result may not
Seedbelt Announces Launch Offering Entrepreneurs a way to Real World Test Their Business Idea’s Value Experts agree a lack of validation is a prime killer of many business projects. Eye opening new service Seedbelt is here to help, delivering a professional team who specialize in researching, analyzing and evaluating business ideas, placing them under critical review before deeper investment occurs. November 1st, 2017 In an ever more competitive business environment knowledge and experience become much more valuable everyday. This idea is the driving force behind the recently launched service Seedbelt, a new firm built of market analysts, researchers, marketing professionals and seasoned startup veterans whose passion is real world testing and analysis of business efforts to determine if they are right path towards success, and safe investments, or if aspects of their plan should be wisely reconsidered. Not surprisingly, the news of Seedbelt’s launch has been met with an enthusiastic response. ???The idea behind the name: fasten your Seedbelt until your business idea skyrockets into space!??? commented a spokesperson from the company. ???Test first, then scale! Once you’ve proven your business hypothesis, you can go and build a complex platform.??? Seedbelt’s services are aimed at startups, entrepreneurs of all shapes and sizes and other business leaders who are facing big decisions regarding their project and see the value in bringing in a set of transparent, highly skilled and motivated extra eyes for an honest evaluation. The amount of time and resources that can be potentially saved by making such a proactive move is immense, with there being shortage at all of examples of businesses that didn’t take this kind of step and paid a very heavy price for not taking the extra diligence. Three different Seedbelt plans are currently available: the least expensive, a seven day ???Starting Off??? plan that delivers market research and report; the next step up, a 14 day ???Taking Off??? plan which adds a Sales Page and Adwords campaign to help gather more actionable data and information; and the ultimate 30 day ???Rocket Start??? plan, combining what the first two plans offer plus Business Assistance in the form of business registration and document creation, and writing and mailing of a professional press release to interested journalists at top media outlets. The doors each of the Seedbelt plans can open and funds they can help save is stunning. The company’s spokesperson remarked, ???For $14,000 a smart entrepreneur can get their entire MVP business off the ground in 30 days, under the watchful eye and guidance of a team of proven to succeed professionals. This saves time and investor resources, allowing those two key elements to be used elsewhere as needed. Seedbelt can be an entrepreneur’s real secret weapon when used wisely.??? For more information be sure to visit http://seedbelt.com/?utm_source=promh. ###

In Android Run Time (ART) environment, Garbage Collection activity could be triggered due to one of these reasons: Concurrent A concurrent GC that does not suspend app threads. This GC
We often compare two strings to the same case and then compare them to see if they are the same. Instead, we can use the StringComparison class’s InvariantCultureIgnoreCase property. String.Equals(‘stringOne’,
The unused namespaces in the class file are greyed out when you are viewing the file in Visual Studio Code editor. This way you can quickly remove unnecessary items using
Modern web applications are predominately on HTTPS and you may want to decrypt that traffic for inspection. One of the best tools that developers use is Fiddler. Fiddler, by default,
int x = Integer.valueOf(str).intValue(); int y = Long.valueOf(Double.valueOf(str).longValue).intValue(); To use the API without allocating unnecessary objects use the following lines of code: int x = Integer.parseInt(str); int y = (int) Double.parseDouble(str);
If you have too many images on a web page, it will make too many requests to the server and take a lot of bandwidth as well. This will all
GC logs are vital artifacts to troubleshoot memory/CPU related problems and optimize applications performance. In Sep 2017, the much-awaited Java 9 was released and GC logging was re-implemented using the
Code snippet: public class NanoTimeInJava{public static void main(String args[]){NanoTimeInJava nanoTimeInJava = new NanoTimeInJava();nanoTimeInJava.proceed();} private void proceed(){//The following nanoTime() method in System class provides the time in nano secondsSystem.out.println(“Time in nano seconds : “+System.nanoTime());}} /* Expected output: [root@mypc]# java NanoTimeInJavaTime in nano seconds : 698344477290095 */
There are cases in which you will find the need to have variables inside a LINQ query to hold an evaluation result. The Let keyword helps in this case. See
This is probably an audit requirement and most of the time it is essential to maintain the creation time. However, passing the current time from an application context may not
You can identify unused Tables in the following way: ; with Unused (TableName , RowCount, DateCreated, DateModified)AS (SELECT unusedTable.name AS TableName,PS.row_count AS RowCount,unusedTable.create_date AS DateCreated,unusedTable.modify_date AS DateModifiedFROM sys.all_objects UnusedTableJOIN sys.dm_db_partition_stats
It’s not a good idea to read an XML file and store it in a String because it wastes memory. XML specifies its encoding in the XML header, so when

Adding a different country’s holidays to your Outlook calendar is easy and can be done in few clicks. Go to Outlook –> Options –> Calendar –> Calendar Options. Click on

Ideally, when you do not know the data type that you want to store in an array, you can create an Object array and later associate it with the data










