Skip to content

Instantly share code, notes, and snippets.

View ertugrulozcan's full-sized avatar

Ahmet Ertuğrul Özcan ertugrulozcan

View GitHub Profile
@ertugrulozcan
ertugrulozcan / sqlserver_on_docker.md
Last active December 22, 2019 14:11
Sql Server on Docker

Sql Server on Docker

Install

sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<PASSWORD>' -p 1433:1433 --name <IMAGE_NAME> -d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
Verify Installation
> Connection 1 Establishment - TCP Three-Way Handshake
> Connected to 0.0.0.0
--Request--
GET /project.html HTTP/1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36
--Response--
HTTP/1.0 200 OK
Content-Type: text/html
Content-Length: 171672
Expires: Thu, 01 Dec 1997 16:00:00 GMT
$ telnet info.cern.ch 80
> Connection 1 Establishment - TCP Three-Way Handshake
> Connected to 0.0.0.0
--Request--
GET /project.html
--Response--
<html>
A very simple HTML page
</html>
> Connection 1 Closed - TCP Teardown
@ertugrulozcan
ertugrulozcan / osi.csv
Created August 26, 2019 19:48
osi.csv
OSI Layer Protocol
Application Layer (Uygulama Katmanı) HTTP, DNS, SMTP, FTP, TFTP, UUCP, NNTP, SSL, SSH, IRC, SNMP, SIP, RTP, Telnet, ...
Presentation Layer (Sunum Katmanı) ISO 8822, ISO 8823, ISO 8824, ITU-T T.73, ITU-T X.409, ...
Session Layer (Oturum Katmanı) NFS, SMB, ISO 8326, ISO 8327, ITU-T T.6299, ...
Transportation Layer (Ulaşım Katmanı) TCP, UDP, SCTP, DCCP, ...
Network Layer (Ağ Katmanı) IP, IPv4, IPv6, ICMP, ARP, IGMP, IPX,...
Data Link Layer (Veri Bağlantısı Katmanı) Ethernet, HDLC, Wi-Fi, Token ring, FDDI, PPP, L2TP...
Physical Layer (Donanım Katmanı) ISDN, RS-232, EIA-422, RS-449, EIA-485, ...
@ertugrulozcan
ertugrulozcan / ExcelCostume.xaml
Last active June 24, 2018 01:23
Telerik RadGridView Excel Costume
<UserControl x:Class="Test.Common.Components.ExcelCostume"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:local="clr-namespace:Test.Common.Components"
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="300"
IsHitTestVisible="True">
CREATE DATABASE `VtysLabDB`;
SHOW DATABASES;
USE `VtysLabDB`;
SHOW VARIABLES LIKE 'character_set_database';
SHOW TABLES;
SELECT * FROM information_schema.routines WHERE routine_schema = 'VtysLabDB' ORDER BY routine_name;
SHOW TABLES IN information_schema LIKE 'ENGINES';
CREATE TABLE `ClientMaster` (
<UserControl x:Class="Eigen.Modules.Main.Components.ScreenSwitcher"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:local="clr-namespace:Eigen.Modules.Main.Components"
xmlns:converters="clr-namespace:Eigen.Infrastructure.Converter;assembly=Eigen.Infrastructure"
xmlns:fa="http://schemas.fontawesome.io/icons/"
mc:Ignorable="d"
d:DesignHeight="50" d:DesignWidth="300"
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Eigen.Infrastructure.Search
{
public class Node
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;
namespace stok_takip
{
partial class stoga_giris
{
using System;
using System.ComponentModel;
using System.Windows;
using System.Windows.Threading;
using WpfDialogManagement.Contracts;
using WpfDialogManagement.Manager;
using WpfDialogManagement.Views;
namespace WpfDialogManagement.Dialogs
{