DAEMON Tools is a virtual cd/dvd-rom emulator. It is able to emulate nearly all known copy protections on the market today.
Both 32bit and x64 versions have beeb released. Download here
Windows Live is based on one simple idea: that your online world gets better when everything works simply and effortlessly together. So all the things you care about online - your friends, the latest information, your e-mails, searching the Net - all come together in one place. Windows Live is a brand new Internet experience designed to put you in control. And this is just the beginning-you'll see many more new products in the coming months.
|
Like most boys who dont grow up Ive been interested in model trains for many years. I have an old hornby train set in the loft and as my sons grow up I hope that it will get some use. However I recently discovered the Live Steam collection from Hornby.
I had assumed that these were just electric trains which puffed out an oily smoke, but NO ! They are the real thing. Fill up the boiler with water, let it heat up and not only does steam come from the whistle but the train is actually driven by the Steam ! - Brilliant.
|
|
|
The locomotive is powered by a mini immersion heater, located in the tender, and is heated by a safe low voltage current passed along the track by a remote regulator, located on the Live Steam control box. This voltage boils the water which in turn creates steam, causing the pistons to move and the wheels to turn. Speed is dictated by another regulator on the control box, and with a few quick nudges, the locomotive can be sped up or slowed down, and even reversed.
After a small amount of practice, the operator can achieve in excess of 20 minutes running from one filling of water. The locomotive also produced realistic steam sounds from pumping pistons to the whistle, coupled with the unmistakable and memorable smells of steam and hot engine oil. |
The Live Steam locomotive requires a dedicated route to run on, because of the current to heat the water, and is not compatible with DCC control. The special Live Steam control and transformer boxes are included in the box set.
This is a real steam locomotive, operated purely by steam - what could be better than to own your own Live Steam models, and reminisce over those memories of the steam, the smell and the sounds? |
When MSRS exports to Excel it creates a new worksheet for each page, which is great, however it would be even better if you could control the naming of each of those pages. Apparently you cant do this yet.
Info at microsoft.public.sqlserver.reportingsvcs
Reflex is a flight sim software that has awesome photo realistic graphics. You need a high spec machine and graphics card to run it.
It comes with a dongle to connect to your remote control. It lets you select the plane or Helicopter you want to fly from a broad selection of fixed wing aircraft… propeller, jets and gliders. In addition, you can scan in photos of a model plane you’d like to fly, feed in its parameters, and using the included Reflex RMK Model Editor construct a custom model. (Info from here)
http://www.reflex-sim.de/
Details at http://www.helihobby.com/html/reflex_sim.html
|
In summary to query SMS from the Admin fron end you enter a psuedo language called WQL. This is translated, by SMS into SQL and the original WQL and its translated SQL is stored in an SMS table called Collection_Rules_SQL.
Thus you can learn the mapping that SMS is doing from WQL to SQL and if required update the SQL directly.
------------------------------------------------------------------------------------------------------
The link to the source of this page seems to be broken, so a copy of the article is below: |
 | By: Dave Fuller
Posted On: 6/12/2003
When you create dynamic Collections in SMS using query based rules, you have to define the query using WQL. This is fine in most circumstances, but as you have probably already found, WQL is nowhere near as rich in functions as SQL and whereas a query could be created using SQL to get the result set you want, you just can’t get the same from WQL.
Consider the scenario where you want to create a Collection that contains all workstations that have not reported Hardware Inventory for more than 14 days. To perform the query in SQL, you could use the GetDate() function to return the current date and use the DateDiff() function to compare the current date with the LastHWScan date and return all workstations where this value was greater than 14, as demonstrated below.
select sys.ItemKey, sys.DiscArchKey, sys.Name0, sys.SMS_Unique_Identifier0, sys.Resource_Domain_OR_Workgr0, sys.Client0 from System_DISC AS sys JOIN WorkstationStatus_DATA AS wks on sys.ItemKey = wks.MachineID where DATEDIFF(dd,wks.LastHWScan,GetDate()) > 30
When you create a Query Based Rule in the SMS Administrator console, SMS stores the WQL and also translates the WQL into a SQL query. The WQL and SQL are stored in the Collection_Rules_SQL table, which uses the CollectionID and query index as key. When SMS performs Collection Evaluation, it uses the SQL query in the SQL column of this table rather than the WQL. Therefore, if you create a Query Based Rule in the console, but don’t set any criteria, you can then modify the translated SQL to whatever you like, and the Collection membership will then be evaluated based on that query. As long as you don’t change the WQL by editing the Collection in the SMS Admin Console, this provides a useful workaround.
Here’s how you do it:
1. Create the Collection in the SMS Administrator Console. Create a single Query based rule, but don’t define any criteria.
2. Determine the Collection ID (you could run the WQL query ‘select CollectionID from SMS_Collection where name = ‘<collection name>’’)
3. Using SQL Query Analyser, run the following query to update the SQL query rule for the new Collection
Update Collection_Rules_SQL set SQL = ‘select SMS_R_System.ItemKey, SMS_R_System.DiscArchKey, SMS_R_System.Name0, SMS_R_System.SMS_Unique_Identifier0, SMS_R_System.Resource_Domain_OR_Workgr0, SMS_R_System.Client0 from System_DISC AS SMS_R_System JOIN WorkstationStatus_DATA AS wks on SMS_R_System.ItemKey = wks.MachineID where DATEDIFF(dd,wks.LastHWScan,GetDate()) > 30’ where CollectionID = <CollectionID>
4. Update the Collection membership and the Collection will now contain all machines that have not reported inventory within the last 14 days. Be sure not to modify the query using the Administrator console, or the SQL will be overwritten!
A short but very illustrative example of using the output of and SSIS package as the data source for a Reports Services Report
Trond Brande from Norway presenting SQL Integration Services (SSIS) and DataReader Destination. The streaming version is here, and the downloadable version is here, or available via podcasting our RSS Feed.
In trying to connect SQL2005 SSIS to Sharepoint Lists, this article is very helpfull on the mechanics of programatically retrieving data from sharepoint
|
Copyright © 2008 Mark Iwaszko. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme:
|
|