DBA Archives - Page 3 of 21 - SQL Authority with Pinal Dave

SQL SERVER – Brief Note about StreamInsight – What is StreamInsight

February 9, 2010

StreamInsight is a new event processing platform introduced in upcoming version SQL Server 2008 R2. Similar to other components such as SSIS, SSAS or Service Broker, it also needs to be installed along with the SQL Server. Up to SQL Server 2005, Microsoft’s main focus on SQL Server was to…

SQLAuthority News – 1200th Post – An Important Milestone

December 31, 2009

Pinal Dave

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

Database, DBA, MVP

Today is the last day of 2009 and this is my 1200th post! This year had been a wonderful year for me. I was actively involved with the community, and there were a lot of occasions where I could work along with IT professionals to resolve their issues in projects.…

SQLAuthority News – Meeting SQL Expert Imran at Hyderabad

December 22, 2009

Pinal Dave

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

Database, DBA

I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed. Imran has been very active on this blog and have previously contributed with few articles as well. I have been communicating with Imran for a long time; he is…

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

December 18, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download

In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…

SQLAuthority News – SQL Server 2008 for Oracle DBA

November 21, 2009

Pinal Dave

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

Database, DBA, MySQL, Oracle

This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server 2008 system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of…

SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

November 16, 2009

Pinal Dave

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

Database, DBA, MVP, SQL PASS

Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here…

SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario

August 11, 2009

Pinal Dave

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

Database, DBA, SQL Constraint and Keys, SQL Index

About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided…