T-SQL Right 3 Digits to Zeros
SELECT (SELECT RIGHT(‘00000’ + CONVERT(VARCHAR(5),FLOOR(CAST([EP_departmentnumbertext] AS INT)/1000)*1000), 5)) AS DIVISION, * from [databasename].[dbo].[people] ep where EP_NAME like ‘%Adams%’
Microsoft Hyper-V Virtualization
Microsoft Hyper-V Virtualization Managing Hyper-V from the Command Line http://www.virtualizationadmin.com/articles-tutorials/microsoft-hyper-v-articles/management/managing-hyper-v-from-command-line-part1.html
RHEL7: Provide SMB network shares to specific clients.
RHEL7: Provide SMB network shares to specific clients. Configuration Procedure Install the Samba packages: # yum groupinstall -y “file-server” # yum install -y samba-client samba-winbind Create a new /etc/samba/smb.conf file and add the following lines (for a workgroup named MYGROUP, a server called MYSERVER, a local network with IP addresses in 192.168.1.0/24, a user named user01 and a share called shared): workgroup = MYGROUP server string = Samba Server Version %v netbios name = MYSERVER interfaces = lo eth0 192.168.1.0/24 hosts allow = 127. 192.168.1. log file = /var/log/samba/log.%m max…