Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – White Paper: SQL Server 2008 Compared to Oracle Database 11g

June 19, 2008

Database, Oracle, SQL Download, SQL Server, SQL White Papers

Note: Download White Paper by Microsoft

Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.

SQLAuthority News – Famous Quotes From Bill Gates

June 18, 2008

Pinal Dave

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

Database, SQL Humor

Bill Gates Quotes – “Success is a lousy teacher. It seduces smart people into thinking they can’t lose.” “Until we’re educating every kid in a fantastic way, until every inner city is cleaned up, there is no shortage of things to do.” “If I’d had some set idea of a…

SQL SERVER – 2008 – SQL Server Start Time

June 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I have been playing with SQL Server 2008 recently. There are many new features which SQL Server 2008 have. One of the interesting addition to SQL Server 2008 is system table field which records when SQL Server was started. This field has data type as datetime that is why it…

SQL SERVER – Introduction to SERVERPROPERTY and example

June 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name etc. Run following script to see all the properties of server. SELECT 'BuildClrVersion' ColumnName, SERVERPROPERTY('BuildClrVersion') ColumnValue UNION ALL SELECT 'Collation', SERVERPROPERTY('Collation') UNION…

SQL SERVER – 2008 – Inline Variable Assignment

June 15, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable. ---- SQL Server 2005 Way…

SQLAuthority News – 600 Article and Over 3 Million Readers

June 14, 2008

Pinal Dave

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

Database, DBA

Today is 600th article on this blog and so far over 3 Million readers have visited this blog. Popularity of this blog is increating everyday due to active participation from some good readers. When people share their ideas and their opinion whole world becomes better place. I encourage all of…

SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server

June 13, 2008

Pinal Dave

SQL Tips and Tricks

Policy Management, SQL Coding Standards, SQL Scripts, SQL Server

I have previous written article about SQL SERVER Database Coding Standards and Guidelines Complete List Download. I just received question from one of the blog reader is there any way we can just prevent violation of company policy. Well Policy Management can come into handy in this scenario.