• SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)
    Articles,  Blog

    SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)

    Welcome to beginners tutorial Microsoft sql server part 5. today We are going to learn about the store procedure how to create it and how to execute stored procedure a Stored procedure is a set of structured query language statements with an assigned name Which are stored in a relational database management system as a group, so it can be reused and shared by multiple Programs. there are so many advantages of using a stored procedure if managed control and a validate data Larger queries can be avoided. it reduces network traffic since they need not be recompiled hence stored procedure increases reusability of code Permissions can be granted for…

  • How to open an .MDF file? (Attach a Database in SQL Server)
    Articles,  Blog

    How to open an .MDF file? (Attach a Database in SQL Server)

    Hi. Let’s say somebody wants to share their SQL Server database with you. If they give you an .MDF and .LDF file, how do you actually look at the contents of that database? You might be tempted to try to open these files with a specific SQL Server program, like SQL Server Management Studio. But the correct approach is to “attach” these files to a specific instance of SQL Server. Let me show you how this works. First, you need a running instance of SQL Server on your machine. SQL Server 2008 R2 Express is a free edition of SQL Server. Once installed, you can open up SQL Server Management…

  • Setting Up My Server
    Articles,  Blog

    Setting Up My Server

    HeHeHey it’s Cvolton here and in this video we’re going to have a look at this server This is an HP Proliant G5 DL360 Which might be an old server, but it’s good enough for me My specific variant has an Intel Xeon 5150 CPU 6GB of RAM 2x 72GB HDD And I also have another 2 hard drives stored away from the server in case the current two hard drives fail Alright, enough talking about the specs let’s talk about how I set it up Just a friendly reminder If you’re setting up a server of your own you might probably want to look for a better video But…

  • How to setup a Terraria Server (EASY) (NO HAMACHI) (*No steam either despite what I say*)
    Articles,  Blog

    How to setup a Terraria Server (EASY) (NO HAMACHI) (*No steam either despite what I say*)

    Hello guys, if you’re watching this you’re probably wondering how do I make a terraria server. Well, quite simply I’m gonna show you how to do it if you’re using STEAM. If you’re not using steam, unfortunately I don’t have the video for you and you’ll have to use another video. If you guys want me to make a video on that. Sure, I’ll do it! Just ask, put it in the comments. Alright, so first off, go ahead and click on your computer. You can find that in here too, with computer and then open your C:/ drive, Program Files x86 and then go right ahead and scroll down…

  • How to Install WordPress on Localhost Wamp Server
    Articles,  Blog

    How to Install WordPress on Localhost Wamp Server

    Hello tutorial shows you, how to install WordPress on localhost using Wamp server Here is a steps First, Assign a Static Local IP Address for your Server Second, Wamp Installation Third, Test Wamp Server with Your First PHP Script 4. Fourth, Secure Wamp Server (Set MySQL Root Password) Fifth, WordPress Installation First of all, we need to download required tools, Wamp server, WordPress CMS and notepad ++ You need to find which version is compatible for your computer OK, my operating system is 32 bit, so, lets download that version OK, we got all required tools Step First, Assign a Static Local IP Address for your Server Open CMD (command…

  • FileZilla Server Tutorial – Setup FTP Server
    Articles,  Blog

    FileZilla Server Tutorial – Setup FTP Server

    Hello and welcome to Red Stapler again! This video we’ll talk about how to set up a simple FTP server with Filezilla First you need to download the FileZilla Server you’ll get a installer like this Just move forward with the standard setting I’m going to install the FileZilla as a service so the server will up when I start the PC and start if any user log on to this computer. Now the first step is to connect to your FTP server you’ll see a warning that I’m behind a router This will be OK if I plan to use the FTP server internally but if you want your…

  • Migration Roles In Windows Server 2012 R2
    Articles,  Blog

    Migration Roles In Windows Server 2012 R2

    Welcome to the ITFreeTraining video on migration roles between servers. The Migration tools in Windows Server 2012 and R2 have been improved to make the process easier than before. This video will look at what you can achieve using migration tools, and perform a demonstration of how to move the DHCP server role from one server to another. Migration gives you a bit more control than performing an upgrade; however, it requires more effort and planning from the administrator. Migration can be used to migrate roles, features, shares and OS settings. Unlike an upgrade, the administrator can choose what to migrate and what to leave behind. Let’s consider the following…

  • How to use Universal Media Server
    Articles,  Blog

    How to use Universal Media Server

    How to Use Universal Media Server Hello everybody. I’m going to demonstrate how to use Universal Media Server. Universal Media Server allows users to stream all media content to any DLNA capable device. And since it is written in Java, it supports all major platforms, such as Windows, Mac, and Linux. Now I’ll show you how to stream media using Universal Media Server. First, make a server, then share the media files from the Navigation/Share Settings tab. Now open a browser and enter the IP address of the server, and press Enter. This will open the web interface of the Universal Media Server, where we can access the media files…