Posted on Leave a comment

Python

https://netflixtechblog.com/python-at-netflix-bba45dae649e

How long has Python been in use? The programming language Python was conceived in the late 1980s https://www.python.org/

Netflix have 182 million paying streaming subscribers worldwide, and this articule describe , how big comapny is using python

The framework Metaflow for Machine Learning Infrastructure , is very usefull

In linux , python is the ADN , only you open a Terminal and type python

This is HTML5 web console for practice

this guide for basic command

https://www.stem.org.uk/resources/elibrary/resource/35836/python

Posted on Leave a comment

Connect Remote User

In the question in survey. Who led the digital transformation of your company?
A)CEO
B)CTO
C) COVID-19

All companies for prevent COVID-19 infections in EL Salvador should sent to word at home 50% employees

And the first step is Connect Users for task

Al IT Technician know the Server Windows has Remote Desktop Acees.
I explain a method to use multiples connection without paid CALS“>CALS

Remote Desktop Connections for Multiple Users on Windows RDPWRAP

https://github.com/stascorp/rdpwrap


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