Welcome to MSDN Blogs
Sign in
|
Join
|
Help
Carpe Datum
Data Flotsam and Jetsam
This Blog
About
Email
Syndication
RSS 2.0
Atom 1.0
Search
News
Having trouble with a feed from this site? Post a reply to any blog entry.
Tags
Administration
Agent
Best Practices
Book Review
Business Intelligence
Career
Certifications
Computing
Conferences
Connections
Customer Contact
DBA
Design
Developer
Development
Disaster Recovery
Documentation
Downloads
Encryption
Error Codes
Help
Indexes
Latest Version
Link Lists
Links
Locks
Longhorn
Maintenance
Maintenance Plans
Management
Metadata
Microsoft
Microsoft Update
MSDN
PASS
PBM
Performance Tuning
Personal
Planning
Podcast
Policy Based Management
PowerShell
Process
Questions
Quote Of The Day
Rant
Real World DBA
SCOM
Scripts
Searching
Security
Service Packs
SOA
SQL Server
SQL Server 2000
SQL Server 2008
SQL Server Documentation
SQL Server Downloads
SQL Server Management Studio
SSIS
SSMS
Standard Reports
Strings
Support
System Center Operations Manager
Technet
Testing
Tips
T-SQL
Tutorials
Upgrades
Virtualization
Walkthroughs
Web
Windows 2008
Recent Posts
Quote of the Day – On Having a Purpose
Using Perfmon with SQL Server – Part Two
Using Perfmon with SQL Server – Part One
Channeling Bruce Lee: Tuning without Tuning
Color Me Corrected – Will the REAL sysobjects please stand up?
Archives
November 2009 (15)
October 2009 (23)
September 2009 (22)
August 2009 (21)
July 2009 (23)
June 2009 (23)
May 2009 (21)
April 2009 (22)
March 2009 (23)
February 2009 (20)
January 2009 (22)
December 2008 (23)
November 2008 (19)
October 2008 (24)
September 2008 (22)
August 2008 (22)
July 2008 (21)
June 2008 (21)
May 2008 (21)
April 2008 (25)
March 2008 (23)
February 2008 (22)
January 2008 (21)
December 2007 (15)
November 2007 (18)
October 2007 (23)
September 2007 (21)
August 2007 (21)
July 2007 (1)
June 2007 (3)
May 2007 (3)
April 2007 (3)
March 2007 (2)
February 2007 (3)
Browse by Tags
All Tags
»
Developer
Administration
Best Practices
Book Review
Career
Computing
Conferences
Connections
DBA
Design
Development
Disaster Recovery
Documentation
Downloads
Encryption
Error Codes
Help
Indexes
Latest Version
Links
Maintenance
Management
Metadata
Microsoft
Microsoft Update
MSDN
Performance Tuning
Personal
Planning
PowerShell
Process
Questions
Rant
Scripts
Searching
Security
Service Packs
SQL Server
SQL Server 2000
SQL Server 2008
SQL Server Documentation
SQL Server Downloads
SQL Server Management Studio
SSIS
SSMS
Support
Technet
Testing
Tips
T-SQL
Tutorials
Upgrades
Virtualization
Walkthroughs
Web
Windows 2008
Tuesday, November 17, 2009 7:03 AM
Channeling Bruce Lee: Tuning without Tuning
I’m leading a Performance Tuning workshop here in Portland, Oregon today, and I normally start this kind of workshop with a segment on “pre-tuning” – or, the steps you take so that you don’t have to tune as much later. When we set up a system is the greatest
Posted by
Buck Woody
|
0 Comments
Filed under:
Developer
,
DBA
,
Development
,
SQL Server
,
Performance Tuning
,
Design
,
Testing
,
Tips
Tuesday, November 10, 2009 7:18 AM
Visio Video (killed the radio star)
I teach a class at the University of Washington, and in that class I have the students create a few Entity Relationship Diagrams (ERDs). I’m still looking for a decent tool to do that, since the only ones I know that do a good job are WAY too expensive.
Posted by
Buck Woody
|
0 Comments
Filed under:
Tutorials
,
Web
,
Developer
,
DBA
,
Development
,
SQL Server
,
Design
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
Filed under:
Documentation
,
Developer
,
DBA
,
Development
,
SQL Server
,
Administration
,
Performance Tuning
,
Conferences
,
SQL Server 2008
,
Tips
Tuesday, November 03, 2009 8:24 AM
DBA? No – Data Professionals
I’m here at the Professional Association for SQL Server (PASS) this week, and I’m here in the keynote. A few days ago I ranted about the fact that DBA should be a Data Professional – not an administrator. I’ve heard a lot of response about that blog –
Posted by
Buck Woody
|
0 Comments
Filed under:
Developer
,
DBA
,
SQL Server
,
Career
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
Filed under:
SSMS
,
Developer
,
DBA
,
Development
,
SQL Server
,
Administration
,
Design
,
SQL Server Management Studio
,
Computing
,
SQL Server 2008
,
Tips
,
Virtualization
Thursday, October 29, 2009 6:23 AM
Don’t be a DBA – Be a Data Professional
I get asked quite frequently now about the “Cloud” technology and how it will affect the job of the DBA. The answer to that is pretty easy: If you’re “just a DBA”, then it will affect you a great deal. The fact that someone else will add users, take backups
Posted by
Buck Woody
|
0 Comments
Filed under:
Developer
,
DBA
,
SQL Server
,
Career
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
Filed under:
SSMS
,
Developer
,
DBA
,
Scripts
,
Development
,
SQL Server
,
Administration
,
Design
,
SQL Server Management Studio
,
Tips
Monday, October 26, 2009 6:50 AM
How Normal(ized) Should You Be?
Normalization is the process of removing repeating values from your data design, and ensuring that the values depend on the Primary Key in the table. OK, it’s a bit more complicated than that, but this definition will do for this post. So how far DO you
Posted by
Buck Woody
|
2 Comments
Filed under:
Developer
,
DBA
,
Development
,
SQL Server
,
Design
,
Tips
Wednesday, October 21, 2009 7:14 AM
The 20 Queries
In the book “The Fourth Paradigm” , Jim Gray describes the modeling process he came up with modeling large databases. He was working with scientists, researchers and others, and the data sets they were generating were huge – terabytes of data at a time.
Posted by
Buck Woody
|
0 Comments
Filed under:
Developer
,
DBA
,
Development
,
SQL Server
,
Design
,
Computing
,
Book Review
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
Filed under:
SSMS
,
Developer
,
DBA
,
Development
,
SQL Server
,
Administration
,
SQL Server Management Studio
,
SQL Server 2008
,
Tips
,
Best Practices
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
Filed under:
Tutorials
,
SSMS
,
Developer
,
DBA
,
Development
,
SQL Server
,
SQL Server Management Studio
,
SQL Server 2008
,
Tips
Tuesday, October 06, 2009 9:18 AM
The Much-Maligned Database Designer
There’s a feature in SQL Server Management Studio called the “Database Designer”, and it’s a strange beast indeed. It’s a mix between a graphical database design tool and an Entity Relationship Diagram (ERD). Unfortunately, I don’t think it does either
Posted by
Buck Woody
|
0 Comments
Filed under:
Developer
,
DBA
,
SQL Server
,
Design
Wednesday, September 30, 2009 5:55 PM
The ERD as a Communication Tool
I teach a college course at the University of Washington, and as part of the class I include a series on creating a using an Entity Relationship Diagram, or ERD. An ERD, as I’m sure most of you know, is a series of box and connector shapes that explain
Posted by
Buck Woody
|
0 Comments
Filed under:
Developer
,
DBA
,
Development
,
SQL Server
,
Design
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
Filed under:
Developer
,
DBA
,
SQL Server
,
Administration
,
Performance Tuning
,
Windows 2008
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
Filed under:
Developer
,
DBA
,
SQL Server
,
Administration
,
Performance Tuning
,
Testing
,
Windows 2008
,
Tips
More Posts
Next page »