Skills needed to be a data scientist

Data science is a broad and fast-moving field spanning maths, statistics, software engineering and communications. Data scientists will often work as part of a multidisciplinary team, using data and analytics to inform and achieve organisational goals. In this role, you will: be inquisitive explore and visualise data make recommendations to address complex problems and to … Read more

Size all tables in volume

DECLARE @name VARCHAR(128) DECLARE @myList TABLE ([row] int, [id] int,[Name] VARCHAR(128)) ; DECLARE @myResult TABLE ([row] int, [Name] VARCHAR(128), [Value] VARCHAR(128)) ; INSERT INTO @myList ([row], [id], [name]) SELECT row_number() OVER(ORDER BY o.name), o.id, o.name FROM dbo.sysobjects o join sys.all_objects syso on o.id = syso.object_id where o.name like ‘f_uks_%’ and type_desc = ‘USER_TABLE’ DECLARE @total … Read more

rukovoditel.net licence key

rukovoditel.net licence keycode(x) * (len(domain)+code(0))localhost126361298711583113491263612168129871345513572l 108 9 108 12636o 111 9 108 12987c 99 9 108 11583a 97 9 108 11349l 108 9 108 12636h 104 9 108 12168o 111 9 108 12987s 115 9 108 13455t 116 9 108 13572 vip.dev.helastel.net1628414490154566348138001393816284634814352139381490413386158701600813938149046348151801393816008v 118 20 118 16284i 105 20 118 14490p 112 20 118 15456. 46 … Read more

myHelastel install

myHelastel is based on an app called Rukovoditel https://www.rukovoditel.net/ Download https://www.rukovoditel.net/download.php?action=download un-pack this in <host www> source folder MySQL Requires mySQL database Database details are in config/database.php Extension the extension is the ‘pro’ component and this is where the /plugin folder becomes active extn 3.2.1 https://www.rukovoditel.net/download_ext.php?t=1668071540 un-pack this in the folder/plugin This requires a licence … Read more

Project Status

Create Table CREATE TABLE [dbo].[d_status]( [id] [int] IDENTITY(1,1) NOT NULL, [source_id] [int] NULL, [parent_code] varchar NOT NULL, [linked_id] [int] NULL, [created_date] [datetime] NULL, [modified_date] [datetime] NULL, [authored_by] varchar NULL, [sort_order] [int] NULL, [item_status] [int] NULL, [item_code] varchar NOT NULL, [item_desc] varchar NULL, [item_label] varchar NOT NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (STATISTICS_NORECOMPUTE = … Read more

Item status

Please see above a new Table for Status Firstly, is this in the correct schema ? as it is set to manage the status category of each of the d_dimension tables The layout is of my own devising, but is set to be the way I would create any entity/dimension and is of a form … Read more