Add IDENTITY or Unique number to a table – T/SQL

I want to update my table records. However, my existing table does not have any unique columns. So, I need to append Identity column and update all the records based on that Identity column. For example, If my temp table has 1000 records without any unique column values. I need to number all these 1000 records and update the values. There is no need to do an UPDATE. The identity column is going to be populated when it is created….

Read More

How to Install an SSL/TLS Certificate In Microsoft IIS 7

The following instructions will guide you through the SSL installation process on Microsoft IIS 7. If you have more than one server or device, you will need to install the certificate on each server or device you need to secure. If you still have not generated your certificate and completed the validation process, reference our CSR Generation Instructions and disregard the steps below. What You’ll Need 1. Your server certificate This is the certificate you received from the CA for your…

Read More

Posted in IIS Tagged , Comments Off on How to Install an SSL/TLS Certificate In Microsoft IIS 7
How to run .msi files as an administrator

Starting in Windows Server 2012 the “Run as administrator” option no longer appears when right-clicking a .msi file. This may be a required step when installing certain applications onto your Windows Server. Below are some options to be able to run a .msi file as an administrator. As a single-use solution, you can run the .msi as an administrator from the Windows command prompt. Open elevated Command Prompt. To do so, type “CMD” in the Start menu or Start screen search box,…

Read More

Netstat command

netstat -ano … This command displays process IDs (PIDS) that are associated with active TCP or UDP network connections. netstat -abn … This command displays the process names associated with active TCP or UDP network connections. NOTE: The option ” > c:\PortsList.txt” after the above command will allow generating a text file. Help ?

Read More

Telnet [servername] [port]

This command will help you determine if there is a process listing in that server with a specific port. We used this command in DocuWare to help find a service such Authentication server is listing in that DocuWare server. It is typically done from a machine that you think you do not have a connection. telnet dwserver 9000

Read More

Microsoft Hyper-V Virtual Machine Keyboard Shortcuts

With Hyper-V we now have the “Virtual Machine Connection” to use when interacting with a virtual machine (unlike Virtual Server which used “VMRC”).  The Virtual Machine Connection window wraps the standard Remote Desktop Client and uses this to connect to the virtual machine.  As such – we are now using the Remote Desktop key combinations.  Here is a brief summary of the key combinations that can be used with the Virtual Machine Connection. Standard Windows Key combination Virtual Machine…

Read More

How to Change Schema of Mssql Tables, Stored Procedures, and Views All at the Same Time

Sometimes changing database users changes who the database owner is for a table from dbo.tablename to badschema.tablename. This will also affect any stored procedures created under the tables with the incorect schema.  If you need to change the schema for these tables back to the default dbo schema follow the steps below. Open Microsoft SQL Server Management Studio and log in. Click the New Query button. Paste the following script into the New Query box changing oldschema to the name of the current schema:…

Read More

How to Batch Rename File Extensions

So how do you rename multiple file extensions at once? If you have a directory full of files that need to be changed from .PNG to .JPG, it’s going to take forever to do this using the method above. Luckily, there are a couple of different ways we can change the file extension for multiple files at once. Command Line For those of you who are familiar with the command line, there is a very easy command you can…

Read More

How to copy and paste between your computer and VirtualBox

1- Install additional software After you install VirtualBox and a virtual machine, you want to Copy & Paste between your computer and the virtual machine, you need to install an additional piece of software, which is ” Guest Additions“.On the  VirtualBox window, enter the  Devices/Insert Guest Additions CD Image..function to insert a virtual  CD disc to install this software. After finishing installation, restart your virtual machine  2- Shared Clipboard + Drag & Drop Shut down your virtual machine and go back to the  VirtualBox Manager ​​​​​​​screen. On “General -> Advanced” Tab, select: Shared Clipboard:…

Read More