Amit's blog

A SQL Server Professional's blog

SQL Server Snapshot backup and restores - Part 2

In my last blog entry,I gave you some insights on my project objective. Let’s call this project as...

Author: Amit Jethva [MSFT] Date: 03/01/2011

SQL Server Snapshot backup and restores - Part 1

  Recently, I was working with one of my customers to help them design their backup scheme....

Author: Amit Jethva [MSFT] Date: 01/17/2011

sp_what

I have been recently involved with a customer who were running a lot of parallel processes and the...

Author: Amit Jethva [MSFT] Date: 06/28/2010

Convert Comma Separated String to Table : 4 different approaches

Recently, I came across a piece of TSQL code that would take a comma separated string as an input...

Author: Amit Jethva [MSFT] Date: 12/11/2009

SQL Server and SAP !!!

Recently, I started working with some of my customers in India who are running their mission...

Author: Amit Jethva [MSFT] Date: 05/30/2009

SQL Server Standard Edition and Lock Pages in Memory

Have you faced any SQL Server working set trimming problems (Don’t know this? Read Here and...

Author: Amit Jethva [MSFT] Date: 04/27/2009

SQL 2008 Whitepapers

All the whitepapers for Microsoft SQL Server 2008 are available at...

Author: Amit Jethva [MSFT] Date: 04/18/2009

Disk Partitioning Offset

What is this? Following is an excerpt from SQL Server Best Practices Article published on Technet....

Author: Amit Jethva [MSFT] Date: 04/17/2009

SQL Server internals Viewer

  This is a nice tool for someone who needs to see whats inside a 8k SQL Data Page. check it...

Author: Amit Jethva [MSFT] Date: 04/17/2009

Planning to upgrade to SQL Server 2008

If you are planning to upgrade your legacy systems running on SQL Server 2000/2005 to the latest...

Author: Amit Jethva [MSFT] Date: 12/25/2008

Clustering and High Availability : Clustering and HA Resources

A useful set of resources to unleash power of clustering services  ….. Clustering and High...

Author: Amit Jethva [MSFT] Date: 12/19/2008

Microsoft Product Team blogs -

Wow, that’s a long list … and hey, I found so many blogs which I was not aware of....

Author: Amit Jethva [MSFT] Date: 12/16/2008

What’s SQL_PreRelease for SQL Server 2008 RTM software?

  After downloading  & installing SQL Server 2008 RTM,  When you use SQL Server...

Author: Amit Jethva [MSFT] Date: 09/07/2008

SQL Server Community

Technorati Tags: Links,SQL   SQL Server community site: you could find a lot of resources on...

Author: Amit Jethva [MSFT] Date: 08/23/2008

Introduction

Hi Friends,   My name is Amit Jethva. I work for Microsoft India. Microsoft SQL Server &...

Author: Amit Jethva [MSFT] Date: 08/21/2008