Posted on Leave a comment

SQL Profiler

Is an optional component of Management Studio since SQL Server 2000 version, a graphical user interface to SQL Trace for monitoring an instance of the Database Engine .
Show you Transact-SQL SELECT, INSERT, UPDATE, and DELETE statements. An other error log
https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver15

It’s basically a four steps process:
Step 1: Generate a TRACE/LOAD file for selected database. Open SQL Server Profiler. And click in Play
Step 2: Put the cursor an click button in software ERP or LOAD information in Database
Step 3: Automatically show you the event and the name of table and field
Click in Stop and analyze all the information generate

This book talk about Mastering_Profiler_eBook.pdf spend a weekend reading and practicing, and you’ll have locked down the skills on the most important tool in the Sql toolbox.

Actually is a great tool , but have a significant problem a lot of information to analyze RPC event , TSQL , Security Audit

Actuall is Azure Data Studio to adopt Sql Profiler whit XE Extended Event
https://docs.microsoft.com/en-us/sql/azure-data-studio/sql-server-profiler-extension?view=sql-server-ver15
All the new features in SQL Server like Azure event is tracker by XE Extended Event https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events?redirectedfrom=MSDN&view=sql-server-ver15
This article talk about https://www.sqlshack.com/es/es-este-el-fin-de-sql-profiler/

The advantage XE is lightweight performance monitoring 

Posted on Leave a comment

Common Port

When think in security , always ,my conclusion, is easy hack a organization

Attack the well know port 1433 SQL server
I read this https://www.hackingarticles.in/mssql-peneration-testing-using-nmap/

Common Port

About syntaxis SQL injections

https://downloa

Solutions

Use this configuration a FIREWALL

d.oracle.com/oll/tutorials/SQLInjection/index.htm

Change default port https://www.ryadel.com/en/sql-server-change-default-tcp-1433-port-mssql/

Posted on Leave a comment

Searches Google 2019

 





Source Google
https://trends.google.com/trends/yis/2019/GLOBAL/Searches

https://youtu.be/ZRCdORJiUgU

Posted on Leave a comment

Add Captions ( Close captions) a Video

When your second language is English you need sometimes the subtitle for understand a movie or video, or translate, etc. Actually  lot of web page whit subtitle solution exist for movie

https://yifysub.org/,

 https://www.opensubtitles.org/en/search/subs, ,

 https://subscene.com/browse/popular/all/1 .

The most common format is .srt   SubRip  subtitle text file format created by this software http://zuggy.wz.cz/ Subrip if famous for  “rips” (extracts) subtitles and their timings from video

In August 2008, YouTube added subtitle support to its Flash video player under the “Closed Captioning” option – content producers can upload subtitles in SubRip format

 

Now is possibly generate a subtitle automatically, ONLY UPLOAD THE VIDEO in youtube ,

 The steps are basically

Open YouTube

Upload a video

Select the option CC

View published subtitles and CC: English (Automatic)

Also you can download the subtitle in format .srt

Name exact form of you video and enjoy!

 
 

Another software for editing subtitles is

www.aegisub.org › downloads
You add the timing and write line by line its more time consuming but learn more
Posted on Leave a comment

Docker

Docker is  an operating-system-level virtualization makes it easier to create and deploy applications in an isolated environment. A Dockerfile is a script that contains collections of commands and instructions that will be automatically executed in sequence in the docker environment for building a new docker image.

All sysadmin or developer  need a  specific configuration for a proyect version, dependecies users , for old school the solution is virtual machine  the principal difference  whit Docker is more lightweight

Prerequisites

I use Debian GNU Linux stretch for docker base image

root privileges

 

Below are some dockerfile commands you must know:

FROM The base image for building a new image. This command must be on top of the dockerfile.

MAINTAINER Optional, it contains the name of the maintainer of the image.

RUN Used to execute a command during the build process of the docker image.

ADD Copy a file from the host machine to the new docker image. There is an option to use an URL for the file, docker will then download that file to the destination directory.

ENV Define an environment variable.

CMD Used for executing commands when we build a new container from the docker image.

ENTRYPOINT Define the default command that will be executed when the container is running.

WORKDIR This is directive for CMD command to be executed.

USER Set the user or UID for the container created with the image.

VOLUME Enable access/linked directory between the container and the host machine.

 

Now let’s stat to create our first dockerfile.

Step 1

apt-get install docker

 

Create  Dockerfile, default start.sh and supervisord.conf

 

Step 3 – Build New Docker Image and Create New Container Based on it

The Dockerfile and all required config files have been created, now we can build a new docker image based on Ubuntu 16.04 and our dockerfile with the docker command below:

docker build -t nginx_image .

When the command completed successfully, we can check the new image ‘nginx_image’ with the docker command below:

docker images

Then we can try to create a new container based on nginx_images. And before create new container, we can create new directory on the host machine for the webroot data.

mkdir -p /webroot

Now run the new container with command below:

docker run -d -v /webroot:/var/www/html -p 80:80 --name hakase nginx_image

Then we can check that the new container with name hakase based on ‘nginx_image’ is running:

docker ps

Check if our Docker container is running

Note:

  • –name hakase nginx_image = We create a new container with the name ‘hakase’, based on docker image ‘nginx_images’.
  • -p 80:80 = hakase container running on port 80 on the host machine.
  • -v /webroot:/var/www/html = /webroot directory on the host machine rewrite the /var/www/html directory on the container.

The new container based on the nginx_image is running without error.

Step 4 – Testing Nginx and PHP-FPM in the Container

Try to create a new index.html file in the /webroot directory with echo:

echo '<h1>Nginx and PHP-FPM 7 inside Docker Container</h1>' > /webroot/index.html

Testing with curl command by accessing the host machine ip address.

curl 192.168.1.250
curl -I 192.168.1.250

We will see results below.

 

Next, test that PHP-FPM 7.0 is running by creating a new phpinfo file in the /webroot directory on the host machine.

echo '<?php phpinfo(); ?>' > /webroot/info.php

Open the web browser and type the host machine IP address:

http://192.168.1.248/info.php

Now you can see the output of the phpinfo file.

PHP-FPM is working nicely

the new docker image ‘nginx_image’ has been successfully created, now we can create more containers based on that image.

 

credits:https://www.howtoforge.com/tutorial/how-to-create-docker-images-with-dockerfile/

Posted on Leave a comment

Android Go, Kai OS light operating Systems

Cheapest smartphones (under $40 ) whit operating systems that’s optimized to run on devices with limited memory and internal storage.

KaiOS

is a U.S.-based project that started in 2017, built on the ashes of Mozilla’s failed Firefox OS experiment, as a fork of the Linux codebase. Early Google make investments for $22 million of dollars ,and KaiOS announced that it would be adding Google Search, Google Maps and the Google Voice Assistant , Twitter and Facebook work well In June 2019 bring whatsapp ,

It’s actually the second-most (before android) popular mobile phone platform in India,largely due to the success of the JioPhone range. KaiOS has also since made its way to the Nokia 8110 4G, prepaid feature phones in North America, and now Africa via Orange and MTN handsets.

Device whit KaiOS work whit chip Qualcomm, UNISOC , MediaTek and snapdragon, and don’t have touch screen

https://www.kaiostech.com/meet-the-devices-that-are-powered-by-kaios/

This phones require limited memory RAM:256MB max 512MB

A Simulator of KaiOS on linux

Android GO Edition

The goal is pursuit next billion users ( India and Africa)

Android Oreo 8.1 version GO

require limited memory RAM: 1 GB

Price :$62.41 Xiaomi Redmi Go 

Price $55.46 Nokia 1 gets price cut in India, beats Redmi Go and upgrade to Android 9 Pie

Alcatel 1 $51.90

Google dominate the market in phones whit Android ,  whit this version of Android GO , phone are accessible for more user. The next update of Android was 3 Sep 2019 codename Q ,  maybe have another Android Go Q

Posted on Leave a comment

LoTR

Today I talk about the epic novel, video games, films and future release of tv series, the fantasy masterpiece The lord of the rings trilogy and The Hobbit by J.R.R Tolkien

The books

Download link

http://users.softlab.ntua.gr/~sivann/books/the-lord-of-the-rings-collection.pdf

The Hobbit was published in 1937 and was regarded as a children’s book

LoTR , Tolkien released part one of the series, The Fellowship of the Ring, in 1954; The Two Towers and The Return of the King followed in 1955, finishing up the trilogy

The posthumous books The Silmarillion, Luthien and Beren’s, The Histories of Middle Earth and  The fall of Gondolin

Luthien and Beren’s story echoes the real author’s love story even more so though as the pair went through plenty of their own trials before getting their happy ending.

The Films

The Rings trilogy was also adapted by director Peter Jackson into a highly popular, won 17 Oscar,   the final film, Lord Of The Rings: The Return of the King picked up 11 Oscars, winning in all the categories it was nominated for including Best Picture.  starring Ian McKellen, Elijah Wood, Cate Blanchett and Viggo Mortensen, among others. Jackson also directed a three-part Hobbit movie adaptation starring Martin Freeman,  A fan Edit rings trilogy is called The purist Edition

come to the streaming service Netflix in 2019, 17 year after the first film release

 

 

The video games

I played the first and  second of EA’s brawlers based on Peter Jackson’s film trilogy was in 2003 a very nice looking games included short videos of the movie and the voice of the real actor of the film

SHADOW OF MORDOR  WB´s

its stealth murder and orc friendship system makes up for this

https://steamcdn-a.akamaihd.net/steam/apps/212500/ss_ebaf14b81c2c35b1eedc2137331f8e6ba95a1afc.1920×1080.jpg

 

 

https://vandal.elespanol.com/busqueda/lord-of-the-rings:juegos

 

Posted on Leave a comment

The Terminator franchise

I born in 1984 , my entertainment was nintendo, anime dragon ball and movies like terminator. The  first and second movies are great Directed by James Cameron , nobody discuss about the director. My wife brings a toy collection  of terminator 1for the birthday of my son, she bought in wallmart  1977 Dodge Monaco Metropolitan Police , automatically remember the franchise

Terminator 3: The Coming Storm (fan edit movie) https://ifdb.fanedit.org/terminator-3-the-coming-storm/ ,  basically cut ridiculous scenes , attempts to maintain the tone of the first two films, i enjoyed , recommend  movie

link:

https://drive.google.com/open?id=1mg8DBcGMXnNU3tWU0X1OW_sCqBRobkC5

Posted on Leave a comment

How to Clone HDD to small SSD whit proper care in recovery,boot,tools partitons

Change your principal HDD for SSD is one of the best upgrade for your computer

The scenario is new SSD 512 GB for laptop HP whit WIN 10 and HDD 1.TB ,caddy Drive for connect HDD in DVD ROM

Is relative easy clone a disk whit program like Acronishttp://www.acronis.com or AOIME http://www.aomeitech.com boot work in visual environment

The unique problem is the capacity of SSD have less capacity of storage. And software solution is reduce free espace in each partition whit Align partition to optimize your SSD but the result is a diferent size in partition tables and the Recovery dont work propely

In this case i recomended 3 different clone software :clonezilla (show the exact partition table and clone faster partition ) . gparted (create and rezise table partition ,visual mode) symantec ghost for 1 particular partiton the principal 790 GB clone slow but only data.

1.Use a usb whit clonezilla for show the actual partition table

fdisk -l /dev/sda

create the exact partition table is imposible because a large disk 1TB dont fit in small

2.Usb whit gparted help to graphic create manual and visual enviroment the partition table( 5 partition in Total) your guide is the Start and End of the actual HDD partiton table

First partiton 270 Mb is important the filetype .second 16 Mb. Third a 790 Gb decide reduce because only have 512Gb and this partition is Windows and you need 980 mb for the four and 14.9 GB for recovery.

I use a calculator for the space

512GB minus 14.9GB(recovery) -minus 1.3 GB (sum of another partitions) the windows partition result is 495GB . i create this table partition and clone 4 of 5

For the windows partition. i use symantec ghost ,clone only data and dont resize partiton

All your partition work correct like a charm