Browse by Tags

• Administration
• Agent
• Application Architecture
• Azure
• Azure Use Cases
• Best Practices
• Big Data
• Book Review
• BPA
• Business Intelligence
• Career
• Certifications
• Checklists
• Cloud
• Cloud Computing
• Community
• Computing
• Concepts
• Conferences
• Customer Contact
• Data
• Data Professional
• Data Science
• Database Administration
• DBA
• Design
• Developer
• Development
• Disaster Recovery
• Documentation
• Downloads
• Error Codes
• Feedback
• HCI
• Help
• Indexes
• Installation and Upgrade
• Latest Version
• Learning
• Learning Plan
• Link Lists
• Links
• Maintenance
• Maintenance Plans
• Management
• Memory
• Metadata
• Microsoft
• Microsoft Update
• Monitoring
• PASS
• PBM
• Performance
• Performance Tuning
• Personal
• Planning
• Platform Independence
• Policy Based Management
• PowerShell
• Process
• Questions
• Rant
• Real World DBA
• Schemas
• Scripts
• Security
• SQL Azure
• SQL Server 2000
• SQL Server 2008
• SQL Server Management Studio
• SQLServer
• SSIS
• SSMS
• Standard Reports
• Storage
• Support
• Testing
• Tips
• Troubleshooting
• T-SQL
• Tutorials
• Upgrades
• Use-Cases
• Virtualization
• Walkthroughs
• 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: DBA, Design, SQL Server, Career, SQL Azure, Computing, Data, Azure, Windows Azure, Cloud Computing, Application Architecture, Concepts, Database Administration

• Microsoft Windows Azure Disaster Recovery Options for On-Premises SQL Server

  One of the use-cases for a cloud solution is to serve as a Disaster Recovery option for your on-premises servers. I’ll explain one particular use-case in this entry, specifically using Windows Azure “IaaS” or Virtual Machines as a Recovery Read More... Posted Tuesday, January 08, 2013 7:40 AM by BuckWoody | 2 Comments Filed under: SQL Server, Disaster Recovery, SQL Azure, Windows Azure, Cloud Computing, Use-Cases

• Using Hadooop (HDInsight) with Microsoft - Two (OK, Three) Options

  Microsoft has many tools for “Big Data”. In fact, you need many tools – there’s no product called “Big Data Solution” in a shrink-wrapped box – if you find one, you probably shouldn’t buy it. It’s Read More... Posted Tuesday, December 04, 2012 8:28 AM by BuckWoody | 2 Comments Filed under: SQL Server, Windows Azure, Data Science, Big Data

• A SQL Saturday in Cambridge – Buck Woody’s Ragtime Database Workshop

  The SQL Server community is really engaged. They are an active bunch on Twitter, Facebook and LinkedIn, they help each other on forums, they attend conferences. But that isn’t enough interaction – the community started a grass-roots effort Read More... Posted Monday, July 30, 2012 2:49 PM by BuckWoody | 0 Comments Filed under: Developer, DBA, SQL Server, Career, Conferences, Customer Contact, SQLServer, Data Professional, Community, Real World DBA

• The Data Scientist

  A new term - well, perhaps not that new - has come up and I’m actually very excited about it. The term is Data Scientist, and since it’s new, it’s fairly undefined. I’ll explain what I think it means, and why I’m excited about it. In general, I’ve found Read More... Posted Tuesday, November 15, 2011 8:00 AM by BuckWoody | 1 Comments Filed under: Developer, DBA, SQL Server, Career, SQL Azure, Data, Data Professional, Azure, Windows Azure, Concepts, Business Intelligence

• Big Data and the Cloud - More Hype or a Real Workload?

  Last week Microsoft announced several new offerings for “Big Data” - and since I’m a stickler for definitions, I wanted to make sure I understood what that really means. What is “Big Data”? What size hard drive is that? After all, my laptop has 1TB of Read More... Posted Tuesday, October 18, 2011 7:57 AM by BuckWoody | 0 Comments Filed under: Developer, Microsoft, DBA, SQL Server, Career, SQL Azure, Conferences, PASS, SQLServer, Data, Data Professional, Cloud, Azure, Windows Azure, Cloud Computing, Storage, Concepts, Azure Use Cases, Policy Based Management

• 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: Developer, Design, SQL Server, Disaster Recovery, SQL Azure, Data, Data Professional, Cloud, Azure, Windows Azure, Platform Independence, Cloud Computing, Concepts, Learning Plan, SSIS

• Databases are the longest-lived component

  Most of you know that I write a technical article each week for the InformIT website - you can see a list of all my articles here . I’ve been writing for that site for – well, a really long time. I have articles all the way back to SQL Server Read More... Posted Thursday, September 09, 2010 7:39 AM by BuckWoody | 3 Comments Filed under: SQL Server

• SQL Server 101: Back to Basics at SQL Bits

  I’m traveling to the United Kingdom (York, England, to be specific) in September, joining Brent Ozar, Brad McGehee, Kevin Kline, Simon Sabin – and a host of other top-notch speakers. They will be covering deep technical topics ranging from Read More... Posted Tuesday, September 07, 2010 6:47 AM by BuckWoody | 2 Comments Filed under: SQL Server, Conferences

• Dealing with Data: Defining the Components to Tune

  I've been reading a fascinating article about the Large Hadron Collider, or LHC facility. It's a scientific research facility that houses a particle collider, which generates an incredible amount of data. Their original plan was to stream the data to Read More... Posted Thursday, September 02, 2010 6:21 AM by BuckWoody | 0 Comments Filed under: SQL Server, Data

• The New World of Work: Hyper-Connectivity and Work/Life Blur

  In my last couple of posts I’ve mentioned a new world of work environment put forth by the Gartner Group’s Tom Austin, with a few additions from my own perceptions. I’ve mentioned “swarming” and that we deal with more unique Read More... Posted Tuesday, August 31, 2010 6:09 AM by BuckWoody | 1 Comments Filed under: SQL Server, Career

• The New World of Work: Unique Tasks

  In a previous post I mentioned that I’ve seen some Gartner Inc. studies, among others, that state that we’re in a “new world of work”. Since I’ve been working in technology for quite some time, and working around the world Read More... Posted Thursday, August 26, 2010 5:26 AM by BuckWoody | 5 Comments Filed under: SQL Server, Career, Cloud

• The New World of Work: Swarms

  I’ve been reading some excerpts from Gartner, Inc. and information from others on the changes they are seeing in the workplace. It’s holding true where I work and in the workplaces of the other data professionals I work with. One of those Read More... Posted Tuesday, August 24, 2010 5:11 AM by BuckWoody | 1 Comments Filed under: SQL Server, Career, Data Professional

• Direct Contact with SQL Server's Future

  Many times I'm asked "does Microsoft ever ask the users what they want in SQL Server"? Yes, we do. A lot, actually. And you can be a part of that conversation. For starters, you can hit the http://connect.microsoft.com site, read up on how it works, and Read More... Posted Tuesday, August 17, 2010 5:54 AM by BuckWoody | 3 Comments Filed under: SQL Server, Feedback, HCI

• Watch those clustered indexes

  I had a discussion with a friend in Microsoft IT this morning, and as we were evaluating some query plans we ran into more clustered index woes. Remember that clustered indexes affect the base table itself (which is why there can be only one) and are Read More... Posted Wednesday, August 11, 2010 10:27 AM by BuckWoody | 0 Comments Filed under: SQL Server, Performance, Indexes