Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2008 – High Availability – Hot Add CPU

June 28, 2008

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

One of team member suggested that we should upgrade to SQL Server 2008 because its new feature is very cool “Hot Add CPU”. Yes, I agree it is very cool feature. I am eagerly waiting for RTM of SQL Server 2008 so I can upgrade our servers to SQL Server…

SQL SERVER – Difference Between DBMS and RDBMS

June 27, 2008

Pinal Dave

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

Data Warehousing, Database, DBA, Software Development

What is the difference between DBMS and RDBMS? DBMS – Data Base Management System RDBMS – Relational Data Base Management System or Relational DBMS A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that…

SQLAuthority News – Famous Quotes From Bill Gates – Part 2

June 26, 2008

Pinal Dave

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

SQL Humor

My previous article about Bill Gates SQLAuthority News – Famous Quotes From Bill Gates got really lots of readers and got lots of request in email that I should have follow up article about other famous quotes from Bill Gates which are missing from original article. This blog is not…

SQLAuthority Download – SQL Server Cheatsheet

June 25, 2008

Pinal Dave

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

Best Practices, Database, DBA, Software Development, SQL Cheat Sheet, SQL Download

I think this is most popular question I receive in email, if I have SQL Server cheat sheet. Well, SQL Server is very wide subject and covering all the main topics of SQL Server will take 100 pages book as cheat sheet. I have tried to create one page cheat…

SQLAuthority News – Microsoft Source Code Analyzer for SQL Injection

June 24, 2008

Pinal Dave

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

Database, SQL Download, SQL Server Security

Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks. Perform the following steps to download and…

SQLAuthority News – Release Notes for SQL Server 2008 Release Candidate 0

June 23, 2008

Pinal Dave

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

All product should be documented. Particularly when any release happens product must have release notes because release notes educates people about product and its usage. Microsoft has also release notes for SQL Server 2008. This Release Notes document contains information for Microsoft SQL Server 2008 Release Candidate 0 (RC0) that…

SQL SERVER – Create Check Constraint on Column

June 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…