Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008
Monday, November 09, 2009 6:54 AM

Create an Excel Graph of your Big Tables – with PowerShell!

I showed a demo of how to find the top ten tables in the database at the PASS Conference. Here’s that script – you’ll need to fix the server name, instance name, and database name. You can use this to display any numbers – and even more. The mind reels
Posted by Buck Woody | 0 Comments
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
Tuesday, October 20, 2009 6:49 AM

The Fourth Paradigm

Microsoft Research published a book based on Dr. Jim Gray’s research into Computer Science, called “The Fourth Paradigm”. It’s about 300 pages long, and it fascinated me so much I stayed up reading it last night. I have so many notes to decompress it
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
Tuesday, October 13, 2009 8:44 AM

Go To Find Combo

A friend of mine – Bill Ramos – showed me a little-used feature in Management Studio that I’ve been using ever since. It’s a combo box that works in the Query Window and it allows you to find text quickly in a script, but it also has a hidden benefit.
Posted by Buck Woody | 0 Comments
Thursday, October 08, 2009 6:58 AM

Channel 9 – The PASS Interviews

I recently interviewed (on Channel 9) a few of the folks that are presenting at PASS this year – I thought I would share the links so you can check them out: http://channel9.msdn.com/posts/LarryLarsen/Upcoming-SQL-PASS-Summit-1/ http://channel9.msdn.com/posts/LarryLarsen/Upcoming-SQL-PASS-Summit-2
Posted by Buck Woody | 0 Comments
Thursday, October 01, 2009 6:20 AM

SQL Saturday in Redmond – Stop By and Say Hello!

http://www.sqlsaturday.com/ This Saturday I’ll be speaking at the “SQL Saturday” event in my own backyard – Redmond, Washington! I really enjoy these events – enough to give up a Saturday to come out and join you. No, we don’t get paid for these, it’s
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
Tuesday, September 22, 2009 7:20 AM

Speaking Schedule for October 2009

I’ll be speaking at two of the “SQL Saturday” Events in the next month. The first is here in my own back-yard, in Redmond, Washington. I’ll be demonstrating the Resource Governor with simple, easy-to-follow examples, and I’ll even show you how to monitor
Posted by Buck Woody | 0 Comments
Monday, September 07, 2009 8:36 AM

SQL Server Desktop Screen Background

I was doing a presentation recently and was asked about the image I use as my background on my desktop. I’m happy to share it! Click below for the full size:
Posted by Buck Woody | 0 Comments
Monday, August 03, 2009 7:52 AM

The SQL Server 2008 Developer Training Kit

Want some free training? I think Microsoft does an amazing job of getting training out for free. If you need a boost for your career, are just starting out, or need to re-tool after a layoff, or if you just want to become more familiar with the latest
Posted by Buck Woody | 0 Comments
Thursday, July 30, 2009 9:45 AM

Code Collapse and Expand Feature in SQL Server Management Studio 2008

In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath.
Posted by Buck Woody | 2 Comments
Tuesday, July 28, 2009 9:11 AM

Should I stay or Should I Go?

I'm writing this post on a bus headed towards the Seattle Convention Center, where the technical folks in the field meet once a year to hear from the product teams about all the new features coming in the future. I used to present at this conference (and
Posted by Buck Woody | 0 Comments
Thursday, July 23, 2009 6:29 AM

SQL Server Management Studio Tips and Tricks

Are you getting everything out of your SQL Server tools that you can? I’ve given you lots of tricks and tips here on my blog, but nothing beats an on-screen demonstration. My good friend and former teammate Bill Ramos did a session on SQL Server
Posted by Buck Woody | 0 Comments
More Posts Next page »
 
Page view tracker