Blog Home  Home RSS 2.0 Atom 1.0 CDF  
Mark Iwaszko's Technical Blog - Tuesday, December 20, 2005
An IT Liverymans Technocal Blog
 
 Tuesday, December 20, 2005

A recent project meant that there were errors in the AD settings for users when an account is disabled.

Here are some resources for the issue and links to code the solution

How to find Exchange recipients http://support.microsoft.com/?kbid=251390

THE ADSI RESOURCE KIT IS PROVIDED

http://dev.coadmin.dk/Resources/ADSI%20SDK%205%20HTML/rtk.htm#adssecurity

12/20/2005 12:22:16 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
 Friday, December 09, 2005

Physicists have managed to "entangle" the physical state of a group of atoms with that of another group of atoms across the room. This research represents an important advance relevant to the foundations of quantum mechanics and to quantum information science, including the possibility of scalable quantum networks (i.e., a quantum Internet) in the future.

Full article

12/9/2005 9:03:39 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Reference  |  Trackback
 Thursday, December 08, 2005

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

12/8/2005 10:26:20 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
What is Windows Live? http://www.live.com/

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.

12/8/2005 8:49:19 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
 Wednesday, December 07, 2005

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?

12/7/2005 6:03:47 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Personal  |  Trackback

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  

12/7/2005 1:45:31 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
 Monday, December 05, 2005

My father in law mentioned that he had a shortend Lee Enfield during his national service in the far east, so I thought I'd try to find out a bit more about it.

I think it was a "Lee Enfield SMLE No 5"

Links

http://www.leeenfieldrifleassociation.org.uk/
http://www.lee-enfield-spares.co.uk/

12/5/2005 9:29:47 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Personal  |  Trackback
 Friday, December 02, 2005
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

reflexBannerMain

12/2/2005 1:26:22 PM (GMT Standard Time, UTC+00:00)  #    Comments [1]   Personal  |  Trackback

I recently bought myself an electric Hirobo indoor helicopter.  Ive long loved helicopers and this is the newest and most stable indoor helicopter around.  Its great fun to try and master, however it requires extreem concentration whilst learning.  - Spec at http://model.hirobo.co.jp/products/0301-904/

 

Preflight Checks
Trouble Shooting

Hirobo XRB spares http://www.revolutionmodels.co.uk/acatalog/copy_of_Hirobo_XRB_spares.html

12/2/2005 1:22:46 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Personal  |  Trackback
 Wednesday, November 30, 2005

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!

11/30/2005 8:30:05 AM (GMT Standard Time, UTC+00:00)  #    Comments [1]   Technical  |  Trackback
 Wednesday, November 23, 2005

http://blogs.conchango.com/jamiethomson/ Jamie Thomson - Life, the universe and SSIS!

http://www.sqlis.com/

http://microsoftdw.blogspot.com/ Scott Barrett has begun a blog dedicated to implementing Microsoft BI technologies

Marcin Policht
Databasejournal
SQL Server 2005 - SQL Server Integration Services - Part 1 -12

Kirk Haselden blog - Development Manager for SQL Server Integration Services

SQL BI

Business Intelligence with SQL Server (by Marco Russo) 

SQLServerCentral.com

Examples of SSIS Variable Usage
If you want to know how to use variables to control your package flow go here: http://www.sqlis.com/default.aspx?306
If you want to use variables in expressions to set properties of a task (termed property expressions) then there's a nice example here of setting the SQLStatementSource property of an ExecuteSQL Task: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx
or here of setting various properties of the SendMail task: http://www.sqlis.com/default.aspx?59
or here of setting the ConnectionString property of a FlatFile connection manager: http://blogs.conchango.com/jamiethomson/
explains how expressions can also be used in a variable: http://blogs.conchango.com/jamiethomson/archive/2005/03/19/1163.aspx

11/23/2005 9:26:49 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
11/23/2005 8:52:12 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback

Although this is based on the beta 3 it is a very good guide.

http://download.microsoft.com/documents/australia/windowsserversystem/sql2005/SQL05_Integration_Services.pdf

Local copy attached incase URL dissapears

SQL05_Integration_Services.pdf (2.44 MB)
11/23/2005 5:38:10 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
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.
posted on 06/27/2005 08:42:29 (GMT Daylight Time, UTC+01:00) by scotth  #    Comments [0] Trackback
http://www.groktalk.net/wmv/trond_brande.wmv (31.6 MB)
11/23/2005 1:17:13 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]   Technical  |  Trackback
Copyright © 2008 Mark Iwaszko. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme: