Thursday, August 25, 2016

How to Create an Exponential Mindset

How to Create an Exponential Mindset



Incremental is satisfied with 10%. Exponential is out for 10X.



The exponential mindset is like this demonstration with ping pong balls in which things happen in parallel with a focus on the interactions among participants.
As I’ve written about separately, there is a way to let go without losing control. In the exponential mindset, managers replace control of people with control of principles

What’s New in C# 7.0 | .NET Blog

What’s New in C# 7.0 | .NET Blog

Wednesday, August 24, 2016

SQL FTS IFilters, its security implications and troubleshooting PDF Filter issues – Microsoft SQL Server Tips & Tricks

SQL FTS IFilters, its security implications and troubleshooting PDF Filter issues – Microsoft SQL Server Tips & Tricks



a CONTAINS clause should be at least as fast as a LIKE clause for a small table such as that, and faster for a very large table.

a) the FullText service runs independantly from the SQL service, so there's a chance it's starved for memory.
b)
how large is this notes column? if it's very large and the word
"property" is very common, of course that will slow things down... but
still not like you're describing.
c) try running a CONTAINSTABLE query instead and compare the performance.
ie: select * from CONTAINSTABLE(prospect_notes, notes, 'property')




FTS
is checking if the component is trusted/signed AND checking if the
signature has been revoked (for what we need internet connectivity). If
you cannot connect the machine to the net, then you can turn off
signature verification in FTS:
EXEC sp_fulltext_service 'verify_signature’, 0
GO








If
you want to find out how to identify the full-text document/row that
failed to index, you can follow these steps to isolate it:




1)       Find the full-text key column



USE DBNAMEGOselect name from syscolumns where colid=objectproperty(object_id(‘TBL_NAME’),‘TableFulltextKeyColumn’) and id=object_id(‘ TBL_NAME ‘)



The
full-text key is the column you used when you defined full-text index
&& it may not necessarily be the primary key of your full-text
table.




2)       Convert the value to full-text key value



select convert(varbinary(900),keyColumn) as keyColumn, uniqueColumn from TBL_NAME



3)       Once
you have this you can filter this to find the row that failed by
looking at the FTLOG and noting down the failed full-text key value,




E.g.



select convert(varbinary(900),keyColumn) as keyColumn, uniqueColumn from TBL_NAME where keyColumn = 0x2E00700064006600

The Power of the Elastic Product Team — Airbnb’s First PM on How to Build Your Own | First Round Review

Golden notes, first developed by Simon Wardley, adapted it from concepts in Robert X. Cringely’s 1992 book Accidental Empires



The Power of the Elastic Product Team — Airbnb’s First PM on How to Build Your Own | First Round Review



Design your product teams around outcomes, not features.