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.
The following query will produce a list of tables that are referenced by one or more Views: SELECT [table] = s.name + N’.’ + t.name FROM sys.tables AS t INNER
Devart released an updated dbForge Developer Bundle for SQL Server with dbForge Monitor, a new add-in for monitoring SQL Server performance, and a number of other new features. Devart, a Czech software provider of database connectivity solutions and tools for database management and development, announced the release of dbForge Developer Bundle for SQL Server with a new add-in dbForge Monitor. dbForge Monitor is a FREE add-in for Microsoft SQL Server Management Studio (MS SSMS) that allows users to track and improve SQL Server performance. The tool includes a bunch of metrics showing what is going on a server in detail. With the comprehensive functionality, including Wait Statistics, Data IO, and Top Queries, users can easily detect and troubleshoot server slowdowns and bottlenecks. Moreover, the Bundle tools have been updated with new features and major improvements: such as dbForge SQL Complete, dbForge Data Compare for SQL Server, dbForge Schema Compare for SQL Server, dbForge Query Builder for SQL Server, dbForge Data Generator for SQL Server, dbForge Index Manager, dbForge Documenter, dbForge Source Control, dbForge Search, dbForge Event Profiler for SQL Server, SQL Decryptor, dbForge Unit Test, dbForge Data Pump. For more information about dbForge Developer Bundle for SQL Server, please visit https://www.devart.com/dbforge/sql/developer-bundle/ About Devart Devart 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
Use the String.Join method to concatenate elements of a string array. See below for sample code. var stringArray = new string[] {“element1”, “element2″};var combinedString = String,Join(” | “, stringArray);
Only once the development part of the project is complete do we tend to look at the performance of our application’s interaction with the database and realize that the transactions
See how to use the console’s time and timeend functions to capture time taken for a block of script to execute. See below for a simple example. //start the timerconsole.time(‘Start:Filter’);//the
Outlook has introduced a feature to clean-up conversations in a folder including or excluding its sub folders. This removes the repeated replies on an email thread, and keeps the latest
The following query can be used to get details such as when the Stored Procedure was last updated???as well as its content. SELECT CREATED, LAST_ALTERED, SPECIFIC_NAME, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITIONFROM lms_db.INFORMATION_SCHEMA.ROUTINES
Use one of the following methods to check if a list is empty in Python: a. If not listname: print(“list is empty”)b. if len(listname) == 0: print(“list is empty’)
Using the System.Net.WebRequestMethods.FTP class, we can use the “SIZE” FTP Protocol method to get the size of the file in FTP. Below is an example in C#: var request =
In jQuery, we use a delay in the $.debounce function to limit repetitive calls in components such as the instant search. We can do that in AngularJS as well, using
Lambda expressions have simplified the way we write code. For example, let’s see how to use a method from an interface. This works with Java 1.8 only. Expected output: Welcome
In order to floodfill drawn objects, you can make use of the following 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
The default assembly path is usually set to the bin folder of the project. However, there are certain times when it’s best to push the assemblies to a common folder.
Using underscores in numerals is allowed in Java. This is for better readability and representation. The example below illustrates the same value being written in two different forms and results
We can use an alias for long namespaces and use it further down in the code. For an example, see below: //InteropExcel is the aliasusing InteropExcel = Microsoft.Office.Interop.Excel;public class SpreadSheetInteropHelper{
Scanner is a simple and easy-to-use utility provided by Java. import java.util.Scanner;public class ScannerDemo{ public static void main(String args[]) { Scanner scanner = new Scanner(System.in); //Initializing the Scanner with the
Use the following code to block and unblock Internet connectivity on a user’s PC: 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;using System.Diagnostics;using System.IO;using System.Reflection;namespace BlockInternet{ public partial class
1. SELECT FROM TableA A INNER JOIN TableB B ON A.key=B.key2. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key 3. SELECT FROM TableA A RIGHT JOIN TableB B
Class diagrams help you to understand code a lot more quickly through visual representation. Visual Studio, by default, provides you with a one-step process to generate self-updating Class diagrams. Right-click
Optional makes it easier in cases where the result is not really needed. This example can be fine-tuned as needed to explore all of the methods supported. import java.util.Optional;public class
Visual Studio can help you create a GUID quickly. Go to Tools – Create GUID and choose one of the GUID formats. It allows you to copy the newly generated
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
