-
![]()
Unity Collaborate
In Unity you can create a team and work together at one project. Just go to Unity Organizations Page and create new team. Then you can create new project or open existing one. Go to Window > General > Services. At the top right corner click "Сollab" and make your first commit. Now you can… -
![]()
Git configuration and first push
Navigate to the local project directory and create a git repository: git init To add all files to next commit, run following: git add . To check git status, use this: git status Run command to make your first commit: git commit -m "Your comment" Setup link to your github repository and push changes: git… -
![]()
Useful angular commands
Create a new angular project ng new Update application and it's dependencies ng update For development, start the app at localhost:4200 ng serve --open Generate new component ng generate component [component name] Install in-memory Web API npm install angular-in-memory-web-api --save Publish Angular to Azure -
![]()
SQL query for today’s date minus year, month, day or minute
To add or subtract some date/time you can use MS SQL function: DATEADD(datepart, number, date) Let's say you need to add five months to current date, use this: SELECT * FROM YourTable WHERE YourDate < DATEADD(month, 5, GETDATE()) I used function GETDATE() for getting current DateTime. If you need to subtract some time, just add… -
![]()
How to select first row in each group ordered by some columns
I'm just gonna show you an example how to select first row in each group of logins ordered by IsActive and Created columns, hope you will realise how it works. For example i have a table: Id | Login | IsActive | Created 1 | test1 | 1 | 2016-01-01 2 | test1… -
![]()
Adding Resharper Code Quality Analysis to TFS/VSTS
To improve code qulaity of your project is't good to check every build with some analyzing tool such as Resharper Code Quality Analysis. Install Resharper Code Quality Analysis Now you have to add additional step to the build definition of your project after build step, like this: Then you need to set "Path to .sln… -
![]()
Add event log source in Windows
Run powershell as Administrator and run following command: New-EventLog -Source "TestApi" -LogName "Application" -
![]()
Setup WebClient timeout in PowerShell
If you want to setup timeout value for downloadString method of WebClient Class in PowerShell, you need to extend WebClient Class, because property Timeout isn't public. So, in the next example I inherited new ExtendedWebClient Class from WebClient Class. And I add public field Timeout to the new class. Then I overrode GetWebRequest Method to use… -
![]()
Windows App Certification Kit doesn’t work in Windows Server 2016
I develop Universal Windows Programs and found an interesting problem. You can't use UI version of Windows App Certification Kit when your OS is Windows Server 2016. When I tried to test my program before send it to Windows Store, I got an error from Windows App Certification Kit: But we can still use console app – appcert.exe… -
![]()
Start of month from date in MS SQL (opposite to EOMONTH function)
Sometimes we need to select values grouped by month from MS SQL Table. Probably the easiest way to do it is to call function DateAdd with DateDiff: SELECT Sum(YourColumn), DATEADD(month, DATEDIFF(month, 0, [YourDateColumn]), 0) as 'Date' FROM YourTable GROUP BY DATEADD(month, DATEDIFF(month, 0, [YourDateColumn]), 0); Or we can use EOMONTH function that give us date that is…
Loading posts...
