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,632 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

Why You Need Presentation Skills

By

And no, the answer is not because you want to be a Microsoft MVP....

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Read the latest Blogs

Forums

Pay close attention to little details

By johnjonston

It is crucial for Wikipedia contributors to decide what they will cover in their...

Easy Guide on How to Fix QuickBooks Error 15271

By rimssen

Error code 15271in QuickBooks is common error of the 15x series. A QuickBooks Error...

TCP Provider: A connection attempt failed for target server

By SQL Galaxy

Hi. In source SQL Instance target linked server has been created and connection tested...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers