Menu
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.
One way to speed up the Windows startup process is to remove unwanted programs. You can do this using the Startup options of the System Configuration window. To launch System
Consider the following table that already exists: CREATE TABLE ‘NUMBERS_TABLE’ (‘ONE’ INT(11) NULL DEFAULT NULL,’THREE’ INT(11) NULL DEFAULT NULL,’FIVE’ INT(11) NULL DEFAULT NULL)COLLATE=’utf8_bin’ENGINE=InnoDB; And we want to add a new
The tag can be used to add highlights to text. You can choose the color of the highlight. The code looks like this: This is highlighted text.
Create a file called app_offline.htm with an appropriate maintenance message. Just place this file in the root directory of the web application. IIS and the ASP.NET Framework will stop serving new
See how to use the disjoint method in Collections to find if the given lists are completely disjointed: import java.util.*;public class UsingDisjointInCollections { public static void main(String args[]) { UsingDisjointInCollections
MySQL provides a schema named information_schema. This has a table named TABLES that has detailed information on the available tables, their record count, etc. The query below helps you with
You can find tables with an XML column in the following way: SELECT [table] = s.name + N’.’ + t.name FROM sys.tables AS t INNER JOIN sys.schemas AS s ON
The element tag was formerly used to create subheadings, such as a logo. Now, the element has been redefined, more suitably, and now indicates small print. It is useful as
Did you know you can chain null comparisons to any level on an object with ?? operator? See below for an example: string inputString;//set some value.var multiEvaluationResult = inputString?? secondaryString
There is plenty of data in tables that could be the same data available for multiple records. We may want to know these details and perform some action. Considering the
If you want to let your web application restart your application pool, all you have to do is write a file to the IIS websites folder, which is typically c:inetpubwwwroot.
You can refresh a database object with the help of the sp_refreshsqlmodule function, as shown below: EXEC sys.sp_refreshsqlmodule ‘ObjectName’
CSS clipping is another powerful feature. The shape’s edge is called the clip-path, and clipping shows what image area should be visible. Clipping is about hiding what normally would be
Although using braces is a a common practice, it is sometimes very misleading and it can take hours to figure out what is wrong. A simple way to avoid such
There are cases in which we want to ignore errors even if they are genuine. For example, there could be a feed running on all days except for some fixed
MySQL is very powerful with a lot of in-built features. Today we are analyzing the INSTR function. Syntax: INSTR (String, subString) Result: Returns the first index of the subString in
You can easily find tables referenced by foreign keys with a script similar to the following: SELECT [table] = s.name + N’.’ + t.name FROM sys.tables AS t INNER JOIN
Scalable Vector Graphics (SVG) is an XML-based vector image format for two-dimensional graphics. As the name suggests, SVG is used to scale, so it very handy when comes to responsive
There are 3 highly popular myths about garbage collection. Let’s review those myths and the actual truth behind them. Myth #1: Minor GCs don’t pause the application There are different
We write a lot of event logs from .NET applications and others. There are use cases in which you need to read them by logging into the actual machine. It
You can write “not equal to” in two different ways in SQL: !=
The preload resource hint can give the browser a head start on loading your site’s CSS and it also signals the browser to initiate an early fetch for an asset.
Have you felt a need for enums to have composite values? They can be defined internally within the enum as below: Public enum livingObjects {Humans,Animals,Plants,All = Humans | Animals |
Use cases where we need to have the result with varying decimal places are possible. You can change the value in the resulting field using the TRUNCATE function. Consider the
Write a test method around the block of code that you want to test as an independent piece. Then, compile the code. Just open the test explorer window and right
LocalDate tomorrow = LocalDate.now().plusDays(3);LocalDateTime anHourFromNow = LocalDateTime.now().plusHours(10); Long daysBetween = java.time.temporal.ChronoUnit.DAYS.between(LocalDate.now(), LocalDate.now().plusDays(2));Duration duration = Duration.between(Instant.now(), ZonedDateTime.parse(“2018-08-30T09:00:00+01:00[Europe/Stockholm]”));
The * enables you to select all elements of a particular selector. For example, if you used *pand then added CSS styles to that, it would do it to all
Sp_help?provides a lot of information about the structure of the tables inside your database. You can highlight a table name in the SQL Query editor and then press the Alt
Sp_help provides a lot of information about the structure of the tables inside your database. You can highlight a table name in the SQL Query editor and then press the Alt
MySQL provides many utilities for verifying and taking corrective actions in case of failures. One such tool is mysqlcheck Usage: [root@mypc]# mysqlcheck -h -u -p –analyze –databases ; The above
