Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen

July 24, 2009

I had a great, unforgettable time at Teched India 2009 in Hyderabad. I had delivered a successful session on SQL Server Management Studio Best Practices, which created a lot of interest in community. I was truly amazed at the tremendous response I got. I received countless different questions on this…

SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key

July 23, 2009

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

In one of my recent projects, a large database migration project, I confronted a peculiar situation. SQL Server tables were already moved from Database_Old to Database_New. However, all the Primary Key and Foreign Keys were yet to be moved from the old server to the new server. Please note that…

SQLAuthority News – SQL Server Value Calculator

July 22, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Utility

I have been using twitter for quite some time now (follow me at @pinaldave). In twitter world very often I find something interesting shared by my friends there. SQL Server Expert and Microsoft Evanglist Vinod Kumar has twitted very interesting detail linking to SQL Server Value Calculator. The web version…

SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing

July 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Cloud Computing, SQL Azure

Microsoft has updated the branding for SQL Services and SQL Data Services. SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database. Changing the name does not change product but it demonstrates tight integration between the components of the service platforms. As…

SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009

July 20, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQLBuzzDelhi organized TechEd Delhi on July 11, 2009. They even launched an official PASS Chapter in Delhi. The complete report of this event is here. This event like TechEd in Ahmedabad, was a huge success and saw a huge number of attendees from all over India. Jacob Sebastian and Pinal…

SQL SERVER – Get Last Running Query Based on SPID

July 19, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server DBCC, SQL System Table

We often need to find the last running query or based on SPID need to know which query was executed. SPID is returns sessions ID of the current user process. The acronym SPID comes from the name of its earlier version, Server Process ID. To know which sessions are running…

SQLAuthority News – Whitepaper – Using the Resource Governor

July 18, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Download, SQL White Papers

Using the Resource Governor SQL Server Technical Article Writer: Aaron Bertrand, Boris Baryshnikov Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe Published: June 2009 SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads…