- Видео 41
- Просмотров 13 176
Artfull Coder
Добавлен 27 июл 2023
i am a full stack engineer coving a range of subjects with a range of hobbies, feel free to check out my website www.kevarni.co.uk
Artfull Coder - SQL where, in and exists clauses
In this video I show you the difference between where, in and exists clauses and why you would use them and some best practices in SQL server and SSMS 2022 #sql #sqlserver #ssms
Просмотров: 37
Видео
Artfull Coder - Ordered SQL View
Просмотров 21Месяц назад
In this video I show you how you can create an sql view that is ordered by a given column with a simple hack. Using SQL server and SSMS 2022. #sqlserver #ssms #sql
Artfull Coder SQL Series what is a CTE
Просмотров 323 месяца назад
In this video I discuss what a CTE (Common Table Expression) is and how to use them. We go through a journey together to see what does and doesn't work in SQL server 2022 and SSMS. #sql #ssms
Artfull Coder - SQL Views
Просмотров 483 месяца назад
In this video cover how to create and use SQL views in SQL server 2022 developer edition with some top tips and theory behind ways in which you would use them. #sql #sqlserver #sqlviews
Artfull Coder - SQL Stored Procedures
Просмотров 383 месяца назад
In this video using SQL server 2022 and SSMS I show you how to create and amend a stored procedure returning its conditional results from a linked server powered view. #sql #sqlserver #storedprocedure
Artfull Coder SQL Linked Server - SQL Server 2022
Просмотров 563 месяца назад
I this video I show you how to setup a linked server in SQL server 2022. And cover querying the linked server for data using 4 part naming convention and the OPENQUERY command. I discuss the cons and pros of both methods when querying data from a linked server.
SQL Every possible combination of two tables (Cross Apply)
Просмотров 185 месяцев назад
In this video I show you how to create a SQL view of every possible combination of years and week numbers. I use a modern approach, which used to be handled via a cross apply but instead we use a from statement from multiple tables and create a view based on this for easy querying in the future. #sqlserver #sql #sqltips
SQL Generate Sequence of numbers
Просмотров 2065 месяцев назад
In this video I show you how to generate a sequence of numbers purely in SQL that can then be used in a view. This uses a with and select statements. I have used this approach in a production solution and with its minimal code find it a great solution #sqlserver #sql #sqltips #ssms
SSRS - Setting Up The Server Side 2022
Просмотров 736 месяцев назад
I this video I guide you through the process of setting up SSRS server side on a windows 11 laptop. From downloading SSRS to installing the database and deploying reports created in Visual Studio 2022. #ssrs #reportserver #visualstudio2022
SSRS - Adding Parameters to Reports
Просмотров 1206 месяцев назад
In this video I cover how to add parameters to your SSRS reports. I cover how to create the underlying dataset with a drop down list of items that then filters the report data using Visual Studio 2022 and SSRS. #visualstudio2022 #ssrs
SSRS Introduction Visual Studio 2022
Просмотров 1,1 тыс.6 месяцев назад
In this video I cover creating SSRS reports in visual studio 2022. I take you through the different steps from seeding sample data into SQL server and creating your very first report. This is an introduction to SSRS, more videos to follow. I hope you enjoy this video #ssrs #sqlserver #ssms #2022
SSIS Warehouse - In Visual Studio 2022
Просмотров 2247 месяцев назад
In this video I show you how to create an SSIS warehouse in SQL Server 2022 and Visual Studio 2022. This video covers SQL security, installing and setting up SSIS in SQL server, adding the SSIS support to visual studio 2022, creating the package files, deploying them to SQL server, setting up a SQL server agent job to run the package.
SSIS Building Simple Data Warehouse In SQL Server
Просмотров 927 месяцев назад
In this video I show you how to create a data warehouse in SQL server 2019 using SSMS warehousing data using pure SQL.
Snake Hunt Game - JQuery, Javascript, CSS, Canvas, PHP
Просмотров 258 месяцев назад
A little video show casing a computer game I created in JQuery, Javascript, CSS, HTML Canvas and php. All built from scratch including the game engine. All available to play for free on my website. Hope you enjoy.
Clean Architecture - Blazor Full GRUD - Part 3
Просмотров 348 месяцев назад
In this video I show how to fix the issue of our confirmation dialog not working as expected in our clean architecture blazor minimal api solution written using .net c# in visual studio 2022
Clean Architecture - Blazor Full CRUD - Part 2
Просмотров 359 месяцев назад
Clean Architecture - Blazor Full CRUD - Part 2
Clean Architecture - Blazor Full CRUD - Part 1
Просмотров 1229 месяцев назад
Clean Architecture - Blazor Full CRUD - Part 1
Clean Architecture - Full CRUD Use Cases in Minimal API
Просмотров 1439 месяцев назад
Clean Architecture - Full CRUD Use Cases in Minimal API
Clean Architecture - Blazor - Bootstrap Modal
Просмотров 2469 месяцев назад
Clean Architecture - Blazor - Bootstrap Modal
Clean Architecture - Return types and more UseCases Added and Validation Handling in Front End
Просмотров 499 месяцев назад
Clean Architecture - Return types and more UseCases Added and Validation Handling in Front End
Clean Architecture UI Layer User Feedback
Просмотров 249 месяцев назад
Clean Architecture UI Layer User Feedback
Clean Architecture - UI Layer - Blazor - C# .net 7 Visual Studio 2022
Просмотров 19410 месяцев назад
Clean Architecture - UI Layer - Blazor - C# .net 7 Visual Studio 2022
Clean Architecture - Hooking Up To SQL Server Database For Persistent Storage
Просмотров 8110 месяцев назад
Clean Architecture - Hooking Up To SQL Server Database For Persistent Storage
Clean Architecture - WebApi Layer - Minimal APIs - c# .net 7 Visual Studio 2022
Просмотров 16610 месяцев назад
Clean Architecture - WebApi Layer - Minimal APIs - c# .net 7 Visual Studio 2022
Clean Architecture Application Layer - Exceptions And Middleware - c# .net 7, Visual Studio 2022
Просмотров 13210 месяцев назад
Clean Architecture Application Layer - Exceptions And Middleware - c# .net 7, Visual Studio 2022
Clean Architecture Infrastructure Layer - c# .net visual studio 2022
Просмотров 20310 месяцев назад
Clean Architecture Infrastructure Layer - c# .net visual studio 2022
Clean Architecture Application Layer
Просмотров 21710 месяцев назад
Clean Architecture Application Layer
Clean Architecture Domain Layer - c# .net 7 - visual studio
Просмотров 13110 месяцев назад
Clean Architecture Domain Layer - c# .net 7 - visual studio
Configure IIS Directory Security windows 11
Просмотров 7211 месяцев назад
Configure IIS Directory Security windows 11
This is brilliant. Thanks. Experienced a lot of frustration setting this up, until I found this video.
Hi @anevusser, glad this video has helped you thats why i do the videos. If there is any topic you would like me to do then just let me know. Kind regards
@@artfullcoder Thank you. I still have a few challenges ahead of me. I want to deploy a legacy php extension compiled in Delphi 7, so I will need a x86 version of PHP to be able to do that. I'll follow the same instructions and see where that gets me. Also need to host from a W11 Virtual Box.
@anevisser no probs, ive worked with custom php extensions. You add the extension into the bin / extensions directory and reference in your php.ini file. You will need to make sure your php extension is compatible with the version of php you are running you can find all windows php versions at windows.php.net
@@artfullcoder I managed to install php 8.3.10 x 86 successfully on W11. You will need to install a Visual C++ Redistributable (x86) though. VC++ 2015-2022 14.40.33810 is what I used.
Thats brilliant, glad you got sorted
For those that can't see "FastCGI" in the IIS menu, Windows+R -> "optionalfeatures" -> Internet Information Services -> World Wide Web Services -> Application Development Features -> Tick "CGI" -> "OK" -> Close & Re-open IIS
Thank you SOO much for your videos! You saved me. I'm very familiar with some software but this is not one of them. I went through your video series and was finally able to things moving along. Something else I found that you may want to feature is how to get PHP manager added to IIS since Microsoft discontinued it and doesn't have it to download any longer. I was able to find a GitHub repository by "RonaldCarter" for PHPManager V1.5. Maybe an idea for your next video?!?
I am sorry but this is missing the most important part - setting up the environment to work with php
Hi @skarsburning, this is covered in my other videos on my channel, for configuring php with IIS watch the php 8.2 video with IIS, for IIS check out my installing IIS windows 11 laptop. Php 8.3 is a minor version and what is covered in the 8.2 will work the same
Thank you so much for such an easy description.
Thankyou robeeeeen glad you found the video helpful and useful
@@artfullcoder Thanks, I could not find the FastCGI anymore in Windows 11. Is it discontinued?
Hi, yeah, you need to make sure that CGI is turned on via "turn windows features on or off" and the windows fastcgi appears at server level in IIS not site level. From there you can configure PHP. Its under "Internet Information Services" > "World Wide Web Services" > "Application Development Features" make sure "CGI", "ISAPI Extensions" and "ISAPI Filters" are ticked
I don't normally comment on any videos on RUclips, but your instructions on this topic really helped me a lot. I'm trying to learn php and other things and I didn't want to resort to xampp. Thank you very much.
Hi, thank you so much for your comment, hope this video helps you in your quest as a software engineer. Ive used this type of pairing, that iis and php in production envirnoment. There are lots of pluses for using this type of setup. Depending on what you are trying to build you may need to tweak some of the timeout settings in both iis and php to your desired level. But thank you again for such kind words, i do have another older videos that are not on here that show crud php jquery application from beginning to end so may put this on my channel or create dedicated php playlist.
please share your source code
Thank you for your comment i will look at making it so i share the source code. And will let you know when ive done this
Hello, do you have a tutorial on how to configure IIS to follow this same tutorial, thank you!
Yes, i have a video that shows you how to install iis on windows 11, if you goto my channel its on there
I think before doing this make sure you have your IIS set up already on your windows machine im looking forward if its possible to use this without buying any domain or hosting and people can see my web site hehehe
Hi @bernpaul9868, thanks for your comment. You do indeed need IIS preconfigured. In response to about hosting this so people can access it without hosting or domain name there is a service called noip.com or along those lines and you simply install the client where you have IIS installed and you get a free website address. I have hosted my own servers, with this option you need a domain name, a static ip address from your ISP and you point the website address to your static IP and configure port forwarding on your modem / router. This is something i have done before and worked well for me. There are pros and cons of these different options but hope this helps you in your goal.
Hi, i did these steps but i've come across the issue http error 500.19. It's says it's because of a duplicate collection entry of type "PHP" with key attribute name set to PHP. I've been into the application.config file and removed it, then when that didn't work restored it and removed it from the web.config file instead, and that still doesn't work, just coming up with the error where it tries to run the PHP as a static file.
Hiya, have you tried creating a blank php file in your project and see if you still get the same error
I did the eaxt steps, but i still can not run my host my php project. all html projects work fine
Thanks for reaching out, have you followed the steps in this video, you will also need to make sure cgi and isapi support is also enabled, there could also be a permissions issue if you are running on c drive depending how you have your laptop setup, have you also added index.php as a default document within iis?
@@artfullcoder Yes i have installed the cgi and isapi , i dont know about the file permission, i am getting this error, "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed."
@@ehtishamnaveed1639 hi, thanks for your reply, usually thats caused by an error in your code, try creating a blank index.php file with no php code in and see if you get the same problem. Also check windows event viewer to see what errors you are getting as by default any errors are sent to windows event viewer, also check that you have php.ini file and settings are correct e.g are you trying to use a feature of php that isnt enabled like curl for example. Also check your php version to make sure its compatible with iis