Browse by Tags

• Administration
• Agent
• Best Practices
• Career
• Computing
• Developer
• Development
• Link Lists
• Management
• Microsoft Update
• Planning
• PowerShell
• Process
• Rant
• Scripts
• SQL Azure
• SQL Server
• SQL Server 2008
• SQL Server Management Studio
• SSMS
• Tips
• Web

• 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: Microsoft, DBA, Design, SQL Server, Career

• How Does Microsoft Do IT?

  Microsoft is a big company – and of course we have a lot of IT infrastructure that we have to manage. It might surprise you to learn that we have an IT group, just like at your company. We have a networking team, a server hardware team, software teams, Read More... Posted Wednesday, February 03, 2010 7:17 AM by BuckWoody | 0 Comments Filed under: Microsoft, DBA, Design, SQL Server, Administration, Best Practices, Management, Computing

• 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 Read More... Posted Monday, January 18, 2010 7:42 AM by BuckWoody | 0 Comments Filed under: Development, SSMS, Developer, Tips, Microsoft, DBA, Design, SQL Server, SQL Server Management Studio, Scripts, Web, Planning, PowerShell, Process, Agent, Management

• 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 Read More... Posted Wednesday, January 13, 2010 7:57 AM by BuckWoody | 1 Comments Filed under: Development, Developer, Microsoft, DBA, Design, SQL Server, Administration, SQL Server 2008, Career, Planning, SQL Azure, Microsoft Update, Link Lists

• 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 Read More... Posted Monday, November 30, 2009 9:37 AM by BuckWoody | 8 Comments Filed under: Development, Developer, Microsoft, DBA, Design, SQL Server, Rant

• Changing the Primary Key After You Have Data

  Yesterday I blogged about changing a Primary Key (PK) during the design phase, and before you have data in the database. Even then, it’s not trivial to change the data type or column(s) that make(s) up the PK. When you have data in that Primary Key and/or Read More... Posted Tuesday, November 24, 2009 6:25 AM by BuckWoody | 0 Comments Filed under: Development, SSMS, Developer, Tips, Microsoft, DBA, Design, SQL Server