All Articles - SQL Authority with Pinal Dave

SQL SERVER – Deprecated DataType vardecimal

July 4, 2008

I received following email yesterday from Satnam Singh- Computer Programmer from Bangalore. “Dear Pinal, Congratulations for being MVP. You truely deserved it. I wonder why have you never written newly introduced feature of vardecimal. Keep up good work! Satnam Singh Developer – Bangalore.” In SQL Server 2005 SP2 they have…

SQL SERVER – 2008 – Introduction to New Feature of Backup Compression

July 3, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Backup and Data Storage is my most favorite subject and I have not written about this for some time. I was experimenting with new feature of SQL Server 2008 and I come across very interesting feature of Backup compression. Let us see example of Database AdventureWorks with and without compression.…

SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor

July 2, 2008

Pinal Dave

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

SQL Scripts

I previously wrote article about SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL. I am glad that in SQL Server 2008 we have new feature which will make our life much more easier. We will be able to insert multiple rows in SQL…

SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP

July 1, 2008

Pinal Dave

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

Database, DBA, MVP

I am very glad to announce that Microsoft has awarded me Most Valuable Professional Award for SQL Server. I would like to thank Microsoft and MVP Lead Abhishek for awarding this honor to me. MVP is most prestigious award and I am very pleased to receive it. I thank all…

SQL SERVER – 2008 – High Availability – Hot Add Memory

June 30, 2008

Pinal Dave

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

After reading my previous article about SQL SERVER – 2008 – High Availability – Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory. Yes, there are few restictions to Hot Add Memory as well. I am listing…

SQLAuthority News – Rise in SQL Injection Attacks Exploiting Unverified User Data Input

June 29, 2008

Pinal Dave

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

SQL Server Security

Microsoft is aware of a recent escalation in a class of attacks targeting Web sites that use Microsoft ASP and ASP.NET technologies but do not follow best practices for secure Web application development. These SQL injection attacks do not exploit a specific software vulnerability, but instead target Web sites that…

SQL SERVER – 2008 – High Availability – Hot Add CPU

June 28, 2008

Pinal Dave

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

SQL Server Security

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…