Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Microsoft

How Microsoft Does IT - Updated

I’ve pointed out this link before, and I’ll definitely bring it up again. Microsoft is one of the few companies I know, especially the big ones, that explains how they run their IT. We have a fantastic, I mean really fantastic site that you should definitely

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)

Who do I talk to in Microsoft about…

Have you ever seen one of us “Softies” (Microsoft Professionals) at a conference, briefing or on Mount Rainier on a motorcycle and said “You work for Microsoft? I need your help on fixing….”? Perhaps you heard back from that person, or perhaps you lost

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

SQL Server Best Practices: Auto-Shrink Should Be Off

SQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close, some of them should be left off. The Auto-Shrink setting is another. That might surprise a few people. You might

What's a Microsoft "Fast Track" for Data Warehousing?

Microsoft is a platform company, meaning that we don't often sell pre-packaged solutions, but rather tools for you to make them. In other words, we sell Microsoft Word, we don't type the letters for you. But in some cases you might like to have a little

SQL Server Best Practices: AutoClose Should be Off

When SQL Server "opens" a database, resources are assigned to maintaining that state. Memory for locks, buffers, security tokens and so on is assigned, and there is associated CPU and even a little I/O. When connections are made to the database,

Is Your Infrastructure Crumbling?

I watched a documentary (of sorts) last night called "Crumbling America" that talked about America's infrastructure issues. They detailed how roads, bridges, electrical grids and water systems are having serious issues and are basically falling

Help Me Help You

Before I start this post, let me say that it is not pointed at any one person - if you've asked me for help recently, this isn't about you! The programming and administration computer disciplines are fairly unique, in my mind, in one interesting way:

SQL Server Best Practices: User-Defined Schemas

Schemas are a feature that gained wide use in SQL Server 2005. They are essentially containers that allow some objects to be grouped together. Actually, there have always been schemas in SQL Server, it's just that we only exposed one - called "dbo"

SQL Server Management Studio - Copy With Headers

I'm writing this on the train to Seattle to visit with a customer this morning - I'm thankful for Wireless! Although setting up a wireless network for a train is a really big thing, sometimes it's the smaller things that make us happy. In SQL Server Management

Moving Tables Between Filegroups

I got an e-mail in response to the Best Practices blogs on Filegroups. I've gotten other e-mails similar to this one, so I thought I would answer (or try to) all of them here. Here's the e-mail:   " I recently started a new DBA job.   When

SQL Server Best Practices: File Layouts

In a previous post, I mentioned that you should use Filegroups and I talked a little about those. In this post, the best practice I'll point out is where those files should live. As a general rule of thumb, more "spindles" in a database are better. What

The Role of the DBA in the "Cloud"

I really dislike the new "cloud" term, since it's really just computing, but I get the point. The larger question is, what is the role of the DBA in a "cloud" environment? If your company moves the data substructure into a provider,
Posted by Buck Woody | 1 Comments
Filed under: , , ,

Why Use PowerShell with SQL Server?

If you've never read the "scripting guys" at Microsoft, they are a hoot. Ed Wilson and Craig Liebendorfer do a fantastic job of writing each week and helping with scripting of all kinds, including PowerShell. Well, this week they appointed me
Posted by Buck Woody | 1 Comments
More Posts Next page »
 
Page view tracker