Wednesday, 30 May 2012

Add New Hardware Wizard On Windows 7

The 'Add Hardware Wizard' is still included in Windows 7.

Go to "Start" and then "Run" and type  hdwwiz in the search box and hit enter to get to it.

Friday, 18 May 2012

SQL Server 2012

Microsoft has recently launched SQL Server 2012.  It has some massive improvements on its predecessor. Reporting Services adds a Web front-end for data exploration and visualisation, called Power View. SQL Analysis Services has released a new semantic model, which gives Business Intelligence professionals more ease and flexibility to build solutions. Columnstore indexing helps you run queries in a data warehouse faster. Data Quality Services, along with improvements to Master Data Services, provide the tools for protecting company data.

Also new in SQL Server 2012 is features which appeal to Database Business Administrators. Microsoft has improved High Availability: the addition of AlwaysOn technology allows you to configure read-only copies of your primary database, and use them for reporting. AlwaysOn has also solved the issue of failover of multiple dependent databases.

It also has added a feature called ContainedDB which helps you identify a database to be self-contained so it's not allowed to have external dependencies. There have been two major indexing improvements: online re-indexing and column store indexes.

SQL 2012 can now be installed on Windows Server Core, which helps increase both the security and the speed of the server.

Tuesday, 15 May 2012

VBS Script That Can Ping

So this week I needed a VBS script that would ping.  The reason I needed this was to wake a wireless connection up before the script did the rest of its work.  A few pings will do this.  This script will ping (which is Google) and it will ping 8 times, which was more than enough for what I needed.

Set WshShell = WScript.CreateObject("WScript.Shell")
WScript.sleep 10000
WshShell.Run "C:\windows\system32\ping.exe -n 8 -w 500"