Monthly Archives: July 2009

Tools for Sql server

Following are the very important tools which Microsoft uses and recommend for troubleshooting and performance improvement…. this will really help you to improve your system…   SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to … Continue reading

Posted in Free Stuff, Tool | Leave a comment

What’s new in Sql server 2000

What’s new in Sql server 2000.   As Sql server is the major release which is improved and enterprise level on performance, reliability, scalability, quality and easy to use…   their was a major change in Engine on Sql server … Continue reading

Posted in Whats New | Leave a comment

Whats new in Microsoft Sql Server 7 – Development

This is third and final part of Whats new in microsoft Sql Server 7: c. Development:     Sql Server 6x Sql Server 7   Development     Remark     English Query       OLE DB   T-Sql … Continue reading

Posted in Whats New | Leave a comment

What’s new in Microsoft Sql Server 7 -Server

This is the second part of what’s new in Microsoft sql server 7, b. Server:     Sql Server 6x Sql Server 7   Server     Remark Backup/restore   online bkp improved.       supports differential bkp and … Continue reading

Posted in Whats New | 3 Comments

What’s new in Microsoft Sql server 7 -Architecture

This is the MAJOR changes/improvement in the storage engine of sql server ……….   Due to too much text I divided this topic in 3 blogs: a. Architecture: b. Server c. Development   a. Architecture :     Sql Server … Continue reading

Posted in Whats New | Leave a comment

History of Microsoft Sql Server

    I was thinking about to make this series from a long time and finally started today… In this series of blog I will try to write following:   1. History of Microsoft Sql Server. 2. What’s new in … Continue reading

Posted in Whats New | Leave a comment

Deadlock.

Deadlock – 1 Before i fergot… just want to share you all the links I search on deadlock today.   Deadlock: Bart Duncan’s SQL Weblog —(Great -must read) http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-2.aspx http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-3.aspx http://blogs.msdn.com/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx http://sqlserver-qa.net/blogs/tools/archive/2009/03/17/interpretaion-of-sql-server-deadlock-and-trace-flag-1204.aspx http://www.sql-server-performance.com/tips/deadlocks_p1.aspx http://www.dalun.com/blogs/10.13.2006.htm Jonathan_kehayias (must Read -Expert on … Continue reading

Posted in What I learned today | Tagged | Leave a comment

reading

Reading Sql Server Internals — Kalen Delaney….    

Posted in Books | Leave a comment