THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql server » Administration » Development   (RSS)
  • PowerShell PowerPack Download

    I read Jeffery Hicks’ article in this month’s Redmond Magazine on a new add-in for Windows PowerShell 2.0. It’s called the PowerShell Pack and it has a some great new features that I plan to put into place on my production systems as soon as I finished learning and testing them. You can download the pack here if you have PowerShell 2.0. I’m ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 7, 2010
  • 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 a linked server called called OPENQUERY, another called OPENROWSET, and one called OPENDATASOURCE. ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 16, 2010
  • Lessons from Volunteering

    Saturday I volunteered at a work-day at our church. Our building is one of the first buildings built in this area of Washington, so it’s a beautiful old structure, which of course means there’s lots of maintenance. I’m fairly decent with tools, I’ve done some woodworking in my day, and I’ve even rebuilt a car or two. But working on a structure ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 23, 2010
  • 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 there’s a bit more to it than that. Knowing the business side of the requirements – well, I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 13, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement