Database Archives - Page 39 of 55 - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Important Resources

April 13, 2008

In one of the recent public speaking event I was asked if I can list some important resources of SQL Server 2008. I promised that I will post the links on my blog. Here are Important Resources for SQL Server 2008. Learn more about data programmability http://www.microsoft.com/sql/2008/technologies/dataprogrammability.mspx Learn more about…

SQL Server – Good Articles on Database Collation

April 4, 2008

Pinal Dave

SQL

Database, DBA, SQL Collation, SQL Server

I often get asked what is Database Collation in SQL Server and if there are some good articles related to Collation. Here are some articles.

SQLAuthority News – Learn New Things – Self Criticism

April 3, 2008

Pinal Dave

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

Best Practices, Database, Software Development

I came across two interesting web pages and I really thought they had very good articles. I would like to share that with my blog readers today. I am just listing the abstract here. Please read the original articles they are much more interesting and enjoyable. Readers if you find…

SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download

April 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Utility

The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details,…

SQL SERVER – Popular Articles of SQLAuthority Blog

March 31, 2008

Pinal Dave

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

Database, SQL Download

I receive this email quite often that which are most popular articles on my blog. There is already list on right navigation bar of my weekly popular article. If you are interested to know which are most popular articles as per readers and my opinion here are two listed. SQL…

SQLAuthority News – Few Links About SQLAuthority

March 26, 2008

Pinal Dave

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

Database, DBA, Software Development, SQL Jobs

I have listed few important links of SQLAuthority.com, I still receive some repeated questions. I do my best to respond to all of my readers, however, most of the time I am sending them link to one of my previously written article. Many times most of the answers can be…

SQL SERVER – Simple Puzzle Using Union and Union All – Answer

March 25, 2008

Pinal Dave

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

Database, SQL Joins, SQL Scripts

Yesterday I posted a puzzle SQL SERVER – Simple Puzzle Using Union and Union All, today we will see the answer of this. Following image explains the answer of puzzle. You can read the explanation of why this is answer read my previous article SQL SERVER – Union vs. Union…