SQL Tips and Tricks Archives - Page 436 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution

December 11, 2008

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who…

SQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download

December 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

Note: SQL SERVER 2008 Upgrade Technical Reference Guide Download by Microsoft This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended…

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle

December 10, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

In the recent time of recession my company is able to continue its progress and we are hiring. It is very surprising to me that many developers who have experience with SQL Server could not get following simple question right. There were nearly 40 candidates I interviewed but none of…

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

December 8, 2008

Pinal Dave

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

Database, SQL Download

Note: Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…

SQLAuthority News – Author Photographs Updated

December 8, 2008

Pinal Dave

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

MVP, SQL User Group

I have received many emails about one of page in on personal site – Photos. I have updated all but one photo on my photo web page. There are new photos of my User Group Presentation and MVP activities. Visit my new photos page Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

December 5, 2008

Pinal Dave

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

Best Practices, Data Warehousing, Database, DBA, MVP, Openday, SQL Backup and Restore, SQL Download, SQL Scripts, SQL User Group, SQLAuthority Author Visit

Ahmedabad SQL Server User Group Meeting was organized on November 29, 2008 at famous C.G. Road in Ahmedabad. We had great response and wonderful back to back technical sessions. The highlight of whole meeting was participation of UG President Jacob Sebastian – SQL MVP from New York. Meeting started with…

SQL SERVER – Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals / Developers

December 4, 2008

Pinal Dave

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

Database, SQL Download

Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions. SQL Server 2008 is a trusted, productive, and intelligent data platform…