Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Metadata
Monday, November 16, 2009 7:19 AM

Color Me Corrected – Will the REAL sysobjects please stand up?

A few days ago I posted a way to look at the Dynamic Management Views (DMV’s) using a query, which I then copy and paste into the Help viewer’s Index tab to learn more. Well, my good friend and Colleague, Cliff, pointed out that I was using the older
Posted by Buck Woody | 1 Comments
Tuesday, May 05, 2009 9:47 AM

T-SQL to Find Physical and Logical Processors

I ran into a licensing question the other day on Physical versus Logical Processors. Happily, Microsoft only charges you for Physical sockets - which you can find with this query: SELECT cpu_count / hyperthread_ratio AS PhysicalCPUs FROM sys.dm_os_sys_info
Posted by Buck Woody | 1 Comments
Wednesday, April 22, 2009 6:41 AM

Database Diagram Error "Cannot Create Objects"

If you've ever tried to design a new database diagram and gotten a "cannot create objects" error, you've probably noticed the correction steps to use the ALTER AUTHORIZATION statement to change the owner. This happens a lot to me - I'll be on
Posted by Buck Woody | 1 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, February 02, 2009 9:50 AM

Check that database before you restore it...

I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as
Posted by Buck Woody | 1 Comments
Tuesday, January 27, 2009 9:13 AM

Versioning the Database

If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire
Posted by Buck Woody | 1 Comments
Thursday, January 22, 2009 10:21 AM

Is a Comprehensive Data Map Possible?

Most of us design a "CRUD" (Create, Read, Update and Delete) matrix for an application's database. And if you are really thorough, you create a data dictionary that shows what data goes where and why. The problem with these documents is that
Posted by Buck Woody | 2 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
Tuesday, April 01, 2008 8:57 AM

Checking Your System

In most checklists for SQL Server, including the one I explained on my last Podcast , you're told to "check your system". In fact, most instructors and DBA Experts will not look kindly on you if you don’t. But what does that mean? Well, I’ll probably
Posted by Buck Woody | 0 Comments
Monday, March 31, 2008 8:40 AM

SQL Server Management Studio Standard Reports – Job Steps Execution History

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 | 0 Comments
Monday, March 24, 2008 10:05 AM

SQL Server Management Studio Standard Reports – Notification Services - General

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 Management node. From the menu that
Posted by Buck Woody | 1 Comments
Thursday, March 20, 2008 8:59 AM

SQL Server Management Studio Standard Reports – Number of Errors

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 Management node. From the menu that
Posted by Buck Woody | 0 Comments
Monday, March 17, 2008 8:58 AM

SQL Server Management Studio Standard Reports – Tasks

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 Management node. From the menu that
Posted by Buck Woody | 1 Comments
Friday, March 14, 2008 9:02 AM

Time-based Optimization

One of the primary jobs of both developers and DBAs is optimization, or its more common name, performance tuning. Lots of the management tools improvements for SQL Server 2008 are aimed at performance, such as the new activity Monitor. Using the tools
Posted by Buck Woody | 1 Comments
More Posts Next page »
 
Page view tracker