Server

ALL POSTS FROM CATEGORY


How to Open SQL Server?
December 8, 2018

How to Open SQL Server?

This topic describes how to start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using SQL Server Configuration Manager, SQL Server Management Studio, net commands from a command prompt, Transact-SQL, or PowerShell. Before you begin: Instructions using: What is the SQL Server Database…

Server Roles
November 18, 2018

Server Roles

This documentation is archived and is not being maintained. Applies To: Windows Server 2008 R2 Server Manager in Windows Server® 2008 R2 replaces older management consoles such as Configure Your Server and Manage Your Server. With Server Manager, you prepare the server for deployment by installing logical software packages known as roles, role services, and features…

DIY Streaming Server
September 4, 2018

DIY Streaming Server

For more than 10 years Videoguys.com, one of the world’s leading resellers of video editing and production solutions, has been publishing DIY articles as a service to their customers. These guides have been recommended by video editing, post production, gaming and general computer blogs, web sites, and user forums all over the world—including Streaming Media…

Access Ubuntu Server Remote
May 7, 2018

Access Ubuntu Server Remote

First, make a backup of your sshd_config file by copying it to your home directory, or by making a read-only copy in /etc/ssh by doing: sudo cp /etc/ssh/sshd_config /etc/ssh/sshd_config.factory-defaults sudo chmod a-w /etc/ssh/sshd_config.factory-defaults Creating a read-only backup in /etc/ssh means you ll always be able to find a known-good configuration when…

SQL Server name
April 27, 2018

SQL Server name

SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse Returns the name of the local server that is running SQL Server. Transact-SQL Syntax Conventions Syntax @@SERVERNAME Return Types nvarchar Remarks SQL Server Setup sets the server name to the computer name during installation. To change the name of the server, use…

Home WiFi Server
March 28, 2018

Home WiFi Server

I’m sure you’ve heard of the Internet… right? Duh. Well, simply put, it’s a big huge network that’s changing humanity. Does that Jog your memory? Now the real question is this: do you know the difference between the Internet and your WiFi network? If you don’t, stay calm and I’ll explain. I’ll do my best to put this into laymen s terms. There will be a few concepts…

How to Access a Remote Server?
March 18, 2018

How to Access a Remote Server?

When you run ipython notebook on a remote server using the following command jupyter notebook –no-browser –port=9 You will see: The Jupyter Notebook is running at: In this case, you cann’t use the link: public_IP_address:9 or domain_name:9 to get access to the Ipython Notebook Server. You can do some config to allow the Ipython notebook server to run on the public…

How to Get SQL Server name?
December 23, 2017

How to Get SQL Server name?

In AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs, I outlined how there are, effectively, two ways to tackle the need to run batch jobs (or SQL Server Agent jobs that target a database that’s part of an AlwaysOn Availability Group). Either your SQL Server Agent jobs can target (or detect) whether…

Settings Up a Remote Server
October 14, 2017

Settings Up a Remote Server

I wish everyone a very happy and prosperous new year. Here comes the first blog post for the year 2015, on ColdFusion Buider 3. A user came across our Mobile Application Development Contest blog and was trying to develop his application using ColdFusion Builder 3, but he wasn’t able to setup a connection between ColdFusion 11 and ColdFusion Builder 3. He was…

Remote Access to the Server
June 12, 2016

Remote Access to the Server

The UCLA Library s online subscriptions are all set up to provide automatic access to any computer or device with a UCLA IP address, the unique address associated with every computer on the internet. IP addresses are assigned automatically by your internet service provider when you connect to them. Your computer can obtain a UCLA IP address in a few ways. On-campus:…

Server name for SQL Server 2005
August 2, 2016

Server name for SQL Server 2005

When you change the name of the computer that is running SQL Server, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name. Instead, use the following steps to update system metadata that is stored in sys.servers and reported by the system function @@SERVERNAME. Update system metadata to reflect computer…

SQL Server Configuration Manager Remote
April 14, 2017

SQL Server Configuration Manager Remote

In the Open box, type mmc -a to open the Microsoft Management Console in author mode. On the File menu, click Add/Remove Snap-in. In the Add/Remove Snap-in window, click Add. In the Add Standalone Snap-in window, click Computer Management and then click Add. In the Computer Management window, click Another computer, type the name of the remote computer you wish…

How to Access Server?
August 5, 2016

How to Access Server?

: Intranet websites, private sites for users within a home or office, can be useful for lots of things. And if your home or office PCs can all access the Internet, chances are good that you have an Internet connection sharing router or gateway device, like the SMC Barricade, or the Linksys BEFSR81 (just two examples out of many). But what does an Internet…

Server name in SQL Server
April 23, 2017

Server name in SQL Server

I m not sure what you were exactly asking. As you are writing this procedure for an Auditing need I guess you re asking how do you get the current database name when the Stored Procedure exists in another database. e.g. USE DATABASE1 GO CREATE PROC spGetContext AS SELECT DB_NAME GO USE DATABASE2 GO EXEC DATABASE1..spGetContext /* RETURNS DATABASE1 not DATABASE2…

Media Server router
January 17, 2017

Media Server router

Netgear’s new Nighthawk X10 AD7200 router is supposed to be the world’s fastest,at least according to Netgear. The company also claims that its new router is the first designed for media streaming and instant backup,which is not very true and makes me wonder if I can trust Netgear about any of its claims. Let’s get into it. The X10 comes with a 1.7GHz Quad…

SQL Server NOT
December 18, 2015

SQL Server NOT

This SQL Server tutorial explains how to use the NOT condition in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) NOT condition, also called the NOT Operator, is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement. Syntax The syntax for the NOT condition in SQL Server (Transact-SQL) is: NOT…

SQL Server 2012 Browser
April 24, 2014

SQL Server 2012 Browser

This documentation is archived and is not being maintained. In this topic, you will learn how to start and stop the SQL Server Browser service. By default, Microsoft SQL Server 2005 Express Edition (SQL Server Express) does not set the SQL Server Browser service to start automatically. On the Start menu, right-click My Computer, and then click Manage. In Computer…

Internet Media Server
April 15, 2014

Internet Media Server

Sure, you could just connect a PC to your TV, but these provide convenient interfaces across all your devices. That means apps for TV streaming boxes, smartphones, tablets, and web-based interfaces for everything else. They even work over the Internet. Bring Your Own Media There are some good free software packages for this, but you’ll need to bring your own…

Remote Server Software
December 3, 2015

Remote Server Software

As an engineer, my favorite answer in the world is, it depends. I can certainly recommend some great Simple Network Management Protocol (SNMP) performance monitoring tool sets based on the email you sent. If you just want to monitor management information base (MIB) that provide statistics based on hardware, software services, and interface data, then go with…

SQL Server Firewall Configuration
August 23, 2015

SQL Server Firewall Configuration

ESHA software uses SQL Server to host the ESHA Database. When the database resides on a separate machine (often a Server computer), there is need to allow SQL Server as an exception if Windows Firewall is enabled. To allow this exception, get into Windows Firewall (found in the Control Panel). Depending on your operating system, your Firewall display may vary…

Plex Remote Server
March 18, 2017

Plex Remote Server

Welcome to our forums! Please take a few moments to read through our Community Guidelines (also conveniently linked in the header at the top of each page). There, you ll find guidelines on conduct, tips on getting the help you may be searching for, and more! When I first started PLEX I had no issues with Remote Servers. Here is the lineup I had when I first started…

Enable Remote Access to MySQL database Server
December 29, 2014

Enable Remote Access to MySQL database Server

Enable Remote Access (Grant) Home / Tutorials / Mysql / Enable Remote Access (Grant) If you try to connect to your mysql server from remote machine, and run into error like below, this article is for you. ERROR 1130 (HY): Host ‘1.2.3.4’ is not allowed to connect to this MySQL server Change mysql config Start with editing mysql config file vim /etc/mysql/my.cnf…

Plex Server Settings
November 6, 2015

Plex Server Settings

Tested with Ubuntu 16.04 LTS server. Rclone version rclone v1.35-129+ This is the summery of original topic I made on rclone forum: . Thanks to all contributors for their participation and testing. rclone mount \ -read-only \ -allow-other \ -acd-templink-threshold 0 \ -stats 1s \ -buffer-size 1G \ -timeout 5s \ -contimeout 5s \ -v \ -log-file=/path to/logfile.log…

Plex Online Server
March 22, 2014

Plex Online Server

After a couple of stops and starts — and some concerns — media player software maker Plex is opening its online service known as Plex Cloud to all paying Plex users. The service, which was first introduced into private beta in September, eliminates the need for an always-on PC or other network-attached piece of hardware in order to use the Plex media player software…

1
2