Apple iOS Page

Collection of Apple iOS jailbreak and article (iOS 7/8)

To read further
Yunlong Notes: Apple iOS

SQL Server References

http://blog.ylnotes.com/references-microsoft-sql-server/

[Move to blog.ylnotes.com] Express Script: Reference Script for Single Installer

http://blog.ylnotes.com/express-script-script-single-installer/

[Move to blog.ylnotes.com] Setup Hyper-V Remote ISO Mounting

moves to

http://blog.ylnotes.com/hyper-v-setup-hyper-v-remote-iso-mounting/

[YLN] WinFix: Failover Cluster – Add Cluster Node Name as in DNS

When you add new node to Failover Cluster, the new node name is always added in lower capital and it differs from DNS name.

While it does not affect the operation of FOC, it does affect the display of the node name listed in FOC.

To add the new node as in DNS, you can read further WinFix: Failover Cluster – Add Cluster Node Name as in DNS

[Move to blog.ylnotes.com] Validate Windows Cluster Configuration shows errors in List Potential Cluster Disks having disk with the same disk signature

http://blog.ylnotes.com/winfix-windows-clusters-validate-windows-cluster-configuration-shows-errors-list-potential-cluster-disks-disk-disk-signature/

[Move to blog.ylnotes.com] Symantec NetBackup Error 37: Operation requested by an invalid server

http://blog.ylnotes.com/symantec-netbackup-error-37-operation-requested-invalid-server/

[Move to blog.ylnotes.com] Admin Scripts: Create Folder with NTFS Permission using Windows Batch and ICACLS

http://blog.ylnotes.com/admin-scripts-create-folder-ntfs-permission-using-windows-batch-icacls/

[Move to blog.ylnotes.com] Office: How to insert Break Line in Spreadsheet Cell

http://blog.ylnotes.com/office-insert-break-line-spreadsheet-cell/

SQL Server: Installation completed with warning "Setup has detected a non canonical DACL on directory"

The first of SQL Server installataion completed with success. However, when I installed SQL Server second instance, I encounter the SQL Server with two warnings on DACL:

1. Setup has detected a non canonical discretionary access control list (DACL) on directory 'C:\Program Files\Microsoft SQL Server\MSAS10_50.SS2008R2EE02\OLAP\bin\'. Please verify your security settings and make corrections if needed. 
2. Setup has detected a non canonical discretionary access control list (DACL) on directory 'C:\Program Files\Microsoft SQL Server\MSAS10_50.SS2008R2EE02\OLAP\bin\'. Please verify your security settings and make corrections if needed. 

Upon investigation, I found extra DACL entries that can be safely removed.

Fortunately, SQL Server warning does not affect SQL Server operation.

Have a great day

[Move to blog.ylnotes.com] Symantec: NetBackup – Add Media Server to NB Master Server

http://blog.ylnotes.com/symantec-netbackup-add-media-server-nb-master-server/

Admin Script: Increase Service time out to start SQL Server Reporting Services

During SQL Server Installation, SQL Server Reporting Services fails to start for setup default configuration. Fortunately, it can be bypass by press 'Cancel'.

However, SSRS still fails to start manually and it always complain of timeout (default is 30000 = 30 seconds) as shown in below Event viewer.

Hence, the only solution is to increase the Service Timeout.

Have a great day

[Move to blog.ylnotes.com] Incorrect Computer System Date can cause SSL fails to load

moves to

http://blog.ylnotes.com/appfix-incorrect-computer-system-date-can-cause-ssl-fails-to-load/

Script Library - Windows Batch - Generic Date Value

Script Library is my collection of reusable component as plugable script to get DATE value to be used in Windows Batch Scripting.

The scripts have the same usage but is written using different approach depending your needs:

1. Script 1: Batch command [Date /T]
2. Script 2: VBScript
3. Script 3: Powershell

Have a great day

Android Page

I have moved my blog to new location.
In new blog, i have compiled a page for android related articles:

http://adf.ly/7800438/android

Sample Admin Script: Performance Monitoring Script using VBScript and WMI

My friend asks me whether I have a sample script for Performance Monitoring.
I have created a sample script for performance monitoring using VBScript and WMI.
The output is in html.

To modify, you must understand VBScript and WMI.

Have a great day

[Move to blog.ylnotes.com] Windows Updates: Build WSUS Offline Update ISO

http://blog.ylnotes.com/windows-updates-build-wsus-offline-update-iso/

[YLN] System Image Backup using Windows Backup ( Windows 8.1) to Linux NAS

Windows 8.1 comes with System Image Backup but it needs to be manually run and cannot be scheduled from GUI.

If you have purchased Linux NAS storage that uses sparse file allocation and does not have root privilege, you will encounter error when running Windows System Image Backup directly into Linux NAS share folder.

Since you have purchase it, I advise make use of it and create a system image backup with VHD for recovery in case.

You decide!!

Read More

[YLN] System Image Backup using Windows Server Backup (2012/2012 R2) to Linux NAS

Windows Server Backup is backup software that comes with Windows Server with no additional cost.

It supports Bare metal backup but it only supports disk backup only.

Organization that has little budget for backup storage may purchase Linux NAS appliance but Windows Server Backup cannot write when Linux NAS installed with file system that uses sparse file allocation such as ext4/XFS.

If the organization already purchased this NAS, it is better to make full use of it rather than no backup being performed at all.

You decide!

To read further System Image Backup using Windows Server Backup (2012/2012 R2) to Linux NAS

[Move to blog.ylnotes.com] Audit Scripts: Get Active Directory Users

http://blog.ylnotes.com/audit-reports-get-active-directory-users/

[Move to blog.ylnotes.com] Admin Script: Generate WinSxS Sources ISO for WinSxS Repair (Windows 8/8.1 & Windows Server 2012/2012 R2)

http://blog.ylnotes.com/admin-scripts-generate-winsxs-sources-iso-winsxs-repair/

[Move to blog.ylnotes.com] Admin Script: Test Install for SQL Server (All Features)

http://blog.ylnotes.com/admin-scripts-sql-server-slipstream-test-script-installer/

[Move to blog.ylnotes.com] SlipStream: SQL Server – Service Pack Slipstream for SQL Server 2008 to 2012

http://blog.ylnotes.com/slipstream-sql-server-service-pack-slipstream-sql-server-2008-2012/

[Move to blog.ylnotes.com] Default KMS Key for Microsoft Office (2010 to 2013)

moves to

http://blog.ylnotes.com/default-kms-key-for-microsoft-office/

[Move to blog.ylnotes.com] XenServer: Updates XenServer manually

http://blog.ylnotes.com/xenserver-updates-xenserver-manually/

[Move to blog.ylnotes.com] VMware: Workstation - Virtualize Microsoft Hyper-V for Lab

http://blog.ylnotes.com/vmware-workstation-virtualize-microsoft-hyperv-for-lab/

[YLN] Windows Updates: CleanUp WinSxS to free space for Windows 8.1/Server 2012 R2

Microsoft releases monthly updates on Every Second Tuesday. Overtime, the updates will consume free space and it may also slow down.

Read More
Windows Updates: CleanUp WinSxS to free space for Windows 8.1/Server 2012 R2

[Move to blog.ylnotes.com] WinFix: Reassociate ISO mounting with Windows Explorer in Windows 8.1/Server 2012 R2

http://blog.ylnotes.com/winfix-reassociate-iso-mounting-with-windows-explorer-windows-8-1server-2012-r2/

[YLN] Windows Update: CleanUp WinSxS to free space for Windows 7

Microsoft releases monthly updates on Every Second Tuesday. Overtime, the updates will consume free space and it may also slow down.

[Move to blog.ylnotes.com] Admin Script: Create USB ISO Bootable using Grub4Dos and NTLDR

http://blog.ylnotes.com/admin-script-create-usb-iso-bootable-using-grub4dos-and-ntldr/

[Move to blog.ylnotes.com] How to test booting from USB in Virtual Machine

moves to

http://blog.ylnotes.com/admin-tools-test-booting-usb-virtual-machine/

[Move to blog.ylnotes.com] Admin Scripts: Bootable USB - Create Windows Setup (NT 6)

http://blog.ylnotes.com/admin-scripts-bootable-usb-create-windows-setup-nt6/

[Move to blog.ylnotes.com] Quick Reference: Upgrade Windows Server Edition using Default KMS Key

moves to
http://blog.ylnotes.com/quickref-upgrade-windows-server-edition-with-dism-using-default-kms-key/

[Move to blog.ylnotes.com] Admin Script: Mac OS X - Installer Conversion (DMG to ISO)

moves to

http://blog.ylnotes.com/admin-scripts-mac-os-x-installer-conversion-dmg-iso/

[Move to blog.ylnotes.com] Active Directory: Domain Name Rename – Multiple DC for Windows Server 2012

http://blog.ylnotes.com/active-directory-domain-name-rename-multiple-dc-ws2012/

Admin Script: Backup SQL Server Databases with Week Of Month Timestamp

This is my collection of generic database backup script for SQL Server using SQLCMD.exe.

The purpose of the script is to backup SQL Server database in the Week Of Month format. The script is invoked via task scheduler to perform database backup (System and User database) weekly

This script consists of two files:
1. SqlServerBackup_WeekOfMonth.cmd
    Script to setup configuration and the script invocation from Task Scheduler

2. SqlServerBackup_WeekOfMonth.sql
    T-SQL Script to perform the database backup


This script works for SQL Server Database (Express or Full Version) from version 2008 and above.

If the setup is done properly, the final result is as follows: