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.
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
Protocol Buffers are considered to be one of the fastest serializer and deserializer and respond with a lightweight response. You can implement this on the ASP.Net WebAPIs using the Web
POSITION is a powerful function that helps you to find the position of a sub string in a string. Typically, the string is a column in a given table and
You can obtain the oldest Open Transaction in the following way: — Create temporary table for results. CREATE TABLE #OpenTrans ( CurrTrans VARCHAR(25), CurrTransDet SQL_VARIANT ); — Insert info in
One of the main advantage of CSS is using the to achieve total flexibility in terms of styling. In the the contents are ‘locked’ within a cell. It’s safe to
Queries like the one below will perform more slowly than they could be run on a varchar column. Explicitly marking them as such will improve the performance of EF queries
