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 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
Disable a Windows 2008 or Windows 2012 Server Boot (old boot.ini) 1) Unjoin the domain 2) Command prompt as administrator in \windows\system32 folder 3) bcdedit /deletevalue {bootmgr} device 4) bcdedit /deletevalue {current} device 5) Reboot
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…
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…
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) 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…
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…
http://www.openstack.org/ Resource Links: VMware and OpenStack: https://communities.vmware.com/community/vmtn/openstack
Mount Windows share using mount command This is simple way to share data between windows and linux system. You would like to access MS-Windows share called //windowsserver/sharename by mounting to /mnt/win directory under Linux system. Type the following command (replace username, windows server name, share name and password with actual values): # mkdir -p /mnt/win # mount -t smbfs -o username=winntuser,password=mypassword //windowsserver/sharename /mnt/win # cd /mnt/win # ls -l (or in CentOS, as root) mount.cifs //server/smbsharefolder /mnt/mountfolder user=username,pass=thepassword,dom=domainname …
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 – Create a mount point for the repository: mkdir -p /path/to/repo where…
How To Install the BIND DNS Server on CentOS 6 Jun 12, 2013 DNS CentOS Preamble This article will show you how to setup and configure the BIND DNS Server. If you are looking for a guide on how to use DigitalOcean’s integrated DNS service, you may want to review the “How to Set Up a Host Name with DigitalOcean” article instead. Before we begin, it is recommended you have at least two cloud servers to run your nameservers. Two…
NetApp NetApp 101 https://netapp.myco.com/na_admin # web gui URL. Most feature avail there, including a console. ssh netapp.myco.com # ssh (or rsh, telnet in) for CLI access get root mount of /vol/vol0/etc in a unix machint do to direct config on files. NOW = NetApp Support Site NetApp man pages (“mirror” by uwaterloo) RAID-DP IMHO Admin Notes Notes about NetApp export, NFS and Windows CIFS ACL permission issues. Best practices is for most (if not all) export points of NFS server…
VMware ESXi esxcli Command: A Quick Tutorial By Steve Jin | Published: May 12, 2015 The esxcli is a command tool that is available on VMware ESXi for managing ESXi. Unlike the vim-cmd command, it focuses on underlying infrastructure and touches lower level of controls of the ESXi hypervisor itself. Although it’s just one command, it packs a lot of functionalities with different namespaces/sub-namespaces, and sub-commands. Because they are organized in nice tree hierarchy, it’s actually quite easy to use…