October, 2009
Top 4 Things Developers Can Do to Prepare for SharePoint 2010
Devs need to prepare for SharePoint 2010--here are 4 suggestions for how to get ready.
Windows IT Pro
|
April, 2009
Script Trek
The Star Trek crew discovers how bad assumptions about data types can cause errors in VBScript and PowerShell code.
Windows IT Pro
|
April, 2009
Get Your IT Resume to the Top of the Pile
In these tough economic times, getting an IT resume noticed can be challenging because of the number of resumes HR receives for an IT position. To overcome this challenge, one IT professional took a different approach and got noticed.
Windows IT Pro
|
January, 2009
Use Plink to Reboot VMware VMs
With Plink, you can programmatically turn off and turn back on VMware virtual machines (VMs) from a remote Windows host. This utility is not only useful but also free.
Windows IT Pro
|
January, 2009
Quickly Identify Columns with Mismatched Data Types
Here's a utility that you can use to quickly find which columns have mismatched data types across tables in a SQL Server 2008 or SQL Server 2005 database. Correcting these columns can improve performance and data integrity.
SQL Server Magazine
|
January, 2009
Find Out What's Going On Inside Your Partitions
SQL Server Management Studio (SSMS) lacks an easy-to-use tool to get detailed data about partitioned tables. To fill this gap, a reader has created two tools. One provides the data in a results grid, whereas the other provides the data in a report.
SQL Server Magazine
|
December, 2008
Quick Local Admin Test
Here's a quick and easy way you can determine whether the current user is a local administrator without having to check Domain Group membership. All you need to do is download and run LocalAdminTest.vbs—no modifications are needed.
Windows IT Pro
|
November, 2008
Do More with For
Windows IT Pro
|
October, 2008
Do More with For
Windows Services for UNIX (SFU) includes UNIX and Linux binaries that you can run from a Windows command line or in a batch file. When you combine the SFU commands with the Windows For command, you can create powerful tools.
Windows IT Pro
|
October, 2008
Avoid Ugly Computer Inventory Reports—Save Your Script's Output in Microsoft Word
Here's a VBScript script that retrieves a computer's memory and process information, then writes it to a nicely formatted Microsoft Word report. The report is customizable—you can even include an image, such as a company logo, on the report’s title page.
Windows IT Pro
|
September, 2008
How to Stop Users From Installing Google Chrome
Unlike most applications, Google Chrome is designed to install in areas that standard users can write to, so they can install this new browser without Admin rights. Here are the steps you can take to block Google Chrome's installation.
Windows IT Pro
|
September, 2008
Update Rows in Large Tables Without Locking Out Users
You can use the TOP clause to limit the transaction size, but there's a trick to using it: You need to keep track of which rows have already been updated so that you don’t update them a second time. Here's how to keep track of the rows.
SQL Server Magazine
|
September, 2008
Mimic Vista's Event Triggers in XP
Windows Vista lets you create event-triggered actions through Event Viewer. You can achieve the same functionality in Window XP using a VBScript script and the eventtrigger.exe command-line utility.
Windows IT Pro
|
September, 2008
PsExec to the Rescue
If you need to log off a user on a remote server that's running Terminal Services Manager, you can't use Terminal Services Manager to access that server. Fortunately, you can use PsExec.
Windows IT Pro
|
September, 2008
Use PowerShell to Manage Fine-Grained Password Policies in Windows Server 2008
Using ADSI Edit to administer Password Settings objects (PSOs) is cumbersome and time-consuming. To reduce the amount of time it takes, you can use PowerShell and some free AD cmdlets.
Windows IT Pro
|
August, 2008
Get Rid of Gaps in Numerical Sequences
Although companies might want integer sequences in database applications to be gapless, gaps occur frequently. Here's a solution that you can use to eliminate existing and avoid new gaps.
SQL Server Magazine
|
August, 2008
Virtual PC 2007 Mouse Integration Fix for Win98
The Mouse Integration feature sometimes doesn't work in Windows 98 virtual machines because of a bug in Virtual PC 2007's Virtual Machine Additions installation routine. To fix the bug, you can make some changes to the virtual machine's system.ini file.
Windows IT Pro
|
August, 2008
How to Access Directory Services Restore Mode on a Remote DC
Here are the steps you can follow to get into Directory Services Restore Mode remotely through RDP, then run the Ntdsutil tool to check an Active Directory (AD) database.
Windows IT Pro
|
July, 2008
Find and Replace Keywords in Stored Procedures
Having to modify stored procedures when an object name changes can be tedious. Here's a T-SQL stored procedure that eliminates the tedium from this task.
SQL Server Magazine
|
July, 2008
Find Any String in Any SQL Code in Any Database
This T-SQL stored procedure searches all the databases on your server for the string you specify and returns a list of the objects that contain it.
SQL Server Magazine
|