InfoQ

News

SQL Server Best Practices Website

Posted by Jonathan Allen on Dec 04, 2006 06:00 AM

Community
.NET
Topics
SQL Server
Tags
Best Practices,
SQL Server 2005

Mark Souza of Microsoft has announced a new web site for database administrators and developers called SQL Server - Best Practices. This site offers a wide range of material from top 10 lists suitable for novices to the in-depth technical white papers needed by seasoned professionals.

Topics include capacity planning, database mirroring, and bulk data loading. Over a dozen scripts for troubleshooting and performance tuning are also available.


7 comments

Reply

Hmmm - "Best practices" by Aslak Hellesøy Posted Dec 4, 2006 7:22 AM
'Microsoft SQL Server', not 'SQL Server' by Thomas Mueller Posted Dec 4, 2006 9:02 AM
Re: 'Microsoft SQL Server', not 'SQL Server' by Charles Cherry Posted Dec 4, 2006 1:18 PM
Re: 'Microsoft SQL Server', not 'SQL Server' by Thomas Mueller Posted Dec 4, 2006 4:02 PM
Re: 'Microsoft SQL Server', not 'SQL Server' by Charles Cherry Posted Dec 5, 2006 12:53 PM
Re: 'Microsoft SQL Server', not 'SQL Server' by Sam Smoot Posted Dec 4, 2006 5:20 PM
Re: 'Microsoft SQL Server', not 'SQL Server' by Charles Cherry Posted Dec 5, 2006 12:49 PM
  1. Back to top

    Hmmm - "Best practices"

    Dec 4, 2006 7:22 AM by Aslak Hellesøy

    Can you do me a favour - please don't allow people to post articles on InfoQ that claim that their practices are "best".

  2. Back to top

    'Microsoft SQL Server', not 'SQL Server'

    Dec 4, 2006 9:02 AM by Thomas Mueller

    Many database engines support 'server' mode, and most support SQL. So the name 'SQL Server' is ambiguous. It could mean Oracle, MySQL, whatever, SQL server. It's not like MS invented 'SQL' or 'Server'. I suggest to rename the article 'MS SQL Server Best Practices'. Thomas

  3. Back to top

    Re: 'Microsoft SQL Server', not 'SQL Server'

    Dec 4, 2006 1:18 PM by Charles Cherry

    Chill out, man. I've been working around databases for years, including Oracle and others, and I've never heard one of them referred to as "SQL Server." As for the "Best Practices" post, maybe you should expand your literary horizons a little bit. At least read about what the phrase "Best Practices" means: http://en.wikipedia.org/wiki/Best_practices or http://www.google.com/search?q=define:Best+practices&sa=X&oi=glossary_definition&ct=title **Sigh** I get so sick of the microsoft bashing.

  4. Back to top

    Re: 'Microsoft SQL Server', not 'SQL Server'

    Dec 4, 2006 4:02 PM by Thomas Mueller

    I don't think this is about Microsoft bashing. Disambiguation: http://en.wikipedia.org/wiki/SQL_Server No, I didn't edit this page ;-)

  5. I doubt Aslak needs to be explained what "Best Practices" means. I'm sure he just feels that implicity validating something by calling it such doesn't serve developer interests. Many of the Microsoft MVP's for example view many of the "Best Practices" as dubious. A big problem in the Microsoft community is getting developers to look past the label and evaluate instead on the actual merits of a guideline or technique. I mention Microsoft because it's a community I'm familiar with. I'm sure the Sun community has similar issues. The Ruby community largely escapes this since I can't recall seeing anything being labeled "best practice", and most of the conversations I can recall that recommend one thing over another also encourage you to judge the merit for yourself. Back to the article though: I really like the "Top 10 Performance..." link. Overall it's pretty high-quality stuff. Nothing sneaky jumped out at me. (ie: Always use Stored Procedures for this, or CLR integration for that.) If you're working with MSSQL it's definitely a worthy read. BTW, even the Rails adapter for MSSQL is called "sqlserver".

  6. Back to top

    Re: 'Microsoft SQL Server', not 'SQL Server'

    Dec 5, 2006 12:49 PM by Charles Cherry

    The reason I thought it smacked of MS bashing was because "Best Practices" is a generic term used by many industries to indicate the tried and true way to do things with a particular tool, process or system. It seemed to me that the poster did not understand this use of the phrase, because he said "please don't allow people to post articles on InfoQ that claim that their practices are 'best'." Many people, myself included, would consider a publisher of a complicated software system remiss in its duty to the consumer if it does not also publish a set of "Best Practices" documents. I could be wrong, but I see so much MS bashing, and much of it sounds just like this guy's post. I guess it just hit a nerve when I first read it.

  7. Back to top

    Re: 'Microsoft SQL Server', not 'SQL Server'

    Dec 5, 2006 12:53 PM by Charles Cherry

    Your point is well taken. However, in all my years of database consulting, for many different companies, I have yet to encounter anyone who has been confused about which database engine I was referring to when I said "SQL Server." Of course, this is just anecdotal evidence and my experince could be unique.

Exclusive Content

Agile and Beyond - The Power of Aspirational Teams

Tim Mackinnon talks about the aspirations behind the Agile principles and practices, the desire to become efficient, to write quality code which does not end up being thrown away.

Concurrency: Past and Present

Brian Goetz discusses the difficulties of creating multithreaded programs correctly, incorrect synchronization, race conditions, deadlock, STM, concurrency, alternatives to threads, Erlang, Scala.

ActionScript 3 for Java Programmers

Often the hardest part of changing technologies is language syntax differences. This new article provides Java developers with a transition guide to Actionscript which forms the foundation of Flex.

Neal Ford On Programming Languages and Platforms

Neal Ford talks about having multiple languages running on one of the two major platforms: Java and .NET. He also presents the advantages offered by Ruby compared to static languages like Java or C#.

Future Directions for Agile

David Anderson talks about the history of Agile, the current status of it and his vision for the future. The role of Agile consists in finding ways to implement its principles.

Nick Sieger on JRuby

Nick Sieger talks about the future of JRuby, Java Integration, and his work on JEE deployment tools for Ruby on Rails like Warbler.

Rustan Leino and Mike Barnett on Spec#

Rustan Leino and Mike Barnett of Microsoft Research discuss the technology in Spec# and its futures.

10 Ways to Screw Up with Scrum and XP

Henrik Kniberg talks about 10 possible reasons to fail while doing Scrum and XP. Maybe the team does not have a definition of what Done means to them, or they don't know what their velocity is.