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 » Tips » Administration » Design » SQL Server   (RSS)
  • Cluster Nodes as RAID Drives

    I'm unable to sleep tonight so I thought I would push this post out VERY early. When you don't sleep your mind takes interesting turns, which can be a good thing. I was watching a briefing today by a couple of friends as they were talking about various ways to arrange a Windows Server Cluster for SQL Server. I often see an ''active'' node ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 25, 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement