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 » Design » SQL Server » DBA   (RSS)
Showing page 2 of 3 (21 total posts)
  • Data Design

    I give series of classes and presentations on Data Design. I say “data” design instead of “database” design because we should consider more than just the database. Data might actually be stored in non-relational stores, such as Excel or XML files, and it might also be located in remote data stores like “cloud” technologies.   Here are the ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 2, 2010
  • FILESTREAM: Storing Binary Objects in a database – or not

    Many shops need to store binary large objects (sometimes called BLOBS) in a database. There are really only two ways to do this: store in them in a table structure in the database itself using a binary data type, or store them in the operating system in a file folder somewhere and point to the file using a text field in a table. Both of these ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 28, 2010
  • Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure. On the other hand I have several systems I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 18, 2010
  • 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
  • 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
  • Aren’t DBA’s Just System Admins for Databases?

    Last week I ran into an argument I’ve had since I left the mainframe space decades ago. A developer told me “DBA’s don’t design databases.” The inference was that DBA’s (i.e., Database Administrators) only worry about hardware, security, OS, database backups, things like that. He seemed amazed that a DBA would ever do “data” work. It may be the ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 30, 2009
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement