2020-03-02 14:21
Online Password Generator With Strength Validation Read More
Blog Directory > Software Blogs > Programming Blogs > Virtual Species programming Blog >
Virtual Species Blog
virtualspecies.com
Tags:
table
database
sql table
sql server
column names
password generator
puzzle
password
search
backup
This site touches upon Computer Engineering and Programming Language research.
2020-02-20 05:17
There are couple ways to count row of a SQL table. Below is the quickest script to do that.12USE [YourDatabaseName]SELECT COUNT(*) AS "TotalRow" FROM [YourTable… Read More
2020-02-19 05:34
We can easily find out the database version by checking the important server details of the backup files using the below script.12USE msdbRESTORE HEADERONLY FROM DISK&nbs&hell…Read More
2020-02-17 21:14
Below is the script to get information about the each type of the successful backups for each databases.1234USE msdbSELECT name, user_name, first_lsn, last_lsn, &hell…Read More
2020-02-01 16:12
We can create a search puzzle with a grid of random letters and numbers. Below is a 10x10 puzzle board. Use generate button to get the puzzle and find script at the end of this page.Generate… Read More
2020-01-04 07:36
We can use the TRUNCATE TABLE statement to remove all the records or specified partition of a table. This statement in SQL Server is similar to the DELETE statement without WHERE Clause.1TRU… Read More
2019-12-22 20:06
Orchid (OXT)EOSStellar Lumens (XLM)CoinbaseRobinhoodUphold Read More
2019-12-22 07:34
A database can not be dropped if there is replication enabled for it. We can use the below stored procedure to check whether a database has a Publisher that enabled for replication.12EXECUTE… Read More
2019-10-14 12:26
We have seen the behavior in SSMS that nothing happen when we go to Tasks/Restore/Database. It means that the backup/restore history for the database is very long, and the wizard will take l… Read More
2019-09-18 13:59
Below is the effective query to get column names from a SQL table. We will use INFORMATION_SCHEMA to get the task done.123SELECT COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNSWHERE&nb&hell…Read More
2019-09-10 18:21
If we need to retrieve all the email domains from a SQL table, we can easily pull up result using below script. The SUBSTRING Function is used to extract and display the part of a string. In… Read More
2019-05-02 15:59
Keyboard functions have great impact on our productivity, greatly speed up the outcome and save a whole lot of time. It also can reduce wrist strain. Remembering these functions can be overw… Read More
2019-04-20 05:07
In many cases, we will need to edit the hosts file on our machine. It is used to resolve hosts names before DNS. We can control access to websites and network traffic with this, in case of a… Read More
2019-01-20 16:37
In many cases, we need to run Terminal as an administrator. To switch the user to root to be able to execute with high privileges as an admin, we can use following command instead of using s… Read More
2018-11-20 20:29
Many users don't bother to know of which build of Windows 10 they have on their machine. This is OK. In fact, most of the users don't need to know which version of OS they are running since… Read More
2018-10-09 17:04
Visual Studio Code has quickly become a very popular lightweight text editor. This post is to see how we set it up as default editor for Git. We can use as simple as the below command_$ git… Read More
2018-08-01 05:30
There are three temperature scales in use today, Fahrenheit, Celsius, and Kelvin. The Fahrenheit scale was developed by the German physicist Daniel Gabriel Fahrenheit (1686-1736). He origin… Read More
2018-07-16 20:11
Sometimes we fall in need that we need to remove all the local git branches that are not on the remote. We create a pull request after finishing our tasks and merge that pull into the master… Read More
2018-07-14 08:53
2018-07-14 08:52
2018-06-21 05:21
Different breeds of dog age at varying speeds. Dogs' age at varying speeds at different stages of their lives. "Small dogs reach skeletal and reproductive maturity sooner than larger breeds… Read More
2018-05-17 03:19
2018-04-08 07:42
Write or paste your text to count characters Read More
2018-03-20 15:18
Every main programming language implements comments. Comments are ignored by the compiler and this is how a script generates it's own… Read More
2018-03-11 08:35
Try and try and keep trying. NAME the COLOR aloud that you see, NOT the words that you are reading. ATTENTION: The COLOR of the worlds are different from what words say. Play this game over… Read More
2018-03-07 07:34
It always easy to take a screenshot on a Mac. We can take a screenshot of an entire desktop or an active window. In this post, we will talk about the built-in screenshot taking options right… Read More
2018-02-12 13:00
DIV 1DIV 2DIV 3DIV 4DIV 5DIV 6DIV 7DIV 8DIV 9DIV 10Style ODDStyle EVENReset All Read More
2018-01-02 17:34
There are several ways to generate output in JavaScript. Each and every scenario depends on our need. These are_ innerHTMLdocument.write() console.log()window.alert()Read more »&hell…Read More
2017-12-24 07:50
Here is the most convenient way to syntax highlighting on a blogger post.. 1. Go to https://gist.github.com/ 2. Create… Read More
2017-12-15 14:46
Select First Character:Number Lowercase Uppercase OtherSelect Next Characters:Number Lowercase Uppercase OtherPassword Length:Extra Password Characters:New Password: GENERATE CLEAR ALL Read More
2017-12-05 14:56
1. Checkout "MyBranch" before deleting {OldBranch}. It makes "MyBranch" current/working branch. $ git checkout {MyBranch}2. Delete local "MyBranch". This is the… Read More
2017-12-04 17:30
Software Engineers deal with git branches pretty much every day. Git branches are an integral part of our everyday workflow. To keep it as a reference, we will talk about some every day requ… Read More
2017-11-28 14:51
CLICK Button was clicked - 0 - times.RESET The above click event can easily be triggered by a little script. We can use that for our blog or in web game to collect cl… Read More
2017-11-28 14:51
What it can't do? Well, I was talking about jQuery. It is a tremendous library. CSS wasn't able to create complex animations at some point, and then jQuery appeared to help it out. jQuery cr… Read More
2017-11-28 14:50
Age Calculator_BasicDate Format: Month/Date/YearBirth DateRecent DateUse TodayCALCULATECLEAR=>[ Round down ]=> Read More
2017-11-28 14:50
Twitter declared 280 characters limit for tweeting (current 140) but all users will not be able to use the offer yet. Its only for test on selected accounts. However, there is a workaround… Read More
2017-11-28 14:50
Tic Tac ToeTIC TAC TOE X wins: 0 O wins: 0 Draws: 0 New GameNEW GAMEClearCLEAR Read More
2017-11-28 14:49
Triangular NumberTriangular Form: [A x (A + 1) / 2] A = =>=> Read More
2017-11-28 14:48
In many cases, we need to know whats going on with internet on our Mac. Well, we can take a look at DNS (Domain Name System) and associated cache file. There is another way to get this task… Read More
2017-11-28 14:48
Snipping Tool is very popular little utility for Windows users. You can take screenshot with required dimension with it. Is there any option on Mac that can replace this tool?Well, absolutel… Read More
2017-11-28 14:47
Before talking about finding bin folder on Mac, we should know something simple. There is a unique behavior of UNIX system. System directories (/usr, /var, /etc) are always hidden on Mac by… Read More
2017-11-28 14:47
JavaScript setInterval() method either call a function evaluates an expression at specified number of milliseconds. This method continues to call/evaluate the expression until window is call… Read More
2017-11-28 14:47
Encoding HTML code is important in many cases. We know that browsers may get the encoding wrong. Symbols might get mixed up or might show as unknown character. Encoding data converts potenti… Read More
2017-11-28 14:47
All DEMOs... Click Count with Hovering.htmlGrab the Button.html Read More
2017-11-28 14:46
We talked about HTML encoding and create a handy tool on HTML Code Encoder post. We talked about why encoding is important and why we can't ignore that. However, decoded HTML code is also ne… Read More
2017-11-28 14:46
START STOP RESETRead more » Read More
2017-11-28 14:46
Read more » Read More
2017-11-28 14:45
unescape() Method Test characters: ~!@#$%^&*=+(){}[],?/:;'\"\\We know that escape() method returns a string of the argument with all spaces, punctuation, accented characters and any… Read More
2017-11-28 14:45
escape() MethodThe escape() function computes a new string in Unicode format where certain characters have been replaced by a hexadecimal escape sequence. It encodes all the spaces, punctuat… Read More
2017-11-28 14:45
In many cases, we may find data escaped. Especially for the data that are represented by an unreserved character. Most of the unreserved characters are automatically encoded by some systems… Read More
2017-11-28 14:45
If you are a web developer or blogger, you need to put together a string for using it in a URL in many cases. To do that, you have to be very careful, you have to account some special charac… Read More
2017-11-03 18:23
All DEMOs... HTML Code Encoder.jsHTML Code Decoder.jsCompare escape(), encodeURI(), andencodeURIComponent.js MORE => 1, 2 Read More
Subscribe to Virtual Species
Get updates delivered right to your inbox!