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.
Devart, a recognized vendor of professional database tools for developers and DBAs, has released a new version of SecureBridge. An update of SecureBridge components delivers such new features as: * Support for the HTTP and HTTPS protocols is added * The TScHttpWebRequest component to support the request/response model for accessing data using HTTP/HTTPS protocol is added * Performance of downloading and uploading a file using TScSFTPClient is improved * The TScSFTPClient.PipelineLength property to indicate the number of pending requests is added *The TScSSHClientOptions.SocketReceiveBufferSize and SocketSendBufferSize properties to increase socket performance are added SecureBridge protects any TCP traffic using SSH or SSL secure transport layer protocols that provide authentication for both client and server, strong data encryption, and data integrity verification. SecureBridge components can be used in conjunction with data access components to prevent data interception or modification in an untrusted network. Learn more about SecureBridge at https://www.devart.com/sbridge/ 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 String class facilitates finding the unicode of characters in a String using the codePointAt method. Listing 1. Finding Unicode Characters public class StringCodePoint{ public static void main(String args[]) {
Java provides a very easy mechanism to read jar files. It is the same process used for reading a zip file. The file myFiles.jar contains one or more files (as
The following code snippet shows a small example of how you can sum the result of a count aggregate function. select sum(studentcount) as TotalCountfrom( SELECT count(s.studentname) as studentcount, s.studentname as
You can convert videos in different formats to view them in your browser. An easier way to play video in HTML format is to use YouTube. YouTube generates an automated
Use the string class’s constructor to specify the character and the number of times you want it to be repeated. Listing 1. Repeat String Characters String repeatedCharacterString = new String(‘*’,50);
In nearly all applications, there is critical data that we would not want anyone to see. Java has an easy way of implementing this. All that is required is to
Oftentimes, you might want to understand and control all the threads in your runtime. Java provides an effective and easy mechanism to achieve this using Thread.activeCount() and Thread.enumerate() methods. public
You can handle errors in T-SQL almost the same way as in C# or Visual Basic. You can make use of a Try and catch block to trap errors and
if (name.compareTo(“Jerry”) == 0) …if (name == “Jerry”) …if (name.equals(“Jerry”)) …if (“”.equals(name)) … All the above comparisons are correct, but they are not great. The compareTo method is overkill and
Import the time module and call the time function. The units are in Seconds. See below for an easy example. import timestartTime= time.time()”time consuming stuff”time consuming stuff”time consuming stuffendTime =
We are well aware of validating a Palindrome string. The emphasize here is usage of StringBuffer/Builder and the reverse method to get the string reversed instead of using an interactive
.NET uses SSL3 as the default security protocol for communicating with vendor servers. You can override the default SecurityProtocol used in .NET by setting the TLS 1.2 version explicitly: ServicePointManager.SecurityProtocol
Just type “.” in your run menu, and press Enter. It will open the ???downloads??? folder in Windows folder.
Windows Explorer status bar offers rich information about the files being viewed. For any video file, Windows shows the length of the video in the status bar along with the size, date created and other attributes.
Learn how to use FILEPROPERTY to check for free space in a database. SELECT DB_NAME() AS DBName, name AS FileName, size/128.0 AS MB, size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS INT)/128.0 AS
REPLACE is similar to INSERT command. The REPLACE command behaves as INSERT when there is no record matching the constraints. It still removes the existing records and again acts as
We can use the Sort Method of LINQ, and use the CompareTo delegate. If your List contains collection of objects, where each object has a date identifier, you could use
Most developers work with threads at one point or another. It can be important to know which threads are active to accomplish a given task. The following API activeCount on
You can use the following script to enable TLS 1.2 on a server using PowerShell. $regFile = @”Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSecurityProvidersSCHANNELProtocolsTLS 1.2][HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSecurityProvidersSCHANNELProtocolsTLS 1.2Client]”Enabled”=dword:ffffffff”DisabledByDefault”=dword:00000000[HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSecurityProvidersSCHANNELProtocolsTLS 1.2Server]”Enabled”=dword:ffffffff”DisabledByDefault”=dword:00000000″@Invoke-Command -ScriptBlock {param($regFile) $regFile | out-file
The?following?code?enables?you?to?identify?all?of?your?foreign?keys?in?a?particular?database. DUMMY?TEXT:?This?is?some?dummy?text.?Hopefully?there?is?no?issues?in?submitting?this?tip?on?devx.com SELECT?PKTABLE_QUALIFIER?=?CONVERT(SYSNAME,DB_NAME()),? ???????PKTABLE_OWNER?=?CONVERT(SYSNAME,SCHEMA_NAME(O1.SCHEMA_ID)),? ???????PKTABLE_NAME?=?CONVERT(SYSNAME,O1.NAME),? ???????PKCOLUMN_NAME?=?CONVERT(SYSNAME,C1.NAME),? ???????FKTABLE_QUALIFIER?=?CONVERT(SYSNAME,DB_NAME()),? ???????FKTABLE_OWNER?=?CONVERT(SYSNAME,SCHEMA_NAME(O2.SCHEMA_ID)),? ???????FKTABLE_NAME?=?CONVERT(SYSNAME,O2.NAME),? ???????FKCOLUMN_NAME?=?CONVERT(SYSNAME,C2.NAME),? ???????–?Force?the?column?to?be?non-nullable?(see?SQL?BU?325751)? ???????–KEY_SEQ?????????????=?isnull(convert(smallint,k.constraint_column_id),?sysconv(smallint,0)),? ???????UPDATE_RULE?=?CONVERT(SMALLINT,CASE?OBJECTPROPERTY(F.OBJECT_ID,’CnstIsUpdateCascade’)?? ????????????????????????????????????????WHEN?1?THEN?0? ????????????????????????????????????????ELSE?1? ??????????????????????????????????????END),? ???????DELETE_RULE?=?CONVERT(SMALLINT,CASE?OBJECTPROPERTY(F.OBJECT_ID,’CnstIsDeleteCascade’)?? ????????????????????????????????????????WHEN?1?THEN?0? ????????????????????????????????????????ELSE?1? ??????????????????????????????????????END),? ???????FK_NAME?=?CONVERT(SYSNAME,OBJECT_NAME(F.OBJECT_ID)),? ???????PK_NAME?=?CONVERT(SYSNAME,I.NAME),? ???????DEFERRABILITY?=?CONVERT(SMALLINT,7)???? FROM???SYS.ALL_OBJECTS?O1,? ???????SYS.ALL_OBJECTS?O2,? ???????SYS.ALL_COLUMNS?C1,? ???????SYS.ALL_COLUMNS?C2,? ???????SYS.FOREIGN_KEYS?F? ???????INNER?JOIN?SYS.FOREIGN_KEY_COLUMNS?K? ?????????ON?(K.CONSTRAINT_OBJECT_ID?=?F.OBJECT_ID)?
Do you want to import data from a large SQL file into MySQL? Using the following mechanism, you will be able to import it with the file filename.sql. Just follow
Fiddler comes with a set of very useful tools that will help developers to quickly do some encoding and decoding functions. It is buried under the “Text Wizard.” You can
jQuery developers often use $().ready or $(document).ready to initialize jQuery functions after the HTML page has loaded. However, it is fired when the HTML objects are still being downloaded by the browser
The InternalsVisibleTo?attribute of System.Runtime.CompilerServices?class allows you to expose internal methods of one assembly to another. All you have to do is to specify this in the assemblyinfo.cs?file of the assembly
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
