THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices   (RSS)
Showing page 11 of 11 (108 total posts)
  • Upcoming Top 10 Data Modeling Mistakes Webcast

    Hi Everyone, I'm delivering the first follow-on presentation to my popular ''Top 10 Mistakes on SQL Server''.  This follow-on presentation focuses on the multitude of common mistakes I've encountered on database designs and during data modeling.  Here are the details:  Title: Avoiding Data Modeling Mistakes in SQL Server ...
    Posted to Kevin Kline (Weblog) by KKline on June 5, 2007
  • Can you trust your constraints?

    SQL Server allows you to temporarily disable your CHECK and FOREIGN KEY constraints. I would not recommend this as part of your regular production schedule, but there are certainly cases where this comes in handy.   One example is if you’re copying thousands of rows from another table, and you already know with 100% certainty that the data ...
  • Support Insights

    SQL Server Central columnist Steve Jones posted an interesting interview with Bob Dorr, a senior support escalation engineer with the Microsoft SQL Server support team.  You really should take a few minutes to read the article because it's worth your time.  I'm going to quickly recap a couple things I found most interesting.  Of ...
    Posted to Kevin Kline (Weblog) by KKline on March 8, 2007
  • Webcasts on-line

    As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks.  Of course, I'm happy to share those, but I've got one better for you.  As it turns out, you can find five of my most recent webcasts here.  These are recorded webcasts that you can listen to any time.  I believe that ...
    Posted to Kevin Kline (Weblog) by KKline on February 8, 2007
  • Speaking in Tel Aviv

    I recently had the pleasure of presenting to a packed house in Tel Aviv (described in http://www.pc.co.il/Index.asp?CategoryID=72).  Warning: The website is in Hebrew.  The weather was a gorgeous 70-something and sunny.  Ahhh - the Mediterranean climate of Israel is especially nice to visit in midwinter when it's 20 degrees ...
    Posted to Kevin Kline (Weblog) by KKline on February 4, 2007
  • How to Best Synchronize a Reporting Server

    Have you ever had to build a reporting system where you wanted to off-load the reporting function from the main production server?  It's a problem that can be solved with a variety of methods, for example:- Database Mirroring: Works very nicely in an asynchronous environment but has the downside of only duplicating the data to a single server ...
    Posted to Kevin Kline (Weblog) by KKline on December 18, 2006
  • Consuming Data from the PerfMon Counters

    SQL Server MVP Kent Tegels recently raise an interesting question. SQL Server publishes a number of performance counters. In the code he's written that publishes performance counter data, he's had to explictly code the counter updates within his code regardless of knowing if any processes were consuming those ...
    Posted to Kevin Kline (Weblog) by KKline on December 15, 2006
  • Data correctness during the development process

    During all phases of development, particularly when building a completely new system, it is very common to have a need for data to test with.  As important as this is for a UI system, the need is doubled is when you are working on a reporting system.  While Everyone knows that the process of getting test data can be a fickle ...
    Posted to Louis Davidson (Weblog) by drsql on October 9, 2006
« First ... < Previous 7 8 9 10 11
Privacy Statement