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 » sql server » DBA   (RSS)
Showing page 4 of 6 (51 total posts)
  • The Database Design Process

    I need your help. I know how I create databases, and I’ve watched a lot of other data professionals follow their own processes for that, but I want to know how YOU do it.   I’ve written about the process I follow for a complete database design on InformIT (use the ''Next'' button at the bottom of these to see them all). Beyond starting ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 14, 2010
  • Know Your Product Specifications

    As the Data Professional in your organization, the rest of the org looks to you to ensure that the system can handle what the business requires. To do that, you need to know two things: what the business requires, and what SQL Server can do. But of course there’s a bit more to it than that. Knowing the business side of the requirements – well, I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 13, 2010
  • Plan and Prepare or Just Do It? How about Both!

    I'm kind of a type ''A'' person. OK, I'm a VERY type ''A'' person. I even cook by setting things up ahead of time. I'm definitely more in the ''Plan and Prepare'' camp than the ''Just Do It'' camp. But I do realize that there are times when you just can't stop and prepare. Sure, it would be great to know that server is going to melt down just ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 7, 2010
  • Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running on SQL Server 2000. Now, don’t get me wrong ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 6, 2010
  • Performance Counters? There’s a script for that.

    It’s not hard to get Performance Monitor counters in PowerShell 1.0, and it’s REALLY easy in 2.0. This is one I used yesterday to monitor network bytes in and out on 2.0 (keep all of the green lines in this post on the same line) : get-counter -Counter "\Network Interface(*)\Bytes Total/sec" -SampleInterval 1 -MaxSamples ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 5, 2010
  • SQL Server Chargeback Strategies

    It seems the more things change the more they stay the same. One of the things I used to create on the mainframe system when I started years ago was a “charge-back” system.  It tracked the time and resources used by the employees so that we could charge their department money for the time they spent on the (very expensive) mainframe. When ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 29, 2009
  • It’s Data Tier Application and Data Application Component

    OK – In SQL Server 2008 R2 we did “re-use” an acronym or two (DAC and DTA), but it’s important to remember there are actually two parts to this new feature. One is the Data Application Component (DAC) and the other is the Data Tier Application (DTA). The DAC is the file created for a DTA. In SQL Server 2008R2 and Visual Studio you’ll find there ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 23, 2009
  • The Top 20 Questions in Database Design

    I'm still re-reading the ''Fourth Paradigm'' book by Microsoft Research, and one section continues to intrigues me. There's a part where the book explains database design, and puts forth that the most important thing when you're designing large data sets is to find out the ''Top Twenty Questions'' the database has to answer. The quote is ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 17, 2009
  • The Coming Database Design Wave

    Database design has been on my mind as of late – I’ve been teaching it in class, and I have a friend from Twitter that has a couple of questions. In fact, I think I’ll actually do a submission to PASS this year on this topic.   Don’t think it has to do with you? Well, I’m seeing a new “wave” of design options coming at the data ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 16, 2009
  • Wizards are evil – wait, no they aren’t!

    SQL Server contains many “Wizards. Wizards are simply programs that collect information based on user choices. The Wizard’s screens explain each step and the choices on that screen. Based on those answers collected from the user, the Wizard performs some task. What could possibly be wrong with helping a user this way? Well, plenty. Wizards hide ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 14, 2009
Privacy Statement