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

SQL SERVER – Difference Between DBMS and RDBMS

June 27, 2008

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 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 – 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…

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 – Step By Step Installation Guide With Images

June 12, 2008

Pinal Dave

SQL Tips and Tricks

Database, SQL Server, SQL Server Installation

SQL SERVER 2008 Release Candidate 0 has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier.