Ergun Ozyurt ergunozyurt

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ergunozyurt
                / keybase.md
            
            
              Created
              September 20, 2016 10:29
            
          
    Keybase proof

I hereby claim:

I am ergunozyurt on github.
I am ergunozyurt (https://keybase.io/ergunozyurt) on keybase.
I have a public key ASCE7l39N7aG1056oa28cter5if5AgwQ20e8LWHvfpSifgo

To claim this, I am signing this object:

  
## merge-delete
MERGE ResultRssDatas as TARGET
USING (select RssDataID as RssDataID, SYS_CHANGE_OPERATION as Operation  from changetable(changes RssDatas, 0) as ctt) as SOURCE
ON TARGET.RssDataID = SOURCE.RssDataID
WHEN MATCHED AND SOURCE.Operation = 'D' THEN
delete
WHEN MATCHED AND SOURCE.Operation = 'U' THEN
delete;--will be changed

## merge-insert.sql
MERGE ResultRssDatas as TARGET
USING  (SELECT

				RssDatas.RssDataID,
				NewsChannelCategories.NewsChannelCategoryID,
				NewsChannels.NewsChannelID,
				NewsChannels.Name as NewsChannelName,
				ChannelCategories.ChannelCategoryID,
				NewsChannelCategories.CountryID,
				NewsChannelCategories.LanguageID,

## simple_words.json
[
  "a",
  "able",
  "about",
  "above",
  "aboves",
  "accept",
  "accepted",
  "accepting",
  "accepts",

## find_the_key_in_multidimension_array.php
function searchArrayForKey($search,$array) {
    $foundArray= array();
    foreach ($array as $key => $value) {
        if($key === $search)
        {
            $foundArray = $value;
            break;
        }
        else
        {

## .bash_profile
#  ---------------------------------------------------------------------------
#
#  Description:  This file holds all my BASH configurations and aliases
#
#  Sections:
#  1.   Environment Configuration
#  2.   Make Terminal Better (remapping defaults and adding functionality)
#  3.   File and Folder Management
#  4.   Searching
#  5.   Process Management

## DeleteFilesAndFoldersOlderThanXDays.ps1
# set folder path
$dump_path = "d:\temp"

# set min age of files
$max_days = "-1"

# get the current date
$curr_date = Get-Date

# determine how far back we go based on current date

## DeleteOldFiles.bat
forfiles /P C:\fullpath\ /M "*.*" /D -30 /C "cmd /c del /s /q @file"

## MySQLFragmentedTables.sql
select TABLE_NAME, TABLE_SCHEMA, Data_free from information_schema.TABLES where TABLE_SCHEMA NOT IN ('information_schema', 'mysql') and Data_Free >0;
	[
	"a",
	"able",
	"about",
	"above",
	"aboves",
	"accept",
	"accepted",
	"accepting",
	"accepts",
	function searchArrayForKey($search,$array) {
	$foundArray= array();
	foreach ($array as $key => $value) {
	if($key === $search)
	{
	$foundArray = $value;
	break;
	}
	else
	{
	# ---------------------------------------------------------------------------
	#
	# Description: This file holds all my BASH configurations and aliases
	#
	# Sections:
	# 1. Environment Configuration
	# 2. Make Terminal Better (remapping defaults and adding functionality)
	# 3. File and Folder Management
	# 4. Searching
	# 5. Process Management
	# set folder path
	$dump_path = "d:\temp"

	# set min age of files
	$max_days = "-1"

	# get the current date
	$curr_date = Get-Date

	# determine how far back we go based on current date