All Articles - SQL Authority with Pinal Dave

SQL SERVER – Create Check Constraint on Column

June 22, 2008

SQL Constraint and Keys, SQL Error Messages, SQL Scripts

I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before…

SQLAuthority News – White Paper: Security Overview for Database Administrators

June 21, 2008

Pinal Dave

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

SQL Download, SQL Server Security, SQL White Papers

Note: Download White Paper by Microsoft SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL…

SQL SERVER – Find Current Identity of Table

June 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server DBCC

Many times we need to know what is the current identity of the column. I have found one of my developer using aggregated function MAX() to find the current identity. USE AdventureWorks GO SELECT MAX(AddressID) FROM Person.Address GO However, I prefer following DBCC command to figure out current identity. USE AdventureWorks…

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

June 19, 2008

Pinal Dave

SQLAuthority News

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.