http://www.sqlmag.com/authors/author/author/5777400/rss/5777400en-USFri, 25 May 2012 08:35:15 GMTFri, 25 May 2012 08:35:15 GMThttp://www.sqlmag.com/article/development/top-4-things-developers-can-do-to-prepare-for-sharepoint-2010Devs need to prepare for SharePoint 2010--here are 4 suggestions for how to get ready.]]>ReadersSun, 25 Oct 2009 00:00:00 GMThttp://www.sqlmag.com/article/development/top-4-things-developers-can-do-to-prepare-for-sharepoint-2010http://www.sqlmag.com/article/tips/get-your-it-resume-to-the-top-of-the-pileIn 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.]]>ReadersWed, 08 Apr 2009 00:00:00 GMThttp://www.sqlmag.com/article/tips/get-your-it-resume-to-the-top-of-the-pilehttp://www.sqlmag.com/article/news2/readers-speak-out-on-cloud-computing
By Jeff James
In the January 2009 installment of IT Pro Perspectives, we asked readers to let me know what they thought of cloud computing. We received a number of emails, phone calls, and letters from readers about the topic.]]>Jeff JamesFri, 23 Jan 2009 00:00:00 GMThttp://www.sqlmag.com/article/news2/readers-speak-out-on-cloud-computinghttp://www.sqlmag.com/article/tsql3/quickly-identify-columns-with-mismatched-data-typesHere’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.]]>ReadersThu, 22 Jan 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/quickly-identify-columns-with-mismatched-data-typeshttp://www.sqlmag.com/article/remote-computing/use-plink-to-reboot-vmware-vmsWith 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.]]>ReadersThu, 22 Jan 2009 00:00:00 GMThttp://www.sqlmag.com/article/remote-computing/use-plink-to-reboot-vmware-vmshttp://www.sqlmag.com/article/tsql3/find-out-what-s-going-on-inside-your-partitionsSQL 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.]]>ReadersThu, 22 Jan 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/find-out-what-s-going-on-inside-your-partitionshttp://www.sqlmag.com/article/permissions/quick-local-admin-testHere’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.]]>ReadersMon, 22 Dec 2008 00:00:00 GMThttp://www.sqlmag.com/article/permissions/quick-local-admin-testhttp://www.sqlmag.com/article/unix/do-more-with-forDo More with For]]>ReadersWed, 12 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/unix/do-more-with-forhttp://www.sqlmag.com/article/windows-shell-bat-and-cmd/do-more-with-for100294Windows 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.]]>ReadersWed, 29 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-shell-bat-and-cmd/do-more-with-for100294http://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-wordHere’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.]]>ReadersThu, 23 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-wordhttp://www.sqlmag.com/article/installation2/how-to-stop-users-from-installing-google-chromeUnlike 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.]]>ReadersMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/installation2/how-to-stop-users-from-installing-google-chromehttp://www.sqlmag.com/article/tsql3/update-rows-in-large-tables-without-locking-out-usersYou 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.]]>ReadersMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/update-rows-in-large-tables-without-locking-out-usershttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescueIf 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.]]>ReadersFri, 26 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescuehttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xpWindows 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.]]>ReadersFri, 26 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xphttp://www.sqlmag.com/article/permissions/use-powershell-to-manage-fine-grained-password-policies-in-windows-server-2008Using 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.]]>ReadersThu, 18 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/permissions/use-powershell-to-manage-fine-grained-password-policies-in-windows-server-2008http://www.sqlmag.com/article/tsql3/get-rid-of-gaps-in-numerical-sequencesAlthough 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.]]>ReadersThu, 28 Aug 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/get-rid-of-gaps-in-numerical-sequenceshttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dcHere 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.]]>ReadersWed, 27 Aug 2008 00:00:00 GMThttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dchttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-proceduresHaving 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.]]>ReadersWed, 30 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedureshttp://www.sqlmag.com/article/tsql3/find-any-string-in-any-sql-code-in-any-databaseThis 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.]]>ReadersWed, 30 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/find-any-string-in-any-sql-code-in-any-databasehttp://www.sqlmag.com/article/tsql3/nifty-ways-to-use-for-xml-path-concatenationNo temporary tables or table variables are needed to perform FOR XML PATH concatenation, so the resulting query is not only fast but also high performing.]]>ReadersFri, 27 Jun 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/nifty-ways-to-use-for-xml-path-concatenation