Posts

DATAMINING tasks

what different data mining tasks........... the common basic data mining tasks (supported sql server 2005) are classification, regression, clustering, forecasting, association analysis, correlation analysis. all tasks act blocks in solving large set of business problems. a few starting points: - http://www.microsoft.com/sql/technologies/dm/default.mspx  -- tutorial , webcast ("introduction data mining in sql server 2005")  provide description of data mining tasks supported in sql server, plus details on tools - http:// www.sqlserverdatamining.com   -- lots of information, tutorials etc.         SQL Server  >  Data Mining

Overwrting varibale Expression in SSIS

Image
hi all, we have 1 package in production. variable var_date has expression defined it. how can we overwrite variable value config file or cmd file. dont want make changes package , redeploy it. hi syedf, ssis provide several methods change variable values outside packages @ runtime. benefit of doing allows change results of package without having open package in development environment (bids).  to overwrite variable values outside package, can use configurations, sql agent job, command line dtexec , t-sql query xp_cmdshell. for more details methods, please refer following 2 blogs: http://www.bidn.com/blogs/devinknight/ssis/1655/passing-values-into-an-ssis-package-at-runtime-from-outside-the-package http://www.bradleyschacht.com/override-ssis-package-variables-without-opening-the-package/ thanks, katherine xiong katherine xiong technet community support SQL Server ...

Send email from Sql Job Schedule

hi, have table called customer name , birthday , email address stored. trying send email person birth day in current day , month creating job schedule in sql server 2005. job scheduled daily. job schedule command below declare @out_desc varchar(1000), @out_mesg varchar(10) declare @name varchar(20), @birthdate datetime, @email nvarchar(50) declare @body nvarchar(1000) declare c1 cursor read_only select [name], [birthdate], [email] customerdetails_data.dbo.customers open c1 fetch next c1 @name, @birthdate, @email while @@fetch_status = 0 begin set @body = '<b>happy birthday ' + @name + '</b><br />many happy returns of day' + '<br /><br />customer relationship department' exec customerdetails_data.dbo.sp_send_mail 'testss@company.net', --- add email address here '***********', ----add password here ...

What is the technique to flip a control

dear all, what way apply flipping effect control ? imagine have game card display in front of you, clicking on want card flip , diplay side. each side have own content . an other example have picture displayed in scatterview items , when taping on picture, flips side , display mailling complete in order tos end pricture this effect control, can done ? thanks help regards serge your experience build 1 of others there thirdparty opensource libraries can use achieve effect. thriple: http://thriple.codeplex.com/ bagoftricks contains 'flip3d' control: http://work.j832.com/2008/03/bag-o-tricks-march-edition.html implementations make use of 3d possibilities of wpf, write yourself. Other Forums  >  Surface Application Design and Development ...

Cannot add to domain a machine in different VLAN where Domain Contoler is

i have machine in 1 vlan (10.1.x.x). machine dc active directory configured , dns service. want join machine domain additional domain controler, de machine in other vlan (10.13.x.x) , when try join domain error "one domain controler not found" o this. dns service works ok, resolve names , ips. netdiag test ok. have add in active directory sites , services subnet (10.13.x.x) same error. if try join machine in same vlan there isn't problem. traffic between 2 vlans open, have scanner ports , of them ok. configuration necesary? suppose if connect other netcard of dc other vlan work, think there other possibilities. , other question, have secondary domain controler necesary cluster? appreciated, i'm not system administrator , i'm confused this. thanks!! sorry can't read language output in appears have multi-homed dc.  not work dc has have single nic, seems might have three.  disable 1 of nic's , restart on netlogon service dns records register ser...

How do I automatically force VMs to migrate before the host reboots?

i have 5 node hyper-v failover cluster using cluster shared volume. live migration has been working great when use virtual machine manager or failover cluster manager. problem vms don't automatically migrate host before lets me reboot host. instead, host powers down , vms virtually power-cords yanked. @ point, restored 1 of remaining hosts, there few minutes of down time , vm needs startup again. turns problem every week when push windows updates hosts (staggered across few hours) , automatically reboot if required. my first question whether or not cluster service supposed migrate vms prior allowing restarted. second question if there's way force vms migrate prior shutting down (shutdown powershell script, etc...). additional info: host os: server 2008 r2 datacenter hosts , clients using latest vmm agents hi,   if restart node before perform live migration, vms on node restarted perform quick migration. if want perform live migration through powershell, can refer fol...

WDS not deploying identical vhdx image

i've gotten wds deploy vhdx install image, reason image multicasted on not same original. image dynamic disk of size 12.2gb max size of 100gb. after wds deploys image, size of new image on disk 100gb. real issue when boot freshly imaged client, boots start screen pale blue background, clock (with no date, should have date). can attempt login spins forever it's thinking never logs in.  i shut down system, pulled out drive , plugged host. copied vhdx manually drive. after putting in client system, boot , works fine. have wallpaper @ welcome screen, , date there below clock should be. appears imaging process isn't deploying should. as 1 more data point, i've tried doing deploying differencing disk same image base. results same, @ time assumed because deployed image differencing disk. deploying differencing disk deploys both child , parent disks image adds bcd entry child image. in scenario, tried deleting child differencing disk , added new bcd entry base image...