IT/High Tech – Page 2

VirtualBox Keyboard Shortcuts

06/04/2020

VirtualBox Manager (41 shortcuts) Ctrl + ↑ Shift + A Cloud Profile Manager: Add Profile… Ctrl + ↑ Shift + A Media Manager: Add… Ctrl + A Add machine… Ctrl + ↑ Shift + D Log Viewer: Bookmark Ctrl + ↑ Shift + C Snapshot Pane: Clone… Ctrl + O Clone… Ctrl + P Cloud Profile Manager… F1 Help contents Ctrl + ↑ Shift + C Media Manager: Copy… Ctrl + ↑ Shift + C Network Manager: Create… Ctrl + ↑ Shift + D Snapshot Pane: Delete… Ctrl + Q Exit Ctrl + E Export Appliance… Ctrl + ↑ Shift + T Log Viewer: Filter Ctrl + ↑ Shift + F Log Viewer: Find Ctrl + H Host Network Manager… Ctrl + I Import Appliance… Ctrl + ↑ Shift + I Cloud Profile Manager: Import Profiles… Ctrl + ↑ Shift + M Media Manager: Move… Ctrl + N New machine……

The feed does not have subscriptions by email enabled – FeedBurner

08/16/2017

| No Comments

| Blogs

If you see the FeedBurner error message above, this means that you need to enable the subscription by email option in your FeedBurner account settings. It could also mean that you have not obtained the correct FeedBurner ID. How to fix: – Login at http://feedburner.google.com/ and select your feed. – Go to the “Publicize” tab. – Open the “Email Subscriptions” section on the left. – Make sure that “Email Subscriptions” are enabled Image:

Find Duplicate Values with SQL Script

07/28/2017

| No Comments

| Microsoft SQL, SQL, T-SQL Code

Let’s assume that data has been entered in a table and now you want to find if a table column have duplicated values. Here is an SQL script to join data from one table for comparison purpose. The table must have a primary key column (unique column) and the second column for comparison. Here is a sample script: Details: – DWDOCID is the primary key column – AIXFlag, is just a fixed value (optional) – SAMPLEEN is the table…

FORMAT Function for Transact-SQL – T-SQL

03/16/2017

| No Comments

| Microsoft SQL, T-SQL Code

Returns a value formatted with the specified format and optional culture in SQL Server 2016. Use the FORMAT function for locale-aware formatting of date/time and number values as strings. FORMAT ( value, format ) Return Types: nvarchar or null The length of the return value is determined by the format. Remarks: FORMAT returns NULL for errors other than a culture that is not valid. For example, NULL is returned if the value specified in format is not…

T/SQL Splint String/Text

10/26/2016

| No Comments

| Microsoft SQL, SQL, T-SQL Code

One common task performed in database applications is given a full name, how can this be split into the first name and last name. In this article, three different methods are discussed to perform this task using three different functions in SQL Server. It is assumed in this article that the full name is just made up of one first name and one last name. Using SUBSTRING Function The first method is the use of the SUBSTRING string function,…

T/SQL Generate Random Numbers

10/26/2016

| No Comments

| Microsoft SQL, T-SQL Code

SQL Server has a built-in function that generates a random number, the RAND() mathematical function. The RAND math function returns a random float value from 0 through 1. It can take an optional seed parameter, which is an integer expression (tinyint, smallint or int) that gives the seed or start value. To use it, you can simply do a simple SELECT, as follows: SELECT RAND() AS The result generated by this SELECT statement is as follows (note that…

T-SQL Comma Delimited Output

10/26/2016

| No Comments

| Microsoft SQL, T-SQL Code

One of the common tasks performed when retrieving data from a SQL Server database is returning the result as a comma-delimited output instead of a result set. This task can be performed by using a CURSOR selecting the column to be concatenated together. Each row returned by the CURSOR is then concatenated together into a variable separating each one by a comma. Here’s how the script will look like using the table in the Northwind database. A sample…

Get Numbers from Alpha Numeric String – Get Numeric Numbers Only

06/07/2016

| No Comments

| Microsoft SQL, T-SQL Code

So, someone had stored thousands of SSN numbers in a table but now they have an issue because some of them are incomplete or are not correctly formatted. Thank you to blog.sqlauthority.com and little creativity I have come up with a SQL script that fixes this issue. Here is the T/SQL script:

Foreach C#

02/28/2016

| No Comments

| C#

A program iterates over a collection. The index of each element is not needed. Only the elements are needed. With foreach we access just the elements. A foreach-loop, this is the easiest, least error-prone loop. It is preferred in many program contexts. Here are some samples: using System; class Program { static void Main() { string[] pets = { “dog”, “cat”, “bird” }; // … Loop with the foreach keyword. foreach (string value in pets) { Console.WriteLine(value); } }…

Enable or Disable Multiple RDP Sessions in Windows 2012

02/17/2016

| No Comments

| Reference, Windows 2012

How to Enable/Disable Multiple RDP Sessions in Windows 2012. By default, Windows 2012 servers allow a single Remote Desktop session. If only one session is available and you take over another person’s live session, you may choose to enable multiple RDP sessions. This article describes the process for enabling and disabling multiple sessions. Enable Multiple RDP Sessions Log into the server using Remote Desktop. Open the start screen (press the Windows key) and type gpedit.msc and open it Go…

Category: IT/High Tech

VirtualBox Keyboard Shortcuts

The feed does not have subscriptions by email enabled – FeedBurner

Find Duplicate Values with SQL Script

FORMAT Function for Transact-SQL – T-SQL

T/SQL Splint String/Text

T/SQL Generate Random Numbers

T-SQL Comma Delimited Output

Get Numbers from Alpha Numeric String – Get Numeric Numbers Only

Foreach C#

Enable or Disable Multiple RDP Sessions in Windows 2012

Menu

Contact Info

–