Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Administration
Wednesday, November 04, 2009 8:04 AM

Find and learn DMVs

This morning I showed how I find DMVs, and find out how to use them. First, I just run this query:   USE MASTER; GO SELECT ‘sys.’ + name FROM sys.sysobjects WHERE name LIKE ‘dm%’   Then I copy and paste a result into the “Index” panel of Books
Posted by Buck Woody | 0 Comments
Monday, November 02, 2009 6:28 AM

Win7 – Install SQL Server Native or go Virtual PC?

I have Windows 7 on my laptop, and I also teach, demo and use SQL Server 2005 and SQL server 2008. Should I install this “native” on my outside operating system or use the Virtual PC (VPC) software that comes with Windows 7? Well, there are arguments
Posted by Buck Woody | 0 Comments
Wednesday, October 28, 2009 8:13 AM

Templates for New Query Window

When I’m in SQL Server Management Studio and I click the “New Query” button, my Query Window comes up like this: /* <ScriptFileName, SYSNAME, ScriptFileName>.sql Purpose: <Purpose, SYSNAME, Purpose> Author: <Author, SYSNAME, Buck Woody>
Posted by Buck Woody | 0 Comments
Tuesday, October 27, 2009 7:14 AM

Disaster Response and the Physical Plant

Near our home is a Dam about to break. It was built long ago, and even though millions were taxed and spent for it, little to none of that money ever got to the actual shoring up and maintaining the dam  over time (don’t get me started). Anyway,
Posted by Buck Woody | 0 Comments
Wednesday, October 14, 2009 8:37 AM

Color Your Connections

In cyber-space, no one can hear you scream. Have you ever connected to a server, thought it was a testing or development system, and only a split second after you pressed “F5” to run that command, realized that it was the production server? Yeah….me neither
Posted by Buck Woody | 0 Comments
Wednesday, October 07, 2009 6:50 AM

Free Hyper-V Book

I work with a gentleman here in the Pacific Northwest who joined the Microsoft Server team from VMWare, and he in turn has a good friend (John Kelbley) who wrote a book on Hyper-V that you can get for free –  you can get it here: http://www.netapp.com/hyper
Posted by Buck Woody | 0 Comments
Tuesday, September 29, 2009 6:45 AM

Great new Whitepaper on High Availability

Paul Randal, he of SQLskills.com fame, has published a new whitepaper on High Availability with SQL Server. If you follow any SQL Server news or blog sites, you’ve probably already see the announcement for it, but I wanted to mention it here in case you
Posted by Buck Woody | 0 Comments
Wednesday, September 23, 2009 6:11 AM

Remember to include the Standard Deviation

I do a lot of performance analysis on SQL Server Instances, and I normally start with a series of Performance Counters from both Windows and SQL Server. This gives me the ability to limit what I need to look at by seeing which Hardware and Windows components
Posted by Buck Woody | 0 Comments
Thursday, September 17, 2009 8:26 AM

How Microsoft Does IT

One of my favorite ways to learn is through examples. If you’ll explain what something does and a little of how it works,and then give me an example to decompose, I usually come up to speed pretty quickly. I’ve been carrying a DVD (and CD’s before that)
Posted by Buck Woody | 0 Comments
Wednesday, September 16, 2009 6:24 AM

Opening a Windows Perfmon File in Profiler – Part Two

In a previous blog entry , I mentioned you could import a Windows Perfmon log into SQL Server Profiler. I received a note that someone was having a problem doing this, and when we looked over his situation, it turned out that he was using a Windows Perfmon
Posted by Buck Woody | 0 Comments
Monday, September 14, 2009 7:14 AM

Using Perfmon Data in Profiler

In SQL Server 2005 a great new feature was introduced into SQL Server Profiler – the ability to import Perfmon data. If you’re not familiar with one or both of those tools, SQL Server Profiler is a package included with SQL Server that can “watch” your
Posted by Buck Woody | 0 Comments
Thursday, September 10, 2009 6:34 AM

Adding a NIC – Part Two

I got this comment from the post yesterday: “ It's just as easy to use gigabit instead 10/100. Further, where is this administration being done? Most likely there is some other pipe that will have to be shared between any amount of connections. And at
Posted by Buck Woody | 0 Comments
Wednesday, September 09, 2009 9:15 AM

SQL Server Best Practices: Separate NIC for Maintenance and Transfers

Many people aren’t aware of how important the Network Interface Card (NIC) in their system really is. If you picture your database as a warehouse, the NIC devices are the doors and bays where stuff comes in and out. Imagine if you had one door, and everyone
Posted by Buck Woody | 0 Comments
Thursday, August 27, 2009 7:28 AM

Test your Restores, or, a Cautionary Tale

The other day I rebuilt a test system, and as a result I wanted to restore a few of my test databases. I've done a lot of customization in those, fuzzed some of the private data and so on, that they've moved dangerously close to a "production" database,
Posted by Buck Woody | 0 Comments
Wednesday, August 26, 2009 8:25 AM

SQL Server Best Practices: Disk Partition Alignment

OK - this one is a little more involved than the other best practices I've posted here. In fact, I'm going to have to send you off to another document at the end of this post to explain the technical background and the exact steps you need to perform,
Posted by Buck Woody | 0 Comments
More Posts Next page »
 
Page view tracker