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 » Design   (RSS)
Showing page 1 of 3 (29 total posts)
  • How Does the Cloud Change a Database Administrator’s Job?

    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization. In a way, the Systems Architect has the easiest transition to a new way of using computing technologies. In fact, that’s actually part of the job description. I mentioned that a Systems Architect has three primary ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 29, 2013
  • Normalization and How to Know When You Are Done… The short version…

    A while back, I was working on a short article about Normalization for a book that never got published (admittedly I wasn’t getting paid for the article, and it wasn’t for charity, so I wasn’t that broken up over it.)  The task at hand was to, in 2 pages or less, describe the process of normalization and help you to know when you have ...
    Posted to Louis Davidson (Weblog) by drsql on May 29, 2011
  • SQL Azure Use Case: Shared Storage Application

    This is one in a series of posts on when and where to use a distributed architecture design in your organization's computing needs. You can find the main post here: http://blogs.msdn.com/b/buckwoody/archive/2011/01/18/windows-azure-and-sql-azure-use-cases.aspx Description: On-premise data will be a part of computing for quite some time – ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 26, 2011
  • Designing Dashboards

    Not all data professionals get into the ''front end'' of the applications that hit their data. But most of us end up having to do a ''dashboard'' of information, even if it's a dashboard of our system information and performance tracking. I do this quite often for myself and for other folks, and I wanted to share a resource I use for that. It's ...
    Posted to Buck Woody (Weblog) by BuckWoody on July 14, 2010
  • More Tables or More Databases?

    I got an e-mail from someone that has an interesting situation. He has 15,000 customers, and he asks if he should have a database for their data per customer. Without a LOT more data it’s impossible to say, of course, but there are some general concepts to keep in mind. Whenever you’re segmenting data, it’s all about boundary choices. You have ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 19, 2010
  • Use Those Schemas, People!

    Database Schemas are just containers – they aren’t users or anything else – think of a sub-directory on the hard drive. In early versions of SQL Server we “hid” schemas, placing all objects under “dbo”, which gave the erroneous perception that Schemas are users. In SQL Server 2005, we “un-hid” or re-introduced schemas within the database. Users ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 18, 2010
  • Do you have a data roadmap?

    I often visit companies where they asked me “What is SQL Server’s Roadmap?” What they mean is that they want to know where Microsoft is going with our database products. I explain that we’re expanding not only the capacities in SQL Server but the capabilities – we’re trying to make an “information platform”, rather than just a data store. But ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 13, 2010
  • Do you need all that data?

    I read an amazing post over on ars technica (link: http://arstechnica.com/science/news/2010/03/the-software-brains-behind-the-particle-colliders.ars?utm_source=rss&utm_medium=rss&utm_campaign=rss) abvout the LHC, or as they are also known, the ''particle colliders''. Beyond just the pure scientific geek awesomeness, these instruments ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 13, 2010
  • Backup Meta-Data

    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and modified it to this T-SQL Script. A few words here - you need ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 30, 2010
  • Cluster Nodes as RAID Drives

    I'm unable to sleep tonight so I thought I would push this post out VERY early. When you don't sleep your mind takes interesting turns, which can be a good thing. I was watching a briefing today by a couple of friends as they were talking about various ways to arrange a Windows Server Cluster for SQL Server. I often see an ''active'' node ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 25, 2010
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement