YouTube LinkedIn RSS Facebook
Univertis
Consulting services across the world
 
Skip to content
  • Home
  • Blog
  • About
  • Products
  • Services
  • Français
  • English
Home Archive by category "Tips and Tricks"

Category: Tips and Tricks

Javascript add leading zero to day and month

Konstantin Pankratov 1 November 2016 17 August 2020Tips and Tricks
programming

If you code in JavaScript, you will notice that the display of dates and times in this programming language is not standard. Numbers are displayed as integers, not characters. But how to display zeros in front of the numbers down 10? We will answer this question by a simple example.…

Continue reading

HtmlTextWriter to string

Konstantin Pankratov 17 October 2016 17 August 2020Tips and Tricks
programming

If you create custom controls in ASP.NET, you will probably, sooner or later, be dealing with HtmlTextWriter. This tool allows you to generate HTML tags. It is better, comparing to StringBuilder, because it allows to build a nicely indented markup. In this example, we’ll show you how to debug it, in order…

Continue reading

Find column in Sql Server database

Konstantin Pankratov 1 September 2016 17 August 2020Tips and Tricks
database

While analyzing or debugging an application, you surely already had to search for a certain column, or field, referring to a database. The common task is to find all the tables, having that exact column name, to which the code is pointing to.  If you’ll search for it manually throughout…

Continue reading

Notes taking – speech to text

Konstantin Pankratov 16 August 2016 17 August 2020Tips and Tricks
SpeechToText

If you are a journalist, a student, or a business oriented person, you are probably have a need to take notes, and document them. Taking notes in our daily life can be done in various ways, from the simple handwriting to audiovisual recording. Text documents, however, are still the most popular…

Continue reading

Show current year on web site

Konstantin Pankratov 25 April 2016 17 August 2020Tips and Tricks
copyright-year

In this article we will show you how to display the current year in the footer section of your website. If you have a website, you certainly have an area dedicated to copyright, somewhere at the bottom of the page. It may happen that the year, that is shown there,…

Continue reading

Explore SQL Server Database

Konstantin Pankratov 22 March 2016 17 August 2020Tips and Tricks
database

For developers and analysts working with large databases, there is often a need to examine the structure of the database. In this article, we will show you how to do this using SQL queries. Although we can use visual objects explorer to see the contents of our database, we can…

Continue reading

Converting object to its string representation

Konstantin Pankratov 21 March 2016 17 August 2020Tips and Tricks
object-tostring

When programming in object-oriented, it is good practice to have in each entity class  the method that will display the contents of our object. This method is named ToString (). Although it already exists by default in modern languages high level as Java or C #, it is not representative. So…

Continue reading

Unlock blocked SQL Server Database

Konstantin Pankratov 18 March 2016 17 August 2020Tips and Tricks
locked_database

Sometimes we can face database blocking issue in SQL Server when trying to perform some job or do a safety backup. Most often we are told that the database is in use, when in truth nothing and no one uses it. To remedy the problem, we can just run two…

Continue reading

Detect and remove duplicates in SQL Server

Konstantin Pankratov 17 March 2016 17 August 2020Tips and Tricks
duplicates

When working with large volumes of data, it happens to have duplicates at the tables level in the database. Therefore it could lead to exceptions in the code and incorrect statistics. In the following lines we show you how to detect duplicates and how to remove them. How to manage…

Continue reading

  • YouTube LinkedIn RSS Facebook
  • Recent Posts

    • Introduction to Agile Software Development
    • Introduction to Object Oriented Design
    • The role of HRM in business
  • Categories

    • Database
    • General
    • Internet
    • Management
    • Office
    • Tips and Tricks
    • Tutorial
  • Site map| Privacy policy| Terms of use
©Univertis
Powered by Nirvana & WordPress.
YouTube LinkedIn RSS Facebook