Dave Green CMgr FCMI

I'm a data enthusiast, husband and father. I can usually be found by the sea or at a computer - sometimes both!

[Dave Green CMgr FCMI @d_a_green]

Struck me as something of a self referential metaphor, @CloudFormsLtd forming at @SQLBits!

[Dave Green CMgr FCMI @d_a_green]

@dataspeakers Could you offer some means to people to filter based on their areas of interest? I can see some new contributors may find it helpful to test the water with pre-recorded, or even blogs, working their way up to full live sessions?

[Dave Green CMgr FCMI @d_a_green]

@DataGrillen I had a great day at #datagrillen #dataleftunattended. Thanks to all the organisers, speakers, our sponsor @redgate & most of all to those attending for making it worthwhile.

If you didn't tune in live, I'm told sessions will be on the @DataGrillen channel soon.

[Dave Green CMgr FCMI @d_a_green]

I'm looking forward to speaking at @datagrillen's Data Left Unattended #2 conference tomorrow about technology that can help you get your message across effectively - there's still time to join remotely at https://t.co/5hwji5Acpt

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ @redgate I think there's so much domain (business) knowledge required that any tool can only go so far. What would be nice is a framework, and the ability to recognise tags in say, SQL Prompt, highlighting in results and queries like it can production servers now.

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ more succinctly - is field level the right level for both bits of information?

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ don't forget sometimes it is the combination of items that make something sensitive, so a set may only need to be masked if it is problematic as a composite. e.g. age, can be part of an identifier, but not necessarily on its own. Depends on other fields and context.

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ @stephj_martin @SQLDiplomat @DataMacas @redgate we are putting links to handling instructions from our datasets for this reason. It is useful for (development and) the wider business. Not the same as security permissions. More a case of "Can I vs should I".

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ @DataMacas @redgate also, separate question, should it be unacceptable for masked data (items) to be the same as unmasked ones - or is that only the case for a whole record (multiple fields)? Veering into encryption territory here, but links to unmasking.

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ @DataMacas @redgate yes, I think a flag for whether data has been masked is a different thing to whether it is sensitive. A bit like whether it *should* be accurate vs whether it *is* accurate data... They are two different things. And checked separately.

[Dave Green CMgr FCMI @d_a_green]

@_AlexYates_ I work on the assumption that DEV/UAT work will be guided by the classification. So I call that SENSITIVE as the column is designed to hold sensitive data. Also, you fail 'safe' as @BrentO mentioned. We are all fallible; the masking needs good testing too.

[Dave Green CMgr FCMI @d_a_green]

@SOZDBA @cl @spaghettidba and the streaming works really well with the provided wireless headphones. Beanbags allow a pleasant and welcome reclined position after a day of using upright chairs in sessions! #SQLBits @SQLBits

[Dave Green CMgr FCMI @d_a_green]

@PAH66 did you find a charger? I have a USB C adapter with me (from USB or mains), can loan in the day tomorrow if it helps? (or if you're lodging near the venue, let me know and we can meet up tonight)

[Dave Green CMgr FCMI @d_a_green]

Does anyone know if the #sqlbits agenda is on guidebook or a similar app? Trying to plan my Fri / Sat.

[Dave Green CMgr FCMI @d_a_green]

@JustSayNoToSpam either here or comments section is fine; it has been a while since I wrote it but the course content is still sound. How have you been getting on with unit testing SQL?

[Dave Green CMgr FCMI @d_a_green]

@GeraldBritton @redgate for sc tSQLt in SSDT, https://t.co/9XGG8FARyW (and https://t.co/IdKoSzF7ct ) may be helpful. Cc @EdDebug

[Dave Green CMgr FCMI @d_a_green]

@GeraldBritton @redgate SQL Compare has an option to ignore tSQLt framework and tests. Also a cmd line switch for continuous integration use

[Dave Green CMgr FCMI @d_a_green]

@EdDebug @JanMulkens thanks! Keen to see what's on @EdDebug tSQLt resources list, I'm always up for learning more.

[Dave Green CMgr FCMI @d_a_green]

@GeraldBritton ..it works fine, which is what I use for source control. Property name = 'tSQLt.TestClass',value = 1, create on schema.(2/2)