Posts

Snapshot Publication is not allowing cleanup of the distribution database

in setup have both transactional publications , snapshot publications. understanding snapshot publication not track or care transactions occured since last sync. every execution of sync deliver existing snapshot, snapshotting operation takes data out of tables. problem code in sp_msmaximum_cleanup_seqno considers last transaction delivered each of distribution agents found in msdistribution_agents. includes distribution agent delivers snapshot. therefore, distribution database accumulates transactions between executions of snapshot+sync operations. see it, have missed configuration option. otherwise, seems option modify sp_msmaximum_cleanup_seqno or similar circumvention of tracking occurs. suggestions solutions? even though snapshot agent shut down, log reader agent continues delivering transactions distribution database. these transactions delivered subscribers distribution agents running transactional publications. problem not snapshot agent itself, or snapshot replication...

itemsource question on datagrid

i have datagrid sample shows following in itemssource property: itemssource="{binding source={staticresource project_editrootlist},path=data}" the  source data provider have set in user resources on page. question path=data mean?    the path=data means itemsource bound property called data in project_editrootlist .  pls refer these articles more details: silverlight data binding property path syntax     Silverlight  >  Programming Silverlight with .NET – General

TFS 2015 to TFS 2015 Update 1

i wondering, going tfs 2013.4 tfs 2015 there lot of database changes tfs databases. how going tfs 2015 tfs 2015 update 1? there database changes or application tier bits only? hi shane, why care schema changes in tfs databases ? there's schema changes support mixing git , tfvc in same team project. allowing customization of dashboard requires schema changes probably. please use mark answer if post solved problem , use vote helpful if post useful. Archived Forums V  >  Team Foundation Server - Setup and Administration

"Show properties in report" option in Excel

i have users connecting ssas 2008 cube in excel 2007. have requirement where, when user right clicks on dimension (in excel), can select "show properties in report" property , add / delete columns appearing there. how do this? please suggest thanks aaron this requires defining proper attribute relationships in dimensions.  when users hover on cell containing attribute defined in attribute relationship window being related other attributes, attributes automatically appear in screentip above cell.  likewise, if users right-click same cell, have option select "show properties in report" , choose related properties added report.  in ways, can faster manually adding attribute row labels or column labels portion of pivot table. if haven't defined attribute relationships, can still try out exposing key attribute of dimension access in pivottable.  because attribute related every other attribute in same dimension, able add attribute row/co...

ExecuteSQL Using SQLSource Variable and Output

  really stuck trying different ways string variable (expression based) parse , run correctly in executesql task. able advise why 1 of following methods works , other not? i'd prefer have second not working method used if possible.   works: "[audit].[up_logetlpackagestart]  @etlauditparentkey = ?,  @description = ?,  @packagename = ?,  @packageguid = ?,  @packageversionmajor = ?,  @packageversionminor = ?,  @packageversionbuild = ?,  @machinename = ?,  @executionguid = ?,  @logicaldate = ?,  @starttime = ?,  @operator = ?,  @etlauditkey = ? output"   fails: when variable expression set follows : code block "[audit].[up_logetlpackagestart]  @etlauditparentkey = " + (dt_wstr, 100)@[user::etlauditparentkey] + ",  @description = " + (len( @[user::packagedescription]) == 0 ? "' '" : @[user::packagedescription])  + ",  @packagename = " + @[system::packagename] + ",  @packageguid = " + @[system::...

Cannot see custom uploded Task in VSTS

i using tsx-cli upload custom release task (chef, chefknife). uploads not show on vsts.   --- use command prompt upload tasks (vso-agent-tasks) --- d:\code\vso-agent-tasks\tasks>tfx build tasks upload --task-path chefknife\ tfs cross platform command line interface v0.3.9 copyright microsoft corporation task @ d:\code\vso-agent-tasks\tasks\chefknife uploaded successfully! ------ however when go view build / release tasks on vsts cannot find it  hi kunalbabre, thank  posting here. do want upload tasks vs online? if use vso, move vso forum for dedicated support. about upload custom vnext build task tfs or vso, found link , maybe use method. http://realalm.com/2015/07/31/uploading-a-custom-build-vnext-task/ we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. ...

September 2014 TechNet Guru Power Pivot Winners announced!

Image
the september guru results posted! http://blogs.technet.com/b/wikininjas/archive/2014/10/16/the-microsoft-technet-guru-awards-september-2014.aspx below highlights, medal winners. please see blog above more entrants , comments, had trimmed fit 60,000 character forum limit.   biztalk technical guru - september 2014    johns-305 [boatseller] biztalk: working preserve interchange edi xml – part 1 mandi ohlinger : "this great how article steps , terms defined. if want preserve interchanges, need read this." tgn : "edi big part of biztalk, great wrap up, both articles." verma.sumit biztalk server - default pipelines tgn : "very nice article explaining default pipelines "in-depth"." mandi ohlinger : "great detailed information on xml pipelines. informative read. "  rahul_madaan biztalk server - debatching multiple message types usi...