![fdzjuba](/img/default-banner.jpg)
- 18
- 634 676
fdzjuba
United Kingdom
Registrace 8. 11. 2011
SQL Server, Web Apps, .Net and Linnworks.net development tutorials
Warehouse Management System (WMS) Basics - LA19 Talk
What is warehouse management system in a nutshell. Attempted to make it less of a dull subject to absorb. The talk recorded at Linn Academy 2019, October, Birmingham UK
zhlédnutí: 565
Video
Linnworks.net - Shipping Integration extension - Part 2
zhlédnutí 1,1KPřed 8 lety
In this session we cover how to create and deploy Shipping Integration Extension in linnworks.net Apologies about the sound, can't fix it now I am afraid. GitHub source code is here github.com/fdzjuba/TemplateProxy
Linnworks.net - Shipping Integration extension - Part 1
zhlédnutí 3,3KPřed 8 lety
In this session we cover how to create and deploy Shipping Integration Extension in linnworks.net Apologies about the sound, can't fix it now I am afraid. GitHub source code is here github.com/fdzjuba/TemplateProxy
Linnworks.net API - External Application permanent token postback - Part 3
zhlédnutí 2,3KPřed 8 lety
In this screencast we will expand previously developed external application which is embedded into linnworks.net and enable permanent API token postback to our application when the user installs the application
Linnworks.net API - External User Interface Application development - Part 2
zhlédnutí 2,7KPřed 8 lety
In this session we will explore how to deploy external user interface application in linnworks.net and perform session authorization.
Single Page Application in AngularJS - Tutorial 3 - sessions, securing, deploying to linnworks.net
zhlédnutí 5KPřed 8 lety
In this video we introduce basic session management for the purpose of authentication with Linnworks.net API, make calls to linnworks.net API to get the data from the system and at the end embed our web application into linnworks.net Source code is here: github.com/fdzjuba/LowStockDashboard3
Single Page Application in AngularJS - Tutorial 2 - adding WebAPI MVC web service using $http
zhlédnutí 14KPřed 8 lety
In this tutorial we will look at how to add server side web service to our angularjs web app. We are using .net MVC5 to add controllers for HttpPost and HttpGet and consume these service endpoints from our AngularJS app. We also doing some UI work, adding waiting glyph (spinny thing) to components that are awaiting data from the webservice and implementing some very basic error handling in our ...
Single Page Application with AngularJS and .net MVC - Tutorial 1 - web app for linnworks.net
zhlédnutí 48KPřed 8 lety
.Net MVC5 for Web API and containment of the application AngularJS for the frontend Very simple and quick way to create an app This is Session 1 of 3 Code is on GitHub: github.com/fdzjuba/LowStockDashboard
SQL Server + .Net - Tutorial 1 - SqlCommand, SqlReader, Business Logic data adapter
zhlédnutí 2KPřed 9 lety
This tutorial introduces Sql Server coms from within .Net application. Here we demonstrate how to connect to the server, execute SELECT and bind data to an object. How to execute Stored Procedure and discuss connection pools.
SQL Server Tutorial - Part 9 - Triggers, AFTER, INSTEAD OF
zhlédnutí 9KPřed 10 lety
Tutorial shows the basics of a table trigger for AFTER transaction, and INSTEAD OF
SQL Server Tutorial - Part 8 - SP, schema, MERGE and OUTPUT
zhlédnutí 9KPřed 10 lety
Stored Procedure user defined table type, schema permission execute,MERGE with OUTPUT
SQL Server Tutorial - Part 7 - Views, user-defined functions, Stored Procedures
zhlédnutí 11KPřed 10 lety
Looking at basics of Views, user-defined functions as scalar return and table return stored procedures
SQL Server Tutorial - Part 6 - GROUP BY, SUM, COUNT(DISTINCT )
zhlédnutí 12KPřed 10 lety
SQL Server foundation - Part 6 - GROUP BY, SUM, COUNT(DISTINCT )
SQL Server Tutorial - Part 5 - subqueries, WITH, ROW_NUMBER(), join hints
zhlédnutí 14KPřed 10 lety
subqueries, WITH, ROW_NUMBER(), join hints
SQL Server Tutorial - Part 4 - Alieses, Expressions, ORDER BY, TOP, subqueries
zhlédnutí 19KPřed 10 lety
Working with AdventureWorks, Table alieses, expressions, ORDER BY, TOP and subqueries. Exploring Execution Plans as we go along.
SQL Server Tutorial - Part 3 - RDBMS, Relational Algebra, Selection, Join, Union, Intersect
zhlédnutí 31KPřed 10 lety
SQL Server Tutorial - Part 3 - RDBMS, Relational Algebra, Selection, Join, Union, Intersect
SQL Server Tutorial - Part 2 - Data Types, RDM, Normalization, Primary and foreign keys
zhlédnutí 70KPřed 10 lety
SQL Server Tutorial - Part 2 - Data Types, RDM, Normalization, Primary and foreign keys
SQL Server Tutorial - Part 1 - Basics, Installing, User/Roles, Database file structure and anatomy
zhlédnutí 382KPřed 10 lety
SQL Server Tutorial - Part 1 - Basics, Installing, User/Roles, Database file structure and anatomy
Watch this video after 6 years . I am a legend
Hi, how can we find/design the permanent token in shipping integration development?
This SQL Server 2012 Course has helped me reduce my time in error handling in SQL 2012. All my basics are now crystal clear. Now I utilize my time and increase my productivity.www.skillscourses.org/MS-SQL-Server-2012-Administration.html
Hi Fedor, it was good to meet you at the Linnworks Academy! A video like this on how to set up the SDK with Visual Studio and creating a basic macro would be of much help to us beginners!
Hi, Dave. Likewise. One of the developers at Linn promised to the video guides for macro developing soon. Meanwhile there is a step-by-step guide here: github.com/LinnSystems/LinnworksNetSDK/wiki/Macros
AdentureWorks is public database made by microsft which u can find in google and download it for free
If You are having a hard time with the low volume, I suggest you download a Volume Booster extension for Chrome or any other browser you are using . It will help with any video you are having trouble with. Below are a few options to check out from the Chrome store. chrome.google.com/webstore/detail/volume-master/jghecgabfgfdldnmbfkhmffcabddioke chrome.google.com/webstore/search/volume%20booster?_category=extensions Hope this helps.
Closed captions would be VERY helpful!
It's tuple not tupel
Very well articulated. Thank you for keeping your listeners' comprehension in mind. I was able to follow everything you did. Thank you very much. I'm looking forward to my database management class this next semester!
i guess I'm kinda randomly asking but does anybody know of a good website to watch new movies online?
Even though I had the links for bootstrap and angular, for the actual downloads that you showed on screen I was left scrounging around for them. (angular-chart.min, etc.). To me that is one of the most frustrating things in learning any of this. If people design code well it's easy to follow. However, without a proper explanation of how and where exactly to download the prerequisites, people are lost. It's not just you. A lot of developers brush over or skip this crucial step in explanation.
Thankful I did actually see the files on your GitHub. I was able to get the bootstrap files from bootstrap, but not so much to find the angular chart files, until I went to your GitHub account.
2billionseconds where did you find angular-chart.min?
Useful and very interesting, thanks!
good job i love it
Very very good, thank you. Keep up the good work.
Thanks.... But Please make it in full screen...
Thanks sir for your great help.
thumbs up
thumbs up
great job
thanks for this
Good content and very helpful; however, the sound quality (aside from the cougher) was marginal at best. I had a hard time following the conversation b/c every time you turned your head the volume and clarity of your voice diminished. I had to rewind and re-watch several segments multiple times. Suggest using a dedicated microphone for better sound quality which would also minimize the interruptions from audience noise.
PL-SQL and Transact-SQL are scoring the very similar special casus for keyword SELECT. Instruction SELECT...FOR XML (by attributes like RAW, AUTO or Explicit similar to the common on whole SQL COMMIT and ROLLBACK and implicite-explicite in C++) is able to check whole ontology (including XML Schemas) and validate informations even same good as scrpit by Perl, Ruby on Rails, Python or Jython (the etc) ... UNION and UNION ALL are same on both Oracle and Microsoft version. Personally I do not know how by PL-SQL can be check or search XML information datagram document, but SELECT INTO is very similar to this case, which can be used similar to the Trigger. Excellent as sum up can be introduction to LINQ, best as always are free compilers, parsers and validators on our WWW`s ... Before ontologies we had LISP, DATALOG and PROLOG ... Knowledge data bases and data mining is the future, but also alredy done and implemented ...
Hello, videos are very helpful thanks. I have a question regarding access, I attempted to create a database and I received an error - states " denies permission to create database error code 262.
nice
Are you going to post on indexing or any other SQL tutorial?
you illustration is beyond excellent. But I do have a question though. During the login creation of superadmin, it gets created successful, but when i open a new SSMS, it refuses to connect. In the additional information, it says the login was successful, but there was no pipe. I couldnt understand the message. Same issue came up when I created the user_changeman. Same message was displayed. please give me advise, how can i fix this issue? Best regards and your illustration is exceptionally amazing. Thanks a lot.
How is the coughing guy closer to the microphone than the speaker?
thank you sir! your better than my prof. and can you do basic coding fundamental concepts. thank you.
If anyone else is having trouble with the modal, then try adding windowClass: 'show', backdropClass: 'show' after the resolve parameter of the $uibModal.open function, like this: animation: true, templateUrl: '/SPA/Views/ViewProductWindow.html', controller: 'ViewProductController', size: "", resolve: { data: block }, windowClass: 'show', backdropClass: 'show'
Thanks for an amazing tutorial! I'm having trouble displaying the modal, though. It renders beneath the rest of my site. Apparently this is a common problem where the module is rendered inside another element with fixed or relative positioning, but as it is a dynamically generated module, I have no idea how I would move the modal outside of its parent elements. Please could you explain how I would make this work? Thanks!
If only he would quit hitting the table.... Can't even make it to the dude coughing because the banging is driving me nutso. Oh well. I bet it was a good lesson.
Has to be the smoothest example of a web api for mvc i've come across, well done!
when you click download on the windows page, which file should you download to install? theres like 20 in the list
thanks it helped.
Hi I get a http 404 error? I cannot find the right solution to solve can you help? Regards
Thank you for this tutorial
This tutor tries, but not hard enough. Fair job, but he is lazy, seems bored or uninterested. Where is the energy bro, BORING! Dan albergetthi and Eli the computer guy should give this tutor some lessons in effective delivery and enthusiasm. You skipped the installation process, especially for people who doesn't know how to do it well. I am systems engineer, so no problem for me, but you need to cater for all bro! Do better next time.
Video is great; sound quality worse, Tutor is worst
when i want to connect to server it has error 161
if this didn't work var App = angular.module('App', []); App.controller('MainController', 'MainController'); try var App = angular.module('App', []); App.controller('MainController', MainController);
Definitely helpful. Thank you!
Thank you my friend.
I just installed the Server Management Studio my question is how to create a server to play around on. Thanks in advanced.
Great tutorial! I have a question about this line: var ViewProductController = function ($scope, $uibModalInstance, data) { Why do the first 2 arguments have a $ sign, and the 3rd one doesn't. Sorry I am new to angular...but this is why i came to your tutorial ;)
@fdzjuba can you or someone help me please? once i change the path to c:\sqldata and the other to c:\sqllog @15:53 and hit I okay, i get the error message - Created failed for Database 'newdatabase'. An exception occured while executing a Transact-SQL statement or batch Directroy lookup for the file "c:\sqldatabase ewdatabase.mdf" failed with the operating system error 2(the systek cannot find the file specified.). CREATE DATABASEE failed. Some file names listed could not be created. Check related errorrs. (Microsoft SQL Server, Error:5133) Please help! I couldnt find any solutions online!!
Hi, very helpful tutorial.But I have a problem - "Cannot connect to .\SQLEXPRESS.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233". This happens when I start the program and try to log in with superadmin or user_changeman. I did the same thing as You and I downloaded and installed Sql server and MSQLMS as I watched the video so I dont know what is the problem.Any help?
Thumbs up for Dota2 : ) . Just joking, great tutorial series, I learnt a lot from your videos.
Thanks for sharing, I had issues with creating a superuser with failed to logon but I had to restart the sql server(mssqlserver service) which fixed the login problem
Hi, Your presentation is very good..clear and understandable. I downloaded SQL Server Express 2014. Connected as Windows Authentication. Then Setup the superadmin login etc . per your instruction. Then when I ran another instance of the Manament Studio and tried to connect to it using the Sql Server Authentication and the superadmin login I created, it is giving me this error - "A connection was successfully established with the server, but then an error occurred during the login process(provider:shared Memory provider, error 0 - No process is on the other end of the pipe.) (Microsoft SQL Server Error: 233). No process is the other end of the pipe" Please help..!
Try to set Server authentication to "SQL Server and Windows Authentication Mode" , this setting can be found under Server properties->Security
I fixed this by going into SQL Server Configuration Manager and enabling the Named Pipes and TCP/IP protocols. Then I restarted the SQL Server service, reopened SQL Server Management studio, refreshed the server (right click the server in the left-hand menu and click "refresh"), and I was able to login. Also, go to the Server properties and select "SQL Server and Windows Authentication mode" under Security (this alone usually fixes the problem, but if not follow the steps above). I hope that helps anyone having the same problem.
Very helpful and clear explanations
it was a nice video