Browsed by
Month: April 2016

Configure Multiple or Additional vCloud Automation Center Appliances

Configure Multiple or Additional vCloud Automation Center Appliances

Configure Multiple or Additional vCloud Automation Center Appliances Configure Multiple or Additional vCloud Automation Center Appliances The system administrator can copy the configuration from the primary instance of the vCloud Automation Center Appliance to additional instances to ensure that all appliances in the deployment are configured identically. Procedure 1 Log in to the secondary vCloud Automation Center Appliance that you just deployed by using SSH. 2 Copy the following files from the primary instance of the vCloud Automation Center Appliance…

Read More Read More

PowerCLI to Cleanup Snapshots

PowerCLI to Cleanup Snapshots

PowerCLI to Cleanup Snapshots # Display Snapshots Get-Snapshot -VM * -Name ‘PreUpdate*’ | Select VM,Name,Description # Delete Snapshots Get-Snapshot -VM * -Name ‘PreUpdate*’ | Remove-Snapshot -RunAsync

Networking Ports (TCP/IP and UDP)

Networking Ports (TCP/IP and UDP)

Networking Ports (TCP/IP and UDP) SOURCE Wikipedia Dec 2014 Table legend[edit] Use Description Color Official Port is registered with IANA for the application[1] White Unofficial Port is not registered with IANA for the application Blue Multiple use Multiple applications are known to use this port. Yellow Well-known ports[edit] The port numbers in the range from 0 to 1023 are the well-known ports or system ports.[2] They are used by system processes that provide widely used types of network services. On…

Read More Read More

Parsing HTML to SQL using SQLDOM

Parsing HTML to SQL using SQLDOM

All Articles Source:  http://www.sqlservercentral.com/articles/HTML/88605/ Parsing HTML to SQL using SQLDOM By David Rueter, 2014/12/26 (first published: 2012/04/16)           Microsoft SQL incorporates a good XML parser. Unfortunately, the XML parser is not very useful for parsing out HTML. Why would anyone want to parse HTML in SQL? There are three main reasons that I can think of: Import data contained in HTML directly to SQL tables Manipulate, analyze and/or normalize HTML data Render data stored in SQL…

Read More Read More

NetApp Cabling for Disk Shelfs

NetApp Cabling for Disk Shelfs

NetApp Cabling for Disk Shelfs h1,h2,h3,h4,h5,h6,.site-title{ font-family: ‘Open Sans’, sans-serif; } Cabling the disk shelf SAS data ports The serial attached SCSI (SAS) ports enable each controller in the HA pair to access its own disks and the disks of its partner controller. Before you begin You must have located and marked which disk shelves go with each storage controller. About this task Disk shelf cabling is always isolated within the HA pair that owns the disks. Disk shelves are…

Read More Read More

Using a Red Hat Enterprise Linux Installation DVD as a Software Repository

Using a Red Hat Enterprise Linux Installation DVD as a Software Repository

Using a Red Hat Enterprise Linux Installation DVD as a Software Repository Using a Red Hat Enterprise Linux Installation DVD as a Software Repository To use a Red Hat Enterprise Linux installation DVD as a software repository, either in the form of a physical disc, or in the form of an ISO image file. If you are using a physical DVD, insert the disc into your computer. If you are not already root, switch users to the root account: su…

Read More Read More

SQL Server Developer Interview Questions

SQL Server Developer Interview Questions

Interview Questions – SQL Developer SOURCE: http://www.sqlservercentral.com/articles/Career/96536/ 15 Quick Short Interview Questions Useful When Hiring SQL Developers By Thomas Kovarik, 2014/12/25 (first published: 2013/02/28) Here is a useful exam that you can administer in either 10 or 15 minutes, either oral or written, when you interview for hiring permanent or contract workers for jobs in SQL Server development or support. (This is not a test for SQL Data Base Administrators.) After the list of 15 questions (below) you will find…

Read More Read More

Schedule Weekly Job to Print To InkJet to Save the Print Head

Schedule Weekly Job to Print To InkJet to Save the Print Head

Schedule Weekly Job to Print To InkJet to Save the Print Head Generic Syntax NET USE LPT1 \\server\printer copy C:\YourDirectory\FileYouCreatedWhenPrinting LPT1   Actual Example NET USE LPT1 \\Ricky-HP\HP7610 Echo Print Weekly to InkJet on %date% at %time% >>C:\Data\PrintWeekly\PrintTestPattern1.txt copy /b C:\Data\PrintWeekly\PrintTestPattern1.jpg LPT1

vCenter Server rollup jobs and processing performance data

vCenter Server rollup jobs and processing performance data

vCenter Server rollup jobs and processing performance data SOURCE: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2007388 Determining if vCenter Server rollup jobs are processing performance data (2007388) Symptoms Excessive growth of the vCenter Server database. vCenter Server rollup jobs do exist. Slow response or timeouts when retrieving performance data. Only Real Time data is available when looking at performance data. When accessing performance data for a period other than the last 24 hours, you see the message: Performance data is currently not available for this entity Resolution…

Read More Read More

Dell FX2 Technology Is Awesome (2015)

Dell FX2 Technology Is Awesome (2015)

Dell FX2 Technology Is Awesome (2015) Whitepaper: http://partnerdirect.dell.com/sites/channel/Documents/PowerEdge-FX-Architecture-Portfolio-Overview-Whitepaper.pdf Additional Reference ————————— SOURCE: http://everythingshouldbevirtual.com/tech-field-day-vfd4-dell-fx-architecture Tech Field Day – #VFD4 – Dell FX Architecture Posted on January 21, 2015 by mrlesmithjr — 1 Comment ↓ Tech Field Day – #VFD4 – Dell FX Architecture Carol Pflueger, Servers Product Manager, introduces the Dell PowerEdge FX architecture First off I would like say that Carol was top notch on this presentation. As always it is awesome to see women in tech breaking it all down; and that she did. I would…

Read More Read More

PowerShell Active Directory Commands

PowerShell Active Directory Commands

PowerShell Active Directory Commands Import-Module ActiveDirectory Set-Location AD: Get-ChildItem Set-Location “dc=rickyadams,dc=com” Set-Location “OU=TestOU” Set-ItemProperty -Path ‘.\CN=Ricky Adams’ -Name “Description” -Value “Virtualization Cloud God” Get-ADObject -LDAPFilter “(&(operatingSystem=Windows Server 2008 R2 Standard) (objectClass=computer))” -SearchBase “dc=rickyadams,dc=com” -SearchScope Subtree Search-ADAccount -PasswordExpired -UsersOnly -SearchBase “OU=TestOU,dc=rickyadams,dc=com” -SearchScope OneLevel   List All Servers in AD Get-ADComputer-Filter {OperatingSystem -Like”Windows Server*”} -Property * | Format-Table Name,OperatingSystem,OperatingSystemServicePack -Wrap-Auto # Only disabled computer accounts Get-QADComputer-ldapFilter‘(userAccountControl:1.2.840.113556.1.4.803:=2)’# Only enabled computer accountsGet-QADComputer-ldapFilter‘(!(userAccountControl:1.2.840.113556.1.4.803:=2))’ #List Active Servers Get-ADComputer-LDAPFilter“((objectcategory=computer)(&(operatingsystem=*Server*))(&(!(userAccountControl:1.2.840.113556.1.4.803:=2))))” -Property *-SearchBase“OU=Servers,DC=rickyadams,DC=com”| Format-Table Name,OperatingSystem,OperatingSystemServicePack -Wrap-Auto      …

Read More Read More

Windows Group Policy History Stored in Registry

Windows Group Policy History Stored in Registry

Windows Group Policy History Stored in Registry SOURCE: https://support.microsoft.com/en-us/kb/201453       4/15/2015 As Group Policy Objects (GPOs) are read and applied when the computer starts or when a user logs on, information about each of the GPOs applied is written to the registry. This information includes which Group Policy Extensions applied policy, the order in which the GPOs were applied, version data, and options defined for each GPO. This data is also used to determine changes that have been made to the…

Read More Read More

TSQL Table Row Counts for All Database Tables

TSQL Table Row Counts for All Database Tables

TSQL Table Row Counts for All Database Tables SELECT TableName = t.NAME, TableSchema = s.Name, RowCounts = p.rows FROM sys.tables t INNER JOIN sys.schemas s ON t.schema_id = s.schema_id INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id WHERE t.is_ms_shipped = 0 GROUP BY t.NAME, s.Name, p.Rows ORDER BY s.Name, t.Name; go  

TSQL Delete Large Number of Rows Without Filling the Transaction Log

TSQL Delete Large Number of Rows Without Filling the Transaction Log

TSQL Delete Large Number of Rows Without Filling the Transaction Log Script to delete in chunks with commit every number of rows:   DECLARE @Count INT Declare @for_delete INT Declare @chunk_size INT SELECT @chunk_size=10000 SELECT @Count = 0 select @for_delete=count(*)from [ION_Data].[dbo].[DataLog2] where TimestampUTC <‘2014-01-01’ While (@Count < @for_delete) BEGIN SELECT @Count = @Count + @chunk_size BEGINTRAN DELETE top(@chunk_size) FROM [ION_Data].[dbo].[DataLog2] where TimestampUTC <‘2014-01-01’ COMMIT TRAN   Ref Source: http://dbtricks.com/?p=44  5/22/2015

VMware vSphere and vCloud Suite Build Numbers

VMware vSphere and vCloud Suite Build Numbers

Source: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1014508 as of Apr2016 VMware vSphere and vCloud suite build numbers table This table provides a list of all VMware vSphere and vCloud suite build numbers and release dates. The build numbers are based on full installations. Patching ESXi/ESX hosts increments and build numbers listed in the vCenter Server. Note: In the table, the column marked Build Number is the number you see in the Client. The Installer Build Number is only used to identify the installer and not…

Read More Read More

Nesting Hyper-V 2012 R2 on ESXi 5.5

Nesting Hyper-V 2012 R2 on ESXi 5.5

You are here: Home / Microsoft / Hyper-V / Nesting Hyper-V 2012 R2 on ESXi 5.5 Nesting Hyper-V 2012 R2 on ESXi 5.5 June 19, 2014 by Derek Seaman Comments (9) Since joining Nutanix I’ve had the opportunity to get exposed to Microsoft Hyper-V 2012 R2, as our platform supports the three most common hypervisors: VMware vSphere, Hyper-V, and KVM. I’m now embarking on writing some Hyper-V guides for Nutanix, and wanted a way to leverage my existing ESXi 5.5…

Read More Read More

Powershell to List All Active Windows 2012 Servers from Active Directory

Powershell to List All Active Windows 2012 Servers from Active Directory

Import-ModuleActiveDirectory Set-Location AD: Get-ChildItem #Set-Location “OU=Server Infrastructure,dc=rickyadams,dc=com” Get-ADComputer-LDAPFilter“((objectcategory=computer)(&(operatingsystem=*Server 2012*))(&(!(userAccountControl:1.2.840.113556.1.4.803:=2))))” -Property *-SearchBase“OU=Server Infrastructure,DC=ia,DC=doi,DC=net”| Format-Table Name,OperatingSystem,OperatingSystemServicePack -Wrap-Auto

Database Mirroring and Replication (SQL Server 2014)

Database Mirroring and Replication (SQL Server 2014)

Database Mirroring and Replication (SQL Server) SQL Server 2014 Other Versions SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 SQL Server 2005 SQL Server 2016 Database mirroring can be used in conjunction with replication to improve availability for the publication database. Database mirroring involves two copies of a single database that typically reside on different computers. At any given time, only one copy of the database is currently available to clients. This copy is known as the principal…

Read More Read More

Android on VMware

Android on VMware

SOURCE: http://visualgdb.com/tutorials/android/vmware/   Tutorials > Android > Integration with other tools > Using VMWare to replace the slow Android Emulator Using VMWare to replace the slow Android Emulator November 20, 2014 android, vmware This tutorial shows how to accelerate the Android App development using virtual devices by replacing the slow Android emulator with faster VMWare. Most of the techniques described here will also work with other virtualization software like VirtualBox. We will first setup a virtual machine, then install Android…

Read More Read More