MySQL Archives - Page 17 of 349 - SQL Authority with Pinal Dave

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

December 18, 2009

Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download

In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…

SQLAuthority News – SQL Server 2008 for Oracle DBA

November 21, 2009

Pinal Dave

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

Database, DBA, MySQL, Oracle

This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server 2008 system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of…

SQL SERVER – Choose Right Edition of SQL Server Express for Your Application

October 4, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Download, SQL Server Express

SQL Server Express is better alternative of MySQL. I have recently helped quite a few organizations to move to SQL Server Express recently. However, one question keep on coming up quite often regarding which is the right edition for SQL Server Express. SQL Server Express have more than one edition…

SQL SERVER – Difference between SQL Server Express and MySQL

September 9, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Server, SQL Utility

Both SQL Server express and MySQL are two of the Relational Database Systems (RDBMS) available today. Both are freely available and meant for running smaller or embedded databases, yet there are also significant differences between them.

SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis

August 31, 2009

Pinal Dave

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

Database, MySQL, Software Development

On 20 April 2009, Oracle Corporation announced its acquisition of Sun Microsystems in a deal worth about US$ 6 billion. This would have been just another one of corporate mega-deals that sound interesting in the news but really have no effect on your life. Except for the fact that with…

SQLAuthority News – SQL Server 2008 Migration White Papers

August 23, 2009

Pinal Dave

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

MySQL, SQL Documentation, SQL Download, SQL Migration, SQL White Papers

Quite often I get project when I am asked to migrate different database to SQL Server. Microsoft has excellent white papers written for this series. Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008…

SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few

August 2, 2009

Pinal Dave

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

MySQL, Software Development

Does the proposed eGov Standards Policy benefit all or only a chosen few? As a wider audience comes to accept new technology, so the technology itself grows. The recent debate in India on the eGov Standards policy has been a point of contention for some time. I would like to…