Skip to content

Instantly share code, notes, and snippets.

Avatar

Pavel cpoDesign

View GitHub Profile
@cpoDesign
cpoDesign / searchForIndexByTableAndIndexName.sql
Created Feb 26, 2019
Find an index with a specific name
View searchForIndexByTableAndIndexName.sql
select * from sys.tables as t
inner join sys.columns as c
on t.object_id = c.object_id
inner join sys.index_columns as ic
on c.column_id = ic.column_id and c.object_id = ic.object_id
inner join sys.indexes as i
on ic.index_id = i.index_id and ic.object_id = i.object_id
WHERE t.name = 'table_name' AND i.name = 'index_name'
-- where t.name = 'table_name' and c.name = 'column_name'
View API-wrapper.cs
public partial class ApiClient
{
private readonly HttpClient _httpClient;
private Uri BaseEndpoint { get; set; }
public ApiClient(Uri baseEndpoint)
{
if (baseEndpoint == null)
{
@cpoDesign
cpoDesign / project.nuspec
Created Sep 8, 2018
Project setup for .net core showing how nuspec will get updated as part of a build
View project.nuspec
<?xml version="1.0" encoding="utf-8"?>
<package xmlns="http://schemas.microsoft.com/packaging/2010/07/nuspec.xsd">
<metadata>
<id>project</id>
<version>0.0.1</version>
<authors>authors</authors>
<owners>Owners</owners>
<requireLicenseAcceptance>false</requireLicenseAcceptance>
<description>package desciptions</description>
</metadata>
@cpoDesign
cpoDesign / gist:26482f97e2dc8e35625bcd7b08cafb54
Created Aug 16, 2018
How to get client list with all auth. keys to be served to a list of services. using token for authentication. This presents how-ever security risk as all active configuration is presented at once.
View gist:26482f97e2dc8e35625bcd7b08cafb54
/// <summary>
/// used to provide definition for gateway service about active keys for clients, to about active client configuration
/// </summary>
/// <param name="token"></param>
/// <returns></returns>
[HttpGet]
public IActionResult GetClientList(string token)
{
if (ValidateToken(token))
{
@cpoDesign
cpoDesign / ForceRequestToSpecificIPandPort.cs
Created Jun 1, 2018
Force request to specific IP address and port
View ForceRequestToSpecificIPandPort.cs
string sendingIp = "192.168.0.1";
int sendingPort = 5000;
Uri uri = new Uri("http://google.com");
HttpWebRequest wr = (HttpWebRequest)WebRequest.Create(uri);
ServicePoint sp = ServicePointManager.FindServicePoint(uri);
sp.BindIPEndPointDelegate =
(servicePoint,remoteEp,retryCount) =>
{
return new IPEndPoint(IPAddress.Parse(sendingIp),sendingPort);
};
@cpoDesign
cpoDesign / PublishBuildArtifacts.yaml
Last active May 30, 2018
Break apart powershell arguments dynamically
View PublishBuildArtifacts.yaml
steps:
- task: PublishBuildArtifacts@1
displayName: Publish Artifact: DynamicPowerShellArguments
inputs:
PathtoPublish: test.ps1
ArtifactName: DynamicPowerShellArguments
publishLocation: Container
@cpoDesign
cpoDesign / tester.exe.config
Created Apr 27, 2018
Sample for configuration string
View tester.exe.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
</startup>
<connectionStrings>
<add name="ConnectionStringUnderTest" connectionString="Data Source=localhost;Initial Catalog=MyDatabaseCatalogToReplace;Integrated Security=True" />
</connectionStrings>
<appSettings>
<add key="CommandTimeOut" value="90"/>
@cpoDesign
cpoDesign / cntlm.ini
Created Apr 20, 2018
CNTLM configuration ini file
View cntlm.ini
Username user
Domain domain
# provide actual value if autodetection fails
# Workstation pc-name
Proxy my_proxy_server.com:80
NoProxy 127.0.0.*, 192.168.*
Listen 127.0.0.1:54321
@cpoDesign
cpoDesign / SQL2016DropIFExistsNew.sql
Last active Jan 23, 2018
SQL 2016 new way of checking if exists
View SQL2016DropIFExistsNew.sql
DROP TABLE IF EXISTS dbo.Product
DROP TRIGGER IF EXISTS trProductInsert
DROP PROCEDURE IF EXISTS [dbo].[InsertData]
@cpoDesign
cpoDesign / SQLDropIFExistsOld.sql
Created Jan 17, 2018
Old way of checking if item exists before drop
View SQLDropIFExistsOld.sql
IF EXISTS(SELECT 1 FROM sys.objects AS O WHERE O.name = 'Product' AND O.[type] = 'U')
BEGIN
    DROP TABLE [SomeTable]
END
 
IF OBJECT_ID('dbo.Product', 'U') IS NOT NULL
BEGIN
DROP TABLE dbo.Product;
END
You can’t perform that action at this time.