SQL Archives - Page 394 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Value Calculator

July 22, 2009

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

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…

SQL SERVER – Four Different Ways to Find Recovery Model for Database

July 16, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Perhaps, the best thing about technical domain is that most of the things can be executed in more than one ways. It is always useful to know about the various methods of performing a single task. Today, we will observe four different ways to find out recovery model for any…

SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage

July 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage

When it comes to storing images in database there are two common methods. I had previously blogged about the same subject on my visit to Toronto. With SQL Server 2008, we have a new method of FILESTREAM storage. However, the answer on when to use FILESTREAM and when to use…