Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Management
Monday, August 17, 2009 7:53 AM

The Plan for Evaluating a New Release

SQL Server 2008 R2 is now out, and you can get the "Customer Technical Preview" or CTP here: http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx But it seems like SQL Server 2008 just came out! I'm still installing and upgrading it on the systems
Posted by Buck Woody | 2 Comments
Monday, June 15, 2009 8:22 AM

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
Posted by Buck Woody | 2 Comments
Monday, April 20, 2009 7:54 AM

Listing the Central Management Servers Programmatically

I don't normally advocate hitting the system tables in any database with direct queries, preferring instead to use views or functions that the vendor provides. But so far I haven't been able to find the view or function that would return the list of servers
Posted by Buck Woody | 1 Comments
Monday, March 16, 2009 7:54 AM

Article on SQL Server Chargeback

I posted the first part of the article on SQL Server Chargeback strategies over on InformIT: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=311 The big point to make is that you will have to develop this system yourself, since there
Posted by Buck Woody | 1 Comments
Wednesday, February 04, 2009 7:29 AM

Server Consolidation Done Right

Consolidating your servers is all the rage, especially since you can save money by doing it. You can save not only on the hardware, but the licenses. To do that properly, you need a strategy. You start by detailing what you have, and then lay out the
Posted by Buck Woody | 1 Comments
Wednesday, January 07, 2009 7:36 AM

Are You Archiving Your Data?

Computer technology has been a fixture of business now for several decades - but I'm not sure it's a "mature" industry yet. Sure, we have a few standards, and some dominant vendors and a strong workforce - all earmarks of a mature industry -
Posted by Buck Woody | 1 Comments
Monday, January 05, 2009 7:40 AM

Another Reason to Use A Special Service Account

When I'm asked what the least-used feature of SQL Server is, I often have to reply that it is "good security". Many installations take all the default settings, and most use programmatic security rather than the features built in to SQL Server.
Posted by Buck Woody | 1 Comments
Wednesday, September 24, 2008 6:30 AM

The Quickest Route to a Custom Collector

The Data Collector feature in SQL Server 2008 is a new way to automate the gathering of any data from SQL Server you want to store historically. Combine that with the Management Data Warehouse and Custom reports, and you have a powerful monitoring and
Posted by Buck Woody | 1 Comments
Tuesday, August 26, 2008 7:12 AM

Data Visualizations, Part Two - Excel relationship maps

In a post back on the 6th of August I was pondering a bit about showing data relationships, such as permissions maps and so on. I mentioned that you almost need a 3-D interface for that. Well, a sharp reader, Marc Smith, read that post and pointed me
Posted by Buck Woody | 1 Comments
Wednesday, July 02, 2008 9:22 AM

SQL Server 2008 Feature Pack RC0

The SQL Server 2008 Feature Pack for RC0 is now live - if you haven't downloaded this and played with it yet, shame on you! :) OK - just kidding - it's not like you don't have a day job. However, if you'll take a few moments and look this download over
Posted by Buck Woody | 3 Comments
Friday, May 30, 2008 3:12 PM

SQL Injection Attacks

You might have read recently that there have been ongoing SQL injection attacks against vulnerable web applications occurring over the last few months. These attacks have received recurring attention in the press as they pop up in various geographies
Posted by Buck Woody | 5 Comments
Wednesday, May 14, 2008 10:11 AM

The Sysadmin DBA

I’ve worked with a few database platforms in my time, most of them in large enterprises. One difference I’ve noticed in the DBA’s on those systems is that they have “pure” DBA’s –meaning that they work primarily with the database platform, not the operating
Posted by Buck Woody | 0 Comments
Filed under: , , ,
Thursday, April 17, 2008 6:42 AM

SQL Server Management Studio Standard Reports – The Full List

I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information
Posted by Buck Woody | 1 Comments
Monday, April 14, 2008 9:51 AM

SQL Server Management Studio Standard Reports – Top Jobs

I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu
Posted by Buck Woody | 1 Comments
Thursday, April 10, 2008 10:28 AM

But is it really new?

I was showing a visitor some of the new improvements we have in SQL Server 2008 and when I started SQL Server Management Studio (SSMS), he said "oh, I thought you had something new." He expected to see a new user interface for SQL Server 2008. I don’t
Posted by Buck Woody | 1 Comments
More Posts Next page »
 
Page view tracker