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
SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial
SQL SERVER 2008 RTM has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier. I had previously written the same article earlier. It seemed necessary to re post it again as request of me posting Step by Step tutorial has increased for quite some time.
SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
In these times of economical slowdown, more and more IT professionals are concerned about their jobs and their qualifications. It is a common trend for developers to start looking for ways to update their skills when jobs are not secure. Pure knowledge and real world work experience are always a…
Read More