February 2008 - Posts

Real-World DBA Podcast Show Notes – Episode 1: SQL Server Editions
29 February 08 07:22 PM | Buck Woody | 3 Comments   
http://edge.technet.com/Media/Real-World-DBA-Episode-1-SQL-Server-Editions/ The Zune(OK, iPod works too) link for subscription is here: http://edge.technet.com/Tags/Real+World+DBA/feed/ipod/ And the general RSS feed is here: http://edge.technet.com/Tags/Real+World+DBA/RSS/ Read More...
Filed under:
SQL Server Management Studio Standard Reports –Service Broker Statistics: [DatabaseName]
29 February 08 10:26 AM | Buck Woody | 2 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
Introducing the Real World DBA
28 February 08 07:18 AM | Buck Woody | 2 Comments   
On the bus-ride to work, I listen to some music while I work on the laptop, and each morning I listen to a Podcast or two. Some are very good - others are just passable - so I thought I would toss my hat in the ring. In the next couple of weeks I'll introduce Read More...
Filed under:
Setting up a Testing System
27 February 08 08:24 AM | Buck Woody | 1 Comments   
I build a new SQL Server just about every other day. As we write new software or fix bugs on old software, we create a new installation of SQL Server. Those of us who are testing the fixes, creating new features and so on have to install these new versions Read More...
SQL Server Management Studio Standard Reports –User Statistics: [DatabaseName]
26 February 08 09:12 AM | Buck Woody | 3 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
SQL Server Management Studio Standard Reports – Schema Changes History: [DatabaseName]
25 February 08 09:24 AM | Buck Woody | 2 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
What the Developer needs to Know - About Database Programming
22 February 08 09:04 AM | Buck Woody | 2 Comments   
In a previous post, I discussed a few broad-level topics that DBAs need to know about working with database systems. Today I thought I would describe the topics developers need to know about databases to work with them efficiently. Let's start by pointing Read More...
Filed under: ,
Tips for (getting ready to deal with) Support
21 February 08 08:52 AM | Buck Woody | 1 Comments   
At one time or another, we all need a little help. When you’re knee-deep in Production and you run into a Problem, a little panic is unavoidable. Having a military background, I’ve been taught that the best way to deal with inevitable panic is preparation. Read More...
What the DBA needs to know
20 February 08 09:11 AM | Buck Woody | 2 Comments   
What knowledge is needed to effectively manage a database system? That depends, of course, on what you mean by “manage” and “database system". For this discussion, I’ll define “manage” to include not only pure maintenance tasks but also creation and design Read More...
Filed under: ,
Do we use the same tools and processes at Microsoft that you do?
19 February 08 09:26 AM | Buck Woody | 3 Comments   
I’ve spoken quite a bit about some of the processes and constraints we have in developing software here at Microsoft. I haven’t explained the actual tools or specific paradigms we follow. When some people come to work here, they are often surprised to Read More...
SQL Server Management Studio Standard Reports – Index Physical Statistics: [DatabaseName]
18 February 08 09:11 AM | Buck Woody | 2 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
Engineering or Manufacturing
15 February 08 09:50 AM | Buck Woody | 7 Comments   
From the metrics on this blog, I see that many of you are either software developers or are database administrators involved with developing software solutions, either for your own company or for sale. I have often seen the process of creating applications Read More...
System Center Operations Manager and SQL Server
14 February 08 07:02 AM | Buck Woody | 3 Comments   
If you have multiple systems in your organization, and especially if you use multiple kinds of systems (such as exchange, Forefront and SQL Server, for instance) then you might want to check out Microsoft System Center, and in particular, System Center Read More...
A Few Links to SQL Server 2008 Resources
13 February 08 09:17 AM | Buck Woody | 5 Comments   
As I was presenting at TechReady yesterday on the new SQL Server 2008 features that will directly affect Microsoft System Center, I was asked a few times about some resources where people could go to learn more about it. I thought I would share that here. Read More...
Filed under: ,
Working to Get the Field Ready
12 February 08 09:42 AM | Buck Woody | 1 Comments   
In the final days before a release, the Program Managers face pressure on two fronts: on one hand, we are asked to work extra hard to get the features ready for the final release. There’s a lot of testing, re-coding and more testing to do. Sure, we have Read More...
Filed under: ,
Legal aspects of writing software
11 February 08 09:23 AM | Buck Woody | 1 Comments   
Along with some of the other requirements and challenges we face in developing software for the global marketplace are legal ramifications. Almost everything we write, from the name of the feature to the shape of the icons, is usually subject to some Read More...
Making our Software Accessible
08 February 08 07:16 AM | Buck Woody | 2 Comments   
Earlier I spoke a little about some of what we go through to localize and globalize our software, and today I thought I might mention a little about how we make it accessible to different kinds of people. I was thinking about this late last night as I Read More...
Localizing Our Software
07 February 08 09:20 AM | Buck Woody | 1 Comments   
If you want to sell (or give away) your software in multiple countries, you need to think about Localization , which simply means ensuring that the application can be used in other places. At Microsoft, and in SQL Server in particular, we actually break Read More...
SQL Server Management Studio Standard Reports – Index Usage Statistics: [DatabaseName]
06 February 08 09:28 AM | Buck Woody | 2 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
Sharing the Code
05 February 08 10:02 AM | Buck Woody | 1 Comments   
I’ve worked in several multi-developer/multi-DBA shops in my day, and I’ve also taught a few DBA courses here and there. If you’re in the same situation, you know that it’s often important to be able to show your code to others. I have two tips for SQL Read More...
SQL Server Management Studio Standard Reports – Object Execution Statistics: [DatabaseName]
04 February 08 09:32 AM | Buck Woody | 1 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
Where should the tools be?
01 February 08 06:05 AM | Buck Woody | 5 Comments   
I've got another question for you - where should the tools be? Let me explain. Most of the time when you connect to SQL Server, you open SQL Server Management Studio (SSMS) on a client machine and then type in the name of a server somewhere on the network. Read More...
Page view tracker