Scripting
|
100 results found, displaying items 1 - 20
|
Passing NULL Parameters
Have you ever had a stored procedure that could accept a NULL value as a parameter but didn't seem to work correctly when you did so? Here's what might have gone wrong.
SQL Server Magazine
—
William Vaughn
Retrieve Information from Open Browsing Sessions
If you need to retrieve information from an open Internet Explorer (IE) browsing session, try Get-IEUrl.ps1. With this PowerShell script, you can get and save web pages' URLs, titles, text, and even IE objects.
Windows IT Pro
—
Alex K. Angelopoulos
Get Updates on Microsoft Updates
Here's a VBScript script that details how many Microsoft updates are installed and the date of the most recently installed update on Windows XP machines.
Windows IT Pro
—
Brandon Jones
Monitor Network Connections with Pingmon
Rather than spending money on a commercial program or digging through huge ping logs, you can use the Pingmon script to monitor your network connections.
Windows IT Pro
—
Bill Aycock
SQL Server PowerShell Extensions
Automate even the most difficult SQL Server administrative tasks using this free PowerShell script set.
SQL Server Magazine
—
Kevin Kline
Pivoting the Dynamic Way
The PIVOT statement is a great tool for presenting data in an easy-to-read format, but it has one key limitation: You must know about and include all the column names in the PIVOT query. You can work around this limitation with dynamic pivoting.
SQL Server Magazine
—
Mitchel Sellers
Protect Your PowerShell Scripts
Here are three precautions that will go a long way in protecting your PowerShell scripts and securing your system.
Windows IT Pro
—
Robert Sheldon
Simple String Encryption and Decryption
In SQL Server 2008 and SQL Server 2005, one of the easiest ways to encrypt and decrypt strings is to use T-SQL's ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE functions.
SQL Server Magazine
—
Eli Leiba
T-SQL Statement Tracks Transaction-Less Dates
A DBA was asked to produce a list of dates in which there were no transactions from a database that included only the dates in which there were transactions. Here's how he pulled it off.
SQL Server Magazine
—
Saravanan Radhakrishnan
New to Scripting? Check Out These Series
If you want to learn about PowerShell, Windows shell scripting (.bat and .cmd), or T-SQL, here are some novice-level articles that can help.
Windows IT Pro
—
Karen Bemowski
Q. How can I get a list of all aliases available in PowerShell?
FAQ for Windows
—
John Savill
|
[September 16, 2009]
|
 |
What Applications Are Installed on the Computers in Your Network?
If you often need to identify the software that's installed on the computers in your network, here's a PowerShell script you can use to easily audit one or more computers.
Windows IT Pro
—
Bill Stewart
Tool Time: 175 Free Tools for the Taking
Find out about 175 freebies you can take advantage of when working with Windows OSs, virtual machines, Exchange servers, SharePoint sites, and even SQL Server setups.
Windows IT Pro
—
Karen Bemowski
Find Document Handlers for Specific Users
Trying to find out what application really opens a document for a user on local or remote machine? This code can help.
Windows IT Pro
—
Alex K. Angelopoulos
Use DevCon To Install Device Drivers Remotely
If you have to install a device driver on a lot of computers, give DevCon a try.
Windows IT Pro
—
M. Hakan Can
Stored Procedure Retrieves Information About Partitioned Tables
SQL Server Management Studio (SSMS) doesn't have a GUI that lets you easily obtain information about partitioned tables. Here's a stored procedure that helps fill this gap.
SQL Server Magazine
—
Shaunt Khaldtiance
VMworld 2009: VMware looks to virtualize mobile phones
Virtualization goes mobile
Windows IT Pro
—
Michael Otey
VMworld 2009: VMware readies PCoIP
VMware launches a new remote display protocol
Windows IT Pro
—
Michael Otey
VMworld 2009: Is Spring Source a good fit for VMware?
Is a Java development product a good fit for the leading virtualization provider?
Windows IT Pro
—
Michael Otey
Remote Administration Software Puts a GUI Face on WMI's Functionality
With WMIX 2.0, you don't need to write a script or install software agents to query and manage remote Windows machines.
Windows IT Pro
—
Karen Bemowski
|
|
Register
