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

SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description

May 24, 2008

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

I like to help every candidate who are finding job. I have previously written article here which can help all the people who are looking for job or looking for candidates. SQL Server Interview Questions and Answers Complete List Download Find Job Related to SQL SERVER SQL Server DBA- Job…

SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance

May 21, 2008

Pinal Dave

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

Best Practices, Database

I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering…

SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks

May 19, 2008

Pinal Dave

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

Best Practices, Data Warehousing, Database, DBA, Software Development, SQL Server Security

Note : Download PPT by Microsoft Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks The Windows Live Security team shares best practices – from platform and network security to incident management – in providing security for web applications and infrastructure. Organizations across the globe face…

SQLAuthority News – SQL SERVER Database Administrator Job Description

May 18, 2008

Pinal Dave

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

Database, DBA, Software Development

I have previously written article about SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer. I have received quite a lot of request to update it or post something similar. Writing SQL Articles are easier then writing Job description for DBA. I have read many job description…

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake

May 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQL Backup and Restore, SQL Data Storage, SQL Scripts

It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been long time since I wrote something funny on this blog. Recently, I have came across forum discussion regarding backup misery of one of the developer. I…

SQL SERVER – Four Basic SQL Statements – SQL Operations

May 13, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Coding Standards

There are four basic SQL Operations or SQL Statements. SELECT – This statement selects data from database tables. UPDATE – This statement updates existing data into database tables. INSERT – This statement inserts new data into database tables. DELETE – This statement deletes existing data from database tables. If you…

SQL SERVER 2005 – Microsoft Will Release SP3 Soon

May 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Service Pack

I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not? Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here. Reference : Pinal Dave (https://blog.sqlauthority.com)