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 (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…
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…
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…
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…
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…
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:…
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…
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…
: 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…
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…
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…
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…
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…
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…
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…
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…
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 (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…
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…
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…
Applies to: Exchange Server 2016 Overview of the Client Access services on Mailbox servers in Exchange 2016 In Exchange Server 2016, the Client Access services on Mailbox servers provide authentication and proxy services for internal and external client connections. The Client Access services are stateless, so data isn t queued or stored in them. In Exchange…
Online peer support For online peer support, join The Official Scripting Guys Forum! To provide feedback or report bugs in sample scripts, please start a new discussion on the Discussions tab for this script. Disclaimer The sample scripts are not supported under any Microsoft standard support program or service. The sample scripts are provided AS IS without warranty…
Most small businesses with 10 or more employees will face the task of buying a computer server, or adding to their existing inventory. Servers are most commonly used as central file repositories where users can easily share documents, but they can do many other tasks as well-from print and mail serving to performing system-wide backups. Other key applications…
