Networking. Win32 on Win64. Shell. ROBOCOPY. Powershell. Testing connectivity to Microsoft SQL Server without any tools installed. Often you'll find yourself logged into a web or application server and need to simply test that you can get to the SQL server you've unsuccessfully been trying to point your app at.
Luckily there is a nifty trick built into Windows that allows you to save the day without having to install anything on your box – and it works on both client and server operating systems just as well. Why would i ever need this? Your app is having trouble connecting to SQL and you don't know what's wrong.
Is something wrong with your app? Is it a network or firewall issue? Is SQL even there…? The "so easy it almost can't be true" solution The guys at Microsoft have baked a SQL Connectivity tool right into Windows with the creation of Microsoft Universal Data Link files (*.UDL) – something designed for another purpose. These were designed as a way to save SQL connection data for use in a whole range of applications and are available on pretty much every version of Windows since *eternity*.
Use PerfMon to Diagnose Common Server Performance Problems. Windows Administration Taking Your Server's Pulse Steven Choy At a Glance: Customizing Performance Monitor Guidance on what and how often to measure An overview of key counters and what to look for Imagine you just arrived at the office on a Monday morning and you’re greeted by an eager user who is complaining that his server is running too slow.
Monitor, a handy tool built into Windows®, can assist you in diagnosing the problem. Use PerfMon to Diagnose Common Server Performance Problems. WinRM (Windows Remote Management) Troubleshooting - Jonathan's Manage and Automate. What is WinRM?
New in Windows Vista, Windows Server 2003 R2, Windows Server 2008 (and Server 2008 Core) are WinRM & WinRS. Windows Remote Management (known as WinRM) is a handy new remote management service. WinRM is the “server” component of this remote management application and WinRS (Windows Remote Shell) is the “client” for WinRM, which runs on the remote computer attempting to remotely manage the WinRM server. However, I should note that BOTH computers must have WinRM installed and enabled on them for WinRS to work and retrieve information from the remote system. While WinRM listens on port 80 by default, it doesn't mean traffic is unencrypted.
WinRM with SCVMM uses Kerberos for authentication, and does not support fall-back to NTLM. What is WinRS? Remote Shell, (WinRS) is used to execute a program on a remote host. Winrs -r:machinename dir Another handy use of WinRS can be when installing software on remote systems. Winrs -r:machinename msiexec.exe /i c:\install.msi /quiet · UPDATE!
Stupid Geek Tricks: Hide Data in a Secret Text File Compartment. In today’s edition of Stupid Geek Tricks (where we show off little-known tricks to impress your non-geek friends), we’ll learn how to hide data in a text file that can’t be seen by anybody else unless they know the name of the secret compartment.
Note: This article was originally written a couple of years ago, but we’ve updated and polished it for Windows 7, and we’re sharing it with all the new readers again. Here’s How it Works Ever since Windows 2000, the NTFS file system in Windows has supported Alternate Data Streams, which allow you to store data “behind” a filename with the use of a stream name. It’s not detectable while browsing the file system, or anywhere within Windows… you can only access it with the “secret key” which is really just the name of the stream. Apprendre à affiner vos critères de recherche pour de meilleures recherches dans Outlook.
Le tableau suivant vous montre des exemples de recherches pouvant être utiles.
La syntaxe de requête de recherche, disponible lorsque la fonctionnalité Recherche instantanée est activée, suit cette forme simple : mot-clé:votre critère de recherche. Par exemple, de:raymond Vous pouvez également utiliser les opérateurs logiques ET, PAS, OU, <, >, =, etc. pour affiner votre recherche. Ils sont indiqués dans le tableau. Les opérateurs logiques doivent être tapés en majuscules. La syntaxe de requête de recherche est créée automatiquement et affichée dans la zone Recherche instantanée lorsque vous utilisez le Générateur de requêtes décrit dans la section précédente.
Learn All the Windows 10 Keyboard Shortcuts with This Cheat Sheet. Privileges.