DBA

Hardware Analysis / Design / Provisioning

2012-09-17T17:08:59-05:00:00

Paul Randal post about Hardware Analysis / Design / Provisioning

till later,

Why are so many DBCC commands undocumented?

2012-06-05T11:15:53-05:00:00

Paul Randal of SQLskills.com does a great job of answering the question of why there are so many undocumented DBCC commands in his post Why are so many DBCC commands undocumented?

I would like to go on to say that not only does this apply to the DBCC commands but is some respect to all parts of SQL, other Servers, IDE's, Operating Systems, just about everywhere. There is always something that just does not make it into the official documentation.

And as Paul points out probably never will make it.

That could be why there are so many "Tips & Tricks" types of books, blog post, etc. everywhere you look.

And I also agree with Janos's comments on Paul's post, which was "I'm fine with them undocumented. All of us who need to use these commands know where to find "documentation" and whom to ask ".

Till later,

BI--What is it really? from Richard’s Attic

2011-08-31T10:33:10-05:00:00

Richard brings out some really good points about BI and where it came from and why you need it.

Check out his post for details ==> BI--What is it really? » Richard's Attic

till later,

John

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

2011-08-25T05:04:30-05:00:00

Please vote for Ola Hallengren, in my opinion he has the best maintenance scripts, and best of all “THERE FREE!”.

You can check out his scripts and well as the link to vote from this page SQL Server Backup, Integrity Check, Index and Statistics Maintenance

till later,
John

In Recovery... | (Not a) CHECKDB error "Unable to deallocate a kept page"

2011-06-20T22:31:53-05:00:00

Check out what Paul Randall discovered with DBCC CHECKDB with SQL 2005

In Recovery... | (Not a) CHECKDB error "Unable to deallocate a kept page"

A new blogger in town.

2011-06-01T15:29:53-05:00:00

Let’s all welcome Samuel Mathew to the Dynamics Blogging community

Till later,

John