I just discovered a new SELECT clause that has been added to T-SQL in SQL Server 2005. TABLESAMPLE can be used to return a sampling of rows (either a fixed number or a specified percent of the table rows). Here is how it is used: /* Get a sample 5 rows */ SELECT * FROM table TABLESAMPLE (5 ROWS) /*...
I needed to do a fresh install of SQL Server 2005 Express yesterday, and no matter what I tried the installation kept failing with really strange errors about invalid or missing MSI files. The solution? Manually extract the installer files to a temporary folder and then run the extracted setup,...
Mike Hillyer is a member of the MySQL AB documentation team. He just posted a short review on my MySQL Crash Course , stating that it is "an excellent book for the beginning users just getting started with MySQL and perhaps SQL in general." Thanks, Mike!
TechBookReport has posted a review of my MySQL Crash Course , and concluded that "If you want to learn SQL and aim to implement your database using MySQL then this is definitely the book to use".
Amazon.com has been paying for Google AdWords for my name for quite some time now. And now they are also paying for the AdWords "MySQL Crash Course" (and linking to that search term which find my new MySQL book ). Cool!
Ray Camden has posted comments on my newly released MSQL Crash Course . Thanks, Ray.
Pete Freitag has posted comments on my newly released MSQL Crash Course . Thanks, Pete.
If you are upgrading to SQL Server 2005, pay attention to this one ... SQL Server has long supported two forms of OUTER JOIN syntax, the ANSI syntax (using LEFT OUTER JOIN, RIGHT OUTER JOIN, etc.), and the simplified T-SQL syntax (using *= and =*). If you've always used ANSI syntax then you are...
Several users have wanted to know if ColdFusion supports SQL Server 2005. And the answer appears to be yes. I am using ColdFusion MX 7.01 with the default SQL Server driver, and am connected to SQL Server 2005, and so far so good. Microsoft does have a new SQL Server 2005 JDBC driver in beta, but...
Here are some questions that I received about my new MySQL Crash Course . I am posting the answers here in case anyone else has the same questions: Does the book cover MySQL 5? The book was written for MySQL 4.x and MySQL 5, and most of the content applies to both. However, there are chapters that...