Browse by Tags

• Administration
• Agent
• Career
• Certifications
• DBA
• Design
• Developer
• Development
• Management
• Microsoft
• PowerShell
• Process
• Scripts
• SQL Server Management Studio
• SSMS
• Tutorials
• Web

• Challenge: Learn One New Thing Today

  Most of us know that there's a lot to learn. I'm teaching a class this morning, and even on the subject where I'm the "expert" (that word always makes me nervous!) I still have a lot to learn. To learn, sometimes I take a class, read a book, or carve Read More... Posted Wednesday, March 17, 2010 7:07 AM by BuckWoody | 9 Comments Filed under: Career, Certifications, Planning, SQL Server, Tips, Tutorials

• 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

• Plans are useless. Planning is essential!

  I do lot of cooking, and I was taught to prepare everything ahead of time, and put everything in its place – something called “Mise en Place”. I chop everything and put it in little bowls, measure out the spices, lay out all of the pots and pans and so Read More... Posted Wednesday, December 02, 2009 8:12 AM by BuckWoody | 4 Comments Filed under: Career, Planning, SQL Server, Tips