http://geekswithblogs.net/DBA/Default.aspx by John Lowther en-US DBA jlowther@sta-home.com Subtext Version 0.0.0.0 http://geekswithblogs.net/images/RSS2Image.gif http://geekswithblogs.net/DBA/Default.aspx 77 60 http://geekswithblogs.net/DBA/archive/2012/09/17/hardware-analysis--design--provisioning.aspx <p>Originally posted on: <a href='http://geekswithblogs.net/DBA/archive/2012/09/17/hardware-analysis--design--provisioning.aspx'>http://geekswithblogs.net/DBA/archive/2012/09/17/hardware-analysis--design--provisioning.aspx</a></p><p>Paul Randal post about <a href="http://www.sqlskills.com/Hardware.asp" target="_blank">Hardware Analysis / Design / Provisioning</a></p> <p>till later,</p> <img src="http://geekswithblogs.net/DBA/aggbug/150740.aspx" width="1" height="1" /> DBA http://geekswithblogs.net/DBA/archive/2012/09/17/hardware-analysis--design--provisioning.aspx Mon, 17 Sep 2012 22:08:59 GMT http://geekswithblogs.net/DBA/comments/150740.aspx http://geekswithblogs.net/DBA/archive/2012/09/17/hardware-analysis--design--provisioning.aspx#feedback http://geekswithblogs.net/DBA/comments/commentRss/150740.aspx http://geekswithblogs.net/DBA/services/trackbacks/150740.aspx FYI http://geekswithblogs.net/DBA/archive/2012/06/05/why-are-so-many-dbcc-commands-undocumented.aspx <p>Originally posted on: <a href='http://geekswithblogs.net/DBA/archive/2012/06/05/why-are-so-many-dbcc-commands-undocumented.aspx'>http://geekswithblogs.net/DBA/archive/2012/06/05/why-are-so-many-dbcc-commands-undocumented.aspx</a></p><p>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 <a href="http://www.sqlskills.com/BLOGS/PAUL/post/Why-are-so-many-DBCC-commands-undocumented.aspx" target="_blank">Why are so many DBCC commands undocumented?</a></p> <p>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.</p> <p>And as Paul points out probably never will make it. </p> <p>That could be why there are so many "Tips &amp; Tricks" types of books, blog post, etc. everywhere you look. </p> <p>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 <img alt="Wink" src="http://www.sqlskills.com/BLOGS/PAUL/editors/tiny_mce/plugins/emotions/images/smiley-wink.gif" />".</p> <p>Till later,</p> <img src="http://geekswithblogs.net/DBA/aggbug/149822.aspx" width="1" height="1" /> DBA http://geekswithblogs.net/DBA/archive/2012/06/05/why-are-so-many-dbcc-commands-undocumented.aspx Tue, 05 Jun 2012 16:15:53 GMT http://geekswithblogs.net/DBA/comments/149822.aspx http://geekswithblogs.net/DBA/archive/2012/06/05/why-are-so-many-dbcc-commands-undocumented.aspx#feedback http://geekswithblogs.net/DBA/comments/commentRss/149822.aspx http://geekswithblogs.net/DBA/services/trackbacks/149822.aspx Business Intelligence & Reporting http://geekswithblogs.net/DBA/archive/2011/08/31/bi--what-is-it-really-from-richardrsquos-attic.aspx <p>Originally posted on: <a href='http://geekswithblogs.net/DBA/archive/2011/08/31/bi--what-is-it-really-from-richardrsquos-attic.aspx'>http://geekswithblogs.net/DBA/archive/2011/08/31/bi--what-is-it-really-from-richardrsquos-attic.aspx</a></p><p>Richard brings out some really good points about BI and where it came from and why you need it.</p> <p>Check out his post for details ==&gt; <a href="http://dynamicsgpbooks.com/index.php?option=com_wordpress&amp;p=92&amp;Itemid=68">BI--What is it really? » Richard's Attic</a></p> <p> </p> <p>till later,</p> <p><a href="http://community.dynamics.com/members/John-Lowther/default.aspx">John</a></p> <img src="http://geekswithblogs.net/DBA/aggbug/146721.aspx" width="1" height="1" /> DBA http://geekswithblogs.net/DBA/archive/2011/08/31/bi--what-is-it-really-from-richardrsquos-attic.aspx Wed, 31 Aug 2011 15:33:10 GMT http://geekswithblogs.net/DBA/comments/146721.aspx http://geekswithblogs.net/DBA/archive/2011/08/31/bi--what-is-it-really-from-richardrsquos-attic.aspx#feedback 1 http://geekswithblogs.net/DBA/comments/commentRss/146721.aspx http://geekswithblogs.net/DBA/services/trackbacks/146721.aspx http://geekswithblogs.net/DBA/archive/2011/08/25/sql-server-backup-integrity-check-index-and-statistics-maintenance.aspx <p>Originally posted on: <a href='http://geekswithblogs.net/DBA/archive/2011/08/25/sql-server-backup-integrity-check-index-and-statistics-maintenance.aspx'>http://geekswithblogs.net/DBA/archive/2011/08/25/sql-server-backup-integrity-check-index-and-statistics-maintenance.aspx</a></p><p>Please vote for Ola Hallengren, in my opinion he has the best maintenance scripts, and best of all “THERE FREE!”.</p> <p>You can check out his scripts and well as the link to vote from this page <a href="http://ola.hallengren.com/">SQL Server Backup, Integrity Check, Index and Statistics Maintenance</a></p> <p>till later, <br />John</p> <img src="http://geekswithblogs.net/DBA/aggbug/146661.aspx" width="1" height="1" /> DBA http://geekswithblogs.net/DBA/archive/2011/08/25/sql-server-backup-integrity-check-index-and-statistics-maintenance.aspx Thu, 25 Aug 2011 10:04:30 GMT http://geekswithblogs.net/DBA/comments/146661.aspx http://geekswithblogs.net/DBA/archive/2011/08/25/sql-server-backup-integrity-check-index-and-statistics-maintenance.aspx#feedback http://geekswithblogs.net/DBA/comments/commentRss/146661.aspx http://geekswithblogs.net/DBA/services/trackbacks/146661.aspx http://geekswithblogs.net/DBA/archive/2011/06/20/in-recovery.--not-a-checkdb-error-quotunable-to-deallocate.aspx <p>Originally posted on: <a href='http://geekswithblogs.net/DBA/archive/2011/06/20/in-recovery.--not-a-checkdb-error-quotunable-to-deallocate.aspx'>http://geekswithblogs.net/DBA/archive/2011/06/20/in-recovery.--not-a-checkdb-error-quotunable-to-deallocate.aspx</a></p><p>Check out what Paul Randall discovered with DBCC CHECKDB with SQL 2005</p> <p><a href="http://www.sqlskills.com/BLOGS/PAUL/post/(Not-a)-CHECKDB-error-Unable-to-deallocate-a-kept-page.aspx">In Recovery... | (Not a) CHECKDB error "Unable to deallocate a kept page"</a></p> <img src="http://geekswithblogs.net/DBA/aggbug/145932.aspx" width="1" height="1" /> DBA http://geekswithblogs.net/DBA/archive/2011/06/20/in-recovery.--not-a-checkdb-error-quotunable-to-deallocate.aspx Tue, 21 Jun 2011 03:31:53 GMT http://geekswithblogs.net/DBA/comments/145932.aspx http://geekswithblogs.net/DBA/archive/2011/06/20/in-recovery.--not-a-checkdb-error-quotunable-to-deallocate.aspx#feedback http://geekswithblogs.net/DBA/comments/commentRss/145932.aspx http://geekswithblogs.net/DBA/services/trackbacks/145932.aspx FYI http://geekswithblogs.net/DBA/archive/2011/06/01/a-new-blogger-in-town.aspx <p>Originally posted on: <a href='http://geekswithblogs.net/DBA/archive/2011/06/01/a-new-blogger-in-town.aspx'>http://geekswithblogs.net/DBA/archive/2011/06/01/a-new-blogger-in-town.aspx</a></p><p>Let’s all welcome <a href="http://www.smathew-gpblog.com/">Samuel Mathew</a> to the Dynamics Blogging community</p> <p> </p> <p>Till later,</p> <p>John</p> <img src="http://geekswithblogs.net/DBA/aggbug/145669.aspx" width="1" height="1" /> DBA http://geekswithblogs.net/DBA/archive/2011/06/01/a-new-blogger-in-town.aspx Wed, 01 Jun 2011 20:29:53 GMT http://geekswithblogs.net/DBA/comments/145669.aspx http://geekswithblogs.net/DBA/archive/2011/06/01/a-new-blogger-in-town.aspx#feedback 1 http://geekswithblogs.net/DBA/comments/commentRss/145669.aspx http://geekswithblogs.net/DBA/services/trackbacks/145669.aspx