Browse by Tags

• Administration
• Agent
• Application Architecture
• Azure
• Best Practices
• Cloud
• Cloud Computing
• Concepts
• DBA
• Development
• Documentation
• Downloads
• How I work
• Learning
• Link Lists
• Links
• Management
• Microsoft
• MSDN
• Planning
• PowerShell
• Presentations
• Process
• Scripts
• SQL Azure
• SQL Server
• SQL Server Management Studio
• SSMS
• System Center Operations Manager
• Technet
• T-SQL
• Tutorials
• Virtualization
• Walkthroughs
• Web
• Windows Azure

• Windows Azure End to End Examples

  I’m fascinated by the way people learn. I’m told there are several methods people use to understand new information, from reading to watching, from experiencing to exploring. Personally, I use multiple methods of learning when I encounter a new topic, Read More... Posted Tuesday, May 29, 2012 7:45 AM by BuckWoody | 0 Comments Filed under: Azure, Cloud, Cloud Computing, Concepts, Design, Developer, Development, Documentation, Downloads, How I work, Learning, Link Lists, Links, MSDN, Planning, Presentations, SQL Azure, Technet, Tips, Tutorials, Walkthroughs, Web, Windows Azure

• Application Lifecycle Management Overview for Windows Azure

  Developing in Windows Azure is at once not that much different from what you’re familiar with in on-premises systems, and different in significant ways. Because of these differences, developers often ask about the specific process to develop and deploy Read More... Posted Tuesday, February 07, 2012 7:58 AM by BuckWoody | 0 Comments Filed under: Application Architecture, Azure, Best Practices, Cloud, Cloud Computing, Concepts, Design, Developer, Development, Links, Planning, Process, System Center Operations Manager, Tips, Windows Azure

• 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

• 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: Agent, DBA, Design, Developer, Development, Management, Microsoft, Planning, PowerShell, Process, Scripts, SQL Server, SQL Server Management Studio, SSMS, Tips, Web

• 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 Read More... Posted Wednesday, November 25, 2009 7:01 AM by BuckWoody | 5 Comments Filed under: DBA, Design, Developer, Development, Scripts, SQL Server, SQL Server Management Studio, SSMS, Tips, T-SQL, Tutorials, Virtualization, Web

• 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: DBA, Design, Developer, Development, Microsoft, SQL Server, SSMS, Tips