Skip to content

Instantly share code, notes, and snippets.

Pavel cpoDesign

Block or report user

Report or block cpoDesign

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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.