Browse by Tags

• Administration
• Agent
• Application Architecture
• Azure
• Best Practices
• Career
• Cloud
• Cloud Computing
• Computing
• Concepts
• Conferences
• Data
• Data Professional
• Database Administration
• DBA
• Developer
• Development
• Disaster Recovery
• Latest Version
• Learning Plan
• Link Lists
• Links
• Maintenance
• Maintenance Plans
• Management
• Metadata
• Microsoft
• Microsoft Update
• Planning
• Platform Independence
• PowerShell
• Process
• Rant
• Scripts
• SQL Azure
• SQL Server 2008
• SQL Server Management Studio
• SSIS
• SSMS
• Standard Reports
• Tips
• T-SQL
• Tutorials
• Virtualization
• Web
• Windows Azure

• 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 Read More... Posted Tuesday, January 29, 2013 8:08 AM by BuckWoody | 0 Comments Filed under: Application Architecture, Azure, Career, Cloud Computing, Computing, Concepts, Data, Database Administration, DBA, Design, SQL Azure, SQL Server, Windows Azure

• 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 Read More... Posted Tuesday, April 26, 2011 7:33 AM by BuckWoody | 0 Comments Filed under: Azure, Cloud, Cloud Computing, Concepts, Data, Data Professional, Design, Developer, Disaster Recovery, Learning Plan, Platform Independence, SQL Azure, SQL Server, SSIS, Windows Azure

• 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 Read More... Posted Wednesday, July 14, 2010 8:44 AM by BuckWoody | 1 Comments Filed under: Design, Links, SQL Server

• 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 Read More... Posted Wednesday, May 19, 2010 5:37 AM by BuckWoody | 2 Comments Filed under: DBA, Design, Developer, SQL Server

• 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 Read More... Posted Tuesday, May 18, 2010 6:39 AM by BuckWoody | 6 Comments Filed under: Best Practices, DBA, Design, Developer, SQL Server

• 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 Read More... Posted Thursday, May 13, 2010 6:16 AM by BuckWoody | 0 Comments Filed under: Career, DBA, Design, Microsoft, SQL Server

• 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 Read More... Posted Tuesday, April 13, 2010 6:24 AM by BuckWoody | 0 Comments Filed under: Design, Latest Version, Planning, SQL Server

• 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 Read More... Posted Tuesday, March 30, 2010 8:46 AM by BuckWoody | 3 Comments Filed under: Administration, DBA, Design, Maintenance, Maintenance Plans, Metadata, Scripts, SQL Server, SQL Server Management Studio, Standard Reports, T-SQL

• 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 Read More... Posted Wednesday, March 24, 2010 11:56 PM by BuckWoody | 1 Comments Filed under: Administration, Computing, Design, Disaster Recovery, SQL Server, Tips

• Today I talk about you

  Some time back I posted a blog entry (mirrored here and here ) asking you how you design databases. Out of those responses, my own experience, studies I read, and interviews I conducted, I collected a wealth of data. Thanks for your responses. So what Read More... Posted Wednesday, March 24, 2010 7:12 AM by BuckWoody | 0 Comments Filed under: Conferences, DBA, Design, SQL Server

• Great Example of a Simple Cost-Benefit Analysis

  I saw a post the other day that you should definitely go check out. It’s a cost/benefit decision, and although the author gives it a quick treatment and doesn’t take all points in the decision into account, you should focus on the process he follows. Read More... Posted Monday, March 22, 2010 7:07 AM by BuckWoody | 1 Comments Filed under: DBA, Design, SQL Server

• Using linked servers, OPENROWSET and OPENQUERY

  SQL Server has a few mechanisms to reach out to another server (even another server type) and query data from within a Transact-SQL statement. Among them are a set of stored credentials and information (called a Linked Server ), a statement that uses Read More... Posted Tuesday, March 16, 2010 6:41 AM by BuckWoody | 5 Comments Filed under: Administration, Design, Developer, Development, Planning, SQL Server, Tips

• Create Outlook Appointments from PowerShell

  I've been toying around with a script to create a special set of calendar objects in Outlook that show when my SQL Server Agent Jobs are scheduled to run. I haven't finished yet, but I thought I would share the part that creates the Outlook Appointments.I Read More... Posted Wednesday, March 10, 2010 8:33 AM by BuckWoody | 1 Comments Filed under: Administration, Design, PowerShell, SQL Server

• It’s OK to take a Shortcut Sometimes

  I was working this weekend with a fairly simple Excel spreadsheet, and I had to decompose one cell in it out to three columns in a SQL Server table. There are tools within SQL Server Integration Services (SSIS) that should be able to do that, but I just Read More... Posted Monday, March 08, 2010 7:06 AM by BuckWoody | 0 Comments Filed under: DBA, Design, Developer, Development, SQL Server

• Code that Writes Code - A Good Idea or Not?

  I’m a big fan of code that writes code – most of the time. For instance, whenever you use the “templates” feature in SQL Server Management Studio (SSMS) or the Maintenance Wizard, you’re using code that writes other code. There’s even a trick of writing Read More... Posted Tuesday, February 16, 2010 7:14 AM by BuckWoody | 4 Comments Filed under: DBA, Design, Developer, Development, Rant, SQL Server