- Follow this blog:
- RSS
- Email Alert
The Enterprise Cloud
Selena Frye
TechRepublic Staff
Selena Frye

-
Backup compression in SQL Server 2008
New to SQL Server 2008 is the native ability to compress database backups. This great new feature results in a smaller backup file, which saves disk space and can lessen the time latency. Here's...
Posted by Tim Chapman | August 25, 2008, 3:35 PM PDT
-
What would you do with 10,000 new servers every month?
Microsoft is investing a lot in new data centers. According to a report on News.com, they're buying upwards of 10,000 new servers every month. What does one do with that many boxes?
Posted by John Sheesley | August 21, 2008, 10:58 AM PDT | Latest comment by mwalker@...
-
How do I. . . move the Tempdb and Master Database in SQL Server?
As a DBA, you may run into an issue with disk space and it may be necessary to move the tempdb and master database. This tutorial provides you with the tasks necessary to perform this arduous...
Posted by Steven Warren | August 20, 2008, 12:36 PM PDT
-
Perform remote administration with RSAT on Windows Vista SP1
Remote administration of Windows Server environments is a critical part of rights delegation and agile support. The Remote Server Administration Tools are now available for Windows Server 2008 on...
Posted by Rick Vanover | August 19, 2008, 6:00 AM PDT | Latest comment by Beoweolf
-
How do I configure a Distributed File System (DFS)?
Windows Distributed File System allows users to find, view, and work with files on your network from one central location. In this tutorial, we will simplify how to work through this difficult...
Posted by Steven Warren | August 18, 2008, 7:40 PM PDT | Latest comment by zalmay_77@...
-
Script Table definitions using TSQL
Generating scripts in SQL Server using TSQL has never been easy. In today's SQL Server tip, I will show you how you can use TSQL in SQL Server 2005 code to script a table's definition.
Posted by Tim Chapman | August 18, 2008, 12:35 PM PDT | Latest comment by dvokic
-
View All Running Tasks with Windows Server 2008's Task Scheduler
The Windows Server 2008 Task Scheduler has many default tasks that you may or may not wish to run in your environment. Learn about a new feature that can help you determine if a process is not...
Posted by Rick Vanover | August 12, 2008, 6:00 AM PDT | Latest comment by DDelaney
-
Using Mirrored Media Sets in SQL Server 2005
Mirrored Media Sets is a new feature in the Enterprise Edition of SQL Server 2005. It enables the creation of redundant copies of a backup file to reduce the possibility of a backup device...
Posted by Tim Chapman | August 11, 2008, 12:37 PM PDT
-
What is in your toolbelt?
As a DBA, you probably have several tools to help you in a bad spot. Have you heard of SQL Professional Toolbelt? It can be a handy addition to keep your SQL Server humming.
Posted by Steven Warren | August 8, 2008, 8:55 PM PDT | Latest comment by fuller.artful@...
-
How do I... Install VMware Workstation as a Service?
Under default conditions, VMware Workstation does not support the ability to run virtual machines as a service. Stephen Warren shows you can change the default behavior using the Windows 2003...
Posted by Steven Warren | August 7, 2008, 1:25 PM PDT | Latest comment by The 'G-Man.'
-
How do I assign permissions to users to see SQL Agent Jobs?
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.
Posted by Tim Chapman | August 6, 2008, 10:06 AM PDT
-
How do I change the name of my SQL Server?
Did you know that when you change the name of a server that you also have to change the name in SQL Server? It's not that difficult, but if you don't you'll cause problems. Steven S. Warren shows...
Posted by Steven Warren | August 5, 2008, 8:53 PM PDT | Latest comment by mbaraz@...
-
Expand and shrink tasks with Windows Server 2008
Windows Server 2008 introduces new commands for periodic disk geometry maintenance tasks, namely a new shrink feature.
Posted by Rick Vanover | August 5, 2008, 6:00 AM PDT | Latest comment by jiongs
-
Does a free VMware bare-metal hypervisor hurt Hyper-V?
VMware has made their ESXi hypervisor product a free download from their web site. Will this hurt Microsoft's foray into the virtualization market? Scott Lowe thinks it will, at least for the...
Posted by Scott Lowe | August 3, 2008, 11:45 PM PDT | Latest comment by mikedatl
-
Are you going to upgrade to Windows Server 2008?
In Windows Server 2008, you could use terminal services gateway (TSG) to allow your remote users securely through your firewall to applications running on terminal servers on your network. Combine...
Posted by Steven Warren | August 3, 2008, 9:00 PM PDT | Latest comment by reisen55@...
-
How do I use SQL Backup?
You want to make sure that that data in your database is safe. One way to ensure this is to have a good backup program in place. Steven S. Warren shows you how to use SQL Backup.
Posted by Steven Warren | August 1, 2008, 8:50 PM PDT | Latest comment by killmenot
-
Using SQLCMD to execute SQL scripts
If you use the same SQL scripts repeatedly, you can save a lot of time by creating a batch file for them. SQLCMD can help you build those batch files. Steven S. Warren shows you how to use SQLCMD...
Posted by Steven Warren | July 31, 2008, 5:08 AM PDT
-
An outage: Lessons learned
Westminster College does not currently have a backup generator protecting its data center and telephone system. That is about to change. Backup generators are no longer optional. That--and...
Posted by Scott Lowe | July 30, 2008, 6:37 AM PDT | Latest comment by tuan_cassim2000@...
-
Removing Duplicate Records using SQL Server 2005
Removing duplicate records from tables is sometimes an arduous task, especially if the source table does not contain a primary key field. Here's how you can take advantage of a new SQL Server...
Posted by Tim Chapman | July 29, 2008, 10:23 AM PDT | Latest comment by srice1969
-
Manage time accuracy in Windows Server 2008 with W32Tm
Does Windows Server 2008 mean the end to time issues in a Windows Server environment? No, but Rick Vanover discusses one command that can make it easier to manage time.
Posted by Rick Vanover | July 29, 2008, 6:00 AM PDT | Latest comment by ederkley
-
Google Apps v. Office 365: Head-to-head comparison of features
Ian Hardenburgh compares the core features of Microsoft Office 365 and Google Apps to see which one comes out on top and includes a downloadable chart for at-a-glance comparison.
Posted by Ian Hardenburgh | April 2, 2013, 12:30 PM PDT | Latest comment by maikr
-
Server 2008: Manage Open Files with Share and Storage Management
Open files have traditionally been a "pain point" for IT folks. We're often contacted by users receiving an error message regarding file access, or we're attempting to do maintenance on a server...
Posted by Scott Lowe | March 18, 2008, 8:55 PM PDT | Latest comment by Turntwo
-
How do I... Install and configure a DNS server in Windows Server 2008?
Without DNS, computers would have a very tough time communicating with each other. However, most Windows administrators still rely on WINS for name resolution on local area networks and some have...
Posted by Steven Warren | April 15, 2008, 12:05 PM PDT | Latest comment by HAL 9000
-
Calculate IOPS in a storage array
What drives storage performance? Is it the iSCSI/Fiber Channel choice? The answer might surprise you. Scott Lowe provides insight into IOPS.
Posted by Scott Lowe | February 12, 2010, 2:36 PM PST | Latest comment by sentral
-
Restart Windows Server 2003 from the command line
When the Windows Server 2003 computer you are working on will not shut down and you don't have any luck using the Start menu or the [Ctrl][Alt][Delete] methods -- and you need to restart the...
Posted by Derek Schauland | January 15, 2008, 12:00 AM PST | Latest comment by jarrod2@...
-
See what process is using a TCP port in Windows Server 2008
Windows administrators sometimes have to track down network traffic or errant processes and then match that to network traffic. Here are scripts that will aid in the connectivity forensics at the...
Posted by Rick Vanover | October 21, 2008, 5:00 AM PDT | Latest comment by arjamit
-
Windows Server 2008: Manage Internet Explorer Enhanced Security Configuration
In Windows Server 2003, Microsoft introduced the Internet Explorer Enhanced Security Configuration feature. In many organizations, the first task that admins take is to disable this "feature" as...
Posted by Scott Lowe | December 14, 2007, 10:41 PM PST | Latest comment by tamarow82
-
Help! My SQL Server Log File is too big!!!
Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth...
Posted by Tim Chapman | September 22, 2008, 1:26 PM PDT | Latest comment by mike_Chel
-
RAID 6 or RAID 1+0: Which should you choose?
RAID selection can be a tough choice, especially when budgets are tight. Learn why RAID 10 might be a better choice than RAID 6 even though it's more expensive.
Posted by Scott Lowe | June 1, 2010, 11:34 PM PDT | Latest comment by whitesites
-
RAID 5 or RAID 6: Which should you select?
Many RAID controllers now support both RAID 5 and RAID 6. IT pro Rick Vanover explains what RAID 6 is and when to select it over RAID 5.
Posted by Rick Vanover | May 24, 2010, 6:31 AM PDT | Latest comment by juanfermin@...
-
Comparing cursor vs. WHILE loop performance in SQL Server 2008
Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.
Posted by Tim Chapman | November 11, 2009, 7:03 AM PST | Latest comment by Tony Hopkinson
-
RAID 50 offers a balance of performance, storage capacity, and data integrity
RAID 50 is an often overlooked RAID level that can bridge the gap when it comes to choosing between RAID 5, RAID 6, and RAID 10. Scott Lowe explains why RAID 50 is his favorite RAID level.
Posted by Scott Lowe | July 9, 2010, 9:48 AM PDT | Latest comment by tkim@...
-
Passing table valued parameters in SQL Server 2008
SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer...
Posted by Tim Chapman | August 27, 2007, 12:47 PM PDT | Latest comment by joshgeake
-
Back up Exchange 2010 with this Windows Server 2008 R2 feature
Windows Server Backup is included with Windows Server 2008 R2 and can be a great quick-and-dirty way to back up an Exchange server. Scott Lowe explains how to use this tool.
Posted by Scott Lowe | August 26, 2010, 9:58 PM PDT | Latest comment by abb2151989@...
-
A closer look at Windows Server 2008's Active Directory Users and Computers
When administering Windows Server 2008, one of the tools you'll use most often is Active Directory Users And Computers. Here's a quick guided tour of the tool and some of the changes that have...
Posted by Scott Lowe | November 21, 2008, 7:46 AM PST
-
Block level storage vs. file level storage: A comparison
Block level storage sales have gone through the roof as more businesses realize its flexibility. File level storage is still a better option when you just need a place to dump raw files. Learn...
Posted by Scott Lowe | February 18, 2011, 12:02 PM PST | Latest comment by s2ms2r2
-
Disable UAC for Windows Servers through Group Policy
User Account Control is rarely needed for Windows Server systems. Learn how to use Group Policy to disable this feature.
Posted by Rick Vanover | February 2, 2011, 7:25 AM PST | Latest comment by pedroshimself
-
Hyper-V Recovery Manager on Windows Azure: Game changer in DR architecture
HVRM is a hybrid service that leverages the Azure public cloud and allows you to manage the replication of your primary data center to your disaster recovery (DR) site.
Posted by John Joyner | May 7, 2013, 6:00 AM PDT
-
Changing the name of your SQL Server
Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to...
Posted by Steven Warren | September 22, 2007, 9:13 PM PDT | Latest comment by blangston1
-
NTFS allocation unit sizes for large volumes
The NTFS file system has allocation unit options that usually don't matter unless there is a limitation. Rick Vanover explains how this matters for large volumes.
Posted by Rick Vanover | May 31, 2010, 11:33 PM PDT | Latest comment by neilb@...

































