Krishna Sonti

Krishna been working as a SQL DBA for over 5 years.

I'm an MCDBA.

Currently working with Surgical Information Systems (as SQL DBA - Team Lead)(an Atlanta, US based company) at Hyderabad, India.


SQLServerCentral Article

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-10-02 (first published: )

47,660 reads

Technical Article

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

134 reads

Blogs

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs

Forums

Dimensional table and Stored Procedure

By yrstruly

To meet these requirements below, I came up with this SQL. Please evaluate my...

Anderson-Darling Calculation

By jackdanny816

Hi   I am following an article posted on sql server central on the...

Use of an NCI - that does not contain the Column required.

By SteveOC

Hello. I am a bit confused and not sure what terms to use to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers