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.
It can become quite frustrating when you cannot remember the name of an SQL stored procedure, especially if you have quite a few of them. But, let’s say that you
It can become quite frustrating when you cannot remember the name of an SQL stored procedure, especially if you have quite a few of them. But, let’s say that you
To detach from a Docker container and leave it running, you can use the CTRL -p or CTRL -q command.
The java.lang.management.ThreadMXBean is an interface that helps us to understand a lot about Threads in our code. There are numerous methods that participate to provide excellent visibility of the Threads. Something
Devart, a recognized vendor of professional database management software for developers and DBAs, announced the release of dbForge Studio for SQL Server v5.5 with such significant features as Executed SQL Statements History, Support for Surround SCM predefined template, SQL Server 2016 Service Pack 1 (SP1) and SQL Server 2017 CTP2 new syntax support. dbForge Studio for SQL Server v5.5 has received multiple improvements, and here are only several of them: * SQL Server 2017 RC2 new syntax supported;* Query Execution History – dramatically redesigned;* New Feature – Monitor Server Performance;* Lots of improvements in:– Schema Compare – Data Generator– Source Control– Code Completion– Documenter– Index Manager dbForge Studio for SQL Server is an integrated environment for SQL Server development, management, administration, data reporting, and analysis. SQL Manager tool allows users to create, edit, copy, attach and detach, backup and restore databases from one server to another easily. These SQL tools help developers to manage databases, make complex database changes and speed up routine tasks.To learn more, visit http://www.devart.com/dbforge/sql/studio/About DevartDevart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects. Learn more about Devart at https://www.devart.com.
The valueOf() method is useful when you do not know the value contained and it might throw a NullPointerException. It returns null and you can handle the same in your code
Use the GetLeftPart method on the HttpRequest’s URI with Authority as the UriPartial’s value to retrieve the DNS Name. string dnsName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority); ? Visit the DevX Tip Bank ?
Use the GetLeftPart method on the HttpRequest’s URI with Authority as the UriPartial’s value to retrieve the DNS Name. string dnsName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
It is quite easy to find out which tables in your database(s) do not have Primary Keys. You can use the following SQL script: SELECT s.name + N’.’ + t.name
Improve Java performance with MAP. Add Contains keys Next Data StructureHashMap O(1) O(1) O(h/n) Hash TableEnumMap O(1) O(1) O(1) ArrayLinkedHashMap O(1) O(1) O(1) Hash Table+Linked ListTreeMap O(log n) O(log n)
We can see that the method println is referred by System.out using :: import java.util.*;public class NewForEach { public static void main(String args[]) { List empNames = new ArrayList(); empNames.add(“Andrew”);
ASP.NET websites need some static data to be initialized, so that subsequent requests can utilize the loaded data and load much faster. It is a common practice to write such
ASP.NET websites need some static data to be initialized, so that subsequent requests can utilize the loaded data and load much faster. It is a common practice to write such
During testing or monitoring, there is a constant need to monitor the number of sessions created, so as to better correlate the performance metrics collected. The Performance Monitor tool is
During testing or monitoring, there is a constant need to monitor the number of sessions created, so as to better correlate the performance metrics collected. The Performance Monitor tool is
Getting a user that has deleted rows with SQL is a multi-part process. First you have to search the transaction log file for information on deleted rows. SELECT [Transaction ID],
Chrome provides a nice tool, to save the page you are on as a shortcut to desktop. Select the tab that you want to save on your desktop as a shortcut, and go to Tools Menu. Choose More Tools – Add to desktop option. A new shortcut will be created on the desktop with the link to the page you were browsing.
Word allows you to restrict certain sections in the document from formatting or editing. To enable this on a section of text, choose the “Restrict Editing” option that is under the Developer Menu – Protect Section. You will see the ???Restrict Editing??? toolbar appear to your right. You can choose and set Formatting and/or Editing restrictions. You need to add a password to apply a restriction and also to remove the restriction.
When we open multiple tabs, and there is music/sound from one of the tabs it is tough to figure out which tab is emitting the sound in Chrome. An easy way is to look for the tab name/title in the open Chrome tabs. Chrome displays a volume icon just before the tab name/title if the tab is playing music/sound. You can thus quickly locate the tab and take further action.
Did you ever find a need to change the orientation of a word document? If yes, you can quickly do that by navigating to the ???Page Layout??? menu and choose the Landscape/Potrait orientation option.
Java collections – performance (Time Complexity) A set is a collection that contains no duplicate elements. Add Next Contains Data StructureHashSet O(1) O(h/n) O(1) Hash TableEnumSet O(1) O(1) O(1) Bit
Files have multiple properties and they are interesting to use. In fact, your own file system can be developed using them. Create a file named PATH.txt and try this program
System.Math provides the BigMul method for cases where you have to find the product of two large integer numerals that may result in a value that would cause an System.Overflow
Newtomsonft.json has helper methods that help to serialize objects to JSON. See below for a code snippet that uses the library and helps convert an object to JSON format. public
The ErrorProvider control is quite useful when it comes to user input validation. The next code segment assumes an ErrorProvider control named errorProvider1 has been placed on a form along
Java collections – performance (Time Complexity) A list is an ordered collection of elements. Add Remove Get Contains Data StructureArrayList O(1) O(n) O(1) O(n) ArrayCopyonWriteArrayList O(n) O(n) O(1) O(n) ArrayLinkedList
BlockingQueue in Java is more advanced Queue. It performs all functionalities of a Queue in addition to certain qualities. It waits for the Queue to be non empty before retrieving an element using take() method and holds on for a placeholder to be available before it can add an element to the Queue using the put() method. BlockingQueue is an Interface and can be used as below. We are trying to initialize an ArrayBlockingQueue with size of 5. BlockingQueue intQueue = new ArrayBlockingQueue(5); intQueue.put() will add the data and wait for a space if it is full. intQueue.take() will remove the element at the head of the Queue.
In order to flood fill drawn objects, you can make use of the next sample: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace FloodFill { public partial class Form1 : Form { public Form1() { InitializeComponent(); } Bitmap bm; Graphics g; private bool SameColor(Color c1, Color c2) { return ((c1.A == c2.A) && (c1.B == c2.B) && (c1.G == c2.G) && (c1.R == c2.R)); } private void tobien1(Bitmap bm, Point p, Color Color, Color LineColor) { Stack S = new Stack(); S.Push(p); while (S.Count != 0) { p = S.Pop();
Many times, it is tough to traverse up the control tree to reach the parent control. The best example is of a control in a template column of a grid.
There are cases in our math calculations where we would need absolute values of negative numbers. System.Math class’s Abs method helps in such cases. It returns the absolute value of
