Darryl Fryatt @SQLdba_Darryl

#sqlhelp so MS say put ReportServerTempDB on its own disk but is it ok to put it on same drive as tempdb for a 100 concurrent connections?

#sqlhelp Whats people preferred method of ETL. Do you prefer SSIS, Replication, CDC or something else?

#sqlhelp how to have only the most recent record marked with a bit? Bit must change to 0 as record ages.

Principal has replication setup. if I lose Principal & have no backup in theory I can restore from Miror and replication will work? #sqlhelp

@SQLTentMaker Thanks for your help with my many questions, sure to be a few more!

Publisher restored to an earlier state than subscriber, need to get them in sync. Are manual inserts only option? #sqlhelp

#sqlhelp initialize with backup, SQL 2005, do I need to change the properties of Identity cols on subscriber?

Just finished my first vb.net application using SQL Reporting Services. VB is pretty easy to use, love it!

has ALMOST got the Logitech Harmony ONE to control Media Center, just need the power button to wake\sleep the box

@godderz82 first time I've had something new to say!

I'm learning something new at work, VB.NET! Makes a change!

Tried out the Airmouse for the Iphone/Touch on Media Center, not too impressed with the motion tracking I'm afraid.

Loving the simplicity of the Logitech Harmony One remote, it just works!

@godderz82 hi baby, you mean just like her yummy mummy!

hunting around for a slimline media pc with HDMI 1080p, must have low power consumption, oh and a IR port.

I want to encode all my movies but keep the 5.1 sound track. I'm currently using .mkv is this the best format?

managed to get my media center pc to sleep and wake using the infrared port. The build is almost complete just need my new Home Server!

Looks like a policy change will sort it: http://support.microsoft.com/kb/303846

frustrated by the fact that you cannot RDP into a machine that uses autologin with a blank password! Means I cannot manage my Media Center!

Correction, only happens in the properties of a device in Device Manager, it's probably some polling issue.