devxlogo

We are an award-winning tech entrepreneurship website where trusted experts can provide value globally.

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.

devxlogo

Trusted for 26 years

Over 30K Articles

1M+ Readers

Expert-reviewed

10K+ Tech Terms

As seen in:

microsoft logo
business_insider_logo
wired_logo
berkley
arstechnica_logo
hackernoon

The Latest

Using SendKeys in C#

SendKeys is very powerful. You can use SendKeys to send a different keycode from the one that was pressed. For example: private void TextBox1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode

Using String.join to Concatenate Strings

String.join is an easy-to-use utility method in String class. public class StringJoin{ public static void main(String args[]){ //The first argument (refered as joinString) is used to join the subsequent argument(s)

Calling Java Methods Using Lambda Expressions

To call Java methods using Lambda expressions you can use: – Car::makeCar //Static method of a class- Car::drive // Method of an instance- Car::new //Constructor of a class- Car::drive //

Restrict the Connection to a Database in SQL

You can restrict the connection to a database by specifying Single User mode, as shown below: USE master;GOALTER DATABASE YourDatabaseNameSET SINGLE_USERWITH ROLLBACK IMMEDIATE;GOALTER DATABASE YourDatabaseNameSET READ_ONLY;GOALTER DATABASE YourDatabaseNameSET MULTI_USER;GO This

Limiting the rows returned – MySQL

Ideally, this is a performance enhancement and needs lot of visibility before hand to implement at early stages. There are numerous cases when you are running on low memory and want to limit the data in your transactions.Especially, when you are sure that you dont need all the records matching your query, you can have criterias set. Stil, there could be plenty of them returned and you may want just a handfull of them or a little more. In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided  Eg: SELECT * FROM `database_name`.`table_name` LIMIT 10; The value of LIMIT is defined by what your need is. Use it accordingly to allow only the specified records is returned so that you also benefit with performance and quicker processing.

Calculating Availability

Availability is measured in so-called nines notation, that corresponds to the percentage of time that a service is available. For example, if a service is available 99.9% of the time, we can say that has “three-nines availability”. This notation is used to gives us the specific amount of downtime that a service is allowed to have.  Next are the availability and downtime calculations for 99% availability to 99.999% availability : 99% availability (two-nines):         * 3.65 days/year (of allowed downtime)         * 7.20 hours/month         * 1.68 hours/week         * 14.4 minutes/day 99.9% availability (three-nines):         * 8.76 hours/year         * 43.8 minutes/month         * 10.1 minutes/week         * 1.44 minutes/day 99.99% availability (four-nines):          * 52.56 minutes/year        * 4.38 minutes/month        * 1.01 minutes/week        * 8.66 seconds/day 99.999% availability (five-nines):        * 5.26 minutes/year        * 25.9 seconds/month        * 6.05 seconds/week        * 864.3 mimiseconds/day

Quickly escape the escape characters in a string.

C# provides you a way to escape the problematic characters in a string through the ???@??? symbol. Just place it before the string, and the compiler will escape those characters.For e.g. String filePath = @???c:windowssystem32???;Thus you do not have to escape the slashes in the string in the above example.

View the Certificate of a Website in Chrome

You can easily access a website’s certificate in Chrome via the developer tools. Go to developer tools (F12), Security tab. In the Security Overview section, choose “view certificate.”

Avoid Scrolling for Information

Avoid?Scrolling?in?the?same?document?for?some?information. Using?the windows?”split”?feature?available?in?the?VS.NET IDE?and?you?can?split?the?document?window?into?two?and?have?two?windows?with?the?same?content?aligned?horizontally. You?can?thus?find?the?information?you?were?looking?for?and?avoid?long?scrolls.

The sp_spaceused Procedure in SQL

The sp_spaceused special SQL procedure displays the number of rows, disk space reserved, disk space used by a table, or indexed view in the current database. Here is a small

CORS Support in Spring

Spring MVC has implicit CORS support, so to use the controller method CORS configuration with @CrossOrigin annotation in your Spring Boot application does not require any specific configuration. The global

Display of Bit Field on UI

Fields with ‘Bit’ Data Types, when displayed on Web Pages show as True/False. They don’t show the actual ‘0’ / ‘1’. If you are using a DataReader to retrieve such

Creating the Hash for Short URLs

The hashing function is used to generate random strings of six characters, that can be numbers or upper and lowercase letters. We need to make sure that a string is

Merge Two DataTables, Preserving the Old Values

The datatable1.Merge(datatable2) statement will merge datatable2 into datatable1. You cannot retrieve the old values in the datatable1 after the merge happens. A quick way to do that, is by creating

Add a selectedIndex Changed Event Handler to a ComboBox

When you create the datagridview associate an event handler for its ‘EditingControlShowing’ event. sampleDataGridView.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(DataGridViewEditingControlShowing); And in the event handler add the selectedIndexChanged eventhandler to the combobox. private