Microsoft SQL Server 2008 has hundreds of new and improved features, many of which are specifically designed for large scale independent software vendor (ISV) applications, which need to leverage the power of the underlying database while keeping their code database agnostic. This article presents details of the top 10 features that we believe are most applicable to such applications based on our work with strategic ISV partners. Along with the description of each feature, the main pain-points the feature helps resolve and some of the important limitations that need to be considered are also presented.
SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle
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…
Read More
SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table
Recently I have been busy with interviewing many candidates for my organization. We are looking for some smart and experienced developers for some senior positions. I have wrote this previously SQL SERVER – Interesting Interview Questions. This blog post is about finding a table row count without using T-SQL.
SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
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…
Read MoreSQLAuthority News – Author Photographs Updated
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)
Read More
SQL SERVER – Interview Questions – Difficult SQL Puzzle
Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.
SQLAuthority News – 10 Motivational Quotes from Technologiest of the Past
Once in a while it is a good idea to read what the greatest technologies of the past said about their time as well as the future. This is the running list of the motivational quotes which I have liked so far from various technologies. Please feel free to add yours as well.
One machine can do the work of fifty ordinary men. No machine can do the work of one extraordinary man.
– Elbert Hubbard
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
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…
Read MoreSQL SERVER – Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals / Developers
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…
Read MoreSQL SERVER – Default Collation of SQL Server 2008
Recently I wrote article about SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial, I received couple of comment suggesting that I did not talk about SQL Server default collation setting or how to change default collation when installing…
Read More