Author Archives: Andrew Butenko

About Andrew Butenko

https://www.mcpvirtualbusinesscard.com/VBCServer/a9939be0-be6f-4249-a775-6665eccff2e4/card https://www.microsoftvirtualacademy.com/Profile.aspx?alias=530492

Do not run this in production!

Some actions are dangerous for a production environment. How to guarantee that action applied in a test environment only? Here is the example of TSQL script checking if the current database has “_Test” suffix (it could be server name, or variable, … Continue reading

Posted in SQL | Leave a comment

How to customize password generation

You can use standard random function call [Reflection.Assembly]::LoadWithPartialName(“System.Web”) [System.Web.Security.Membership]::GeneratePassword(8,2) # (lengh,complexity) In that case, you get simple but unpredictable range of symbols which can conflict with your password policy. Or you can customise it using specific logic. For example, you need at least 1 symbol … Continue reading

Posted in PowerShell | Leave a comment

Oh My Search

I really love search. It is part of my life. I use it everyday as a way of knowledge. And that is not Google about. The most tricky one is corporate search. It varies, is not consistent, and depends. It depends … Continue reading

Posted in Search | Leave a comment

Join Arrays

In SQL we use join day by day. But what if we need to intersect and sort 2D arrays directly in c#? Here is my example how to join person and donut by donut type. Including * for person who likes … Continue reading

Posted in C#, SQL | Leave a comment

Project Oxford: Computer Vision API pros & cons

Microsoft project code named Oxford has number of interesting APIs. Let’s dig into one of them – OCR. Computer Vision API provides OCR conversion from images to text. It could be tested from here. It is really fast, but requires understanding of the subject. … Continue reading

Posted in Uncategorized | Leave a comment

All date formats in one query

WITH N0 as (SELECT 1 as n UNION ALL SELECT 1) ,N1 as (SELECT 1 as n FROM N0 t1, N0 t2) ,N2 as (SELECT 1 as n FROM N1 t1, N1 t2) ,N3 as (SELECT 1 as n FROM … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

OpenProj free project managment example

“OpenProj” is a project management application similar to Microsoft Project. It includes most of the features of Microsoft Project but is free. It could be used : if you need to view a Microsoft Project file and do not have … Continue reading

Posted in PowerShell, SQL | Leave a comment