Krishna Sonti

An Introduction To Linked Servers

Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.

3.14 (7)

2007-06-08 (first published: )

47,260 reads

ScriptToFindWhichTablesBelongToWhichFileGroups

If we give SP_HELP , we'll know to which File Group the table belongs.If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group. But have you ever tried that, given a file group, how to find all the tables that belong […]

2004-05-10

131 reads

Blogs

Running SQL Server containers as non-root

By

Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...

Interview with Greg Low

By

This is the sixth interview we have done. This time our guest is Greg...

Azure SQL Database Types

By

I want to do a quick summary post of the many different types of...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Database in Recovery Pending state

By bobba

Good Morning, We had an issue yesterday where SQL Alerts were generated from one...

Import data from Kafka

By christian_t

Hi there, I am looking for a way to import kafka event data into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers