(Jan Jorgensen) If you've read my last two tips, you should by now have installed an Apache Server running PHP and a MySQL Database Server locally on your PC. Even if you haven't, you can benefit from this tip because if you have the installment on a "remote" Web server, the scripts provided here will still work. But you might have to do a little tweaking.

Announcing: DBA School - Learning SQL Server for the Rest of Us A three-day course taught by Stephen Wynkoop - centered around real-world experiences, how-to information and specific demonstrations and labs that will let you use and explore the topics covered. We'll be covering Performance, ...(more)

Featured Article(s) How to EASILY Migrate from IIS 6 to IIS 7 There are tons of great new features in IIS7 and the list continues to grow. We identify the top reasons people refuse to upgrade to IIS 7 and show you how a new tool from Microsoft, the Web Deployment Tool, makes the process nearly s...(more)

Featured Article(s) Undocumented Validation SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented validation DBCC commands that shipped with SQL Server 2008. Last Day To Register!  Workshop is TOMORROW Tomorrow is the day - 3+ hours of SQL ...(more)

(Rob Gravelle) XML was created to facilitate the transportation of data between systems and businesses in a language nonspecific way. When first introduced, a script or application process had to parse the XML data and convert it into valid format for the database and underlying system. Later, databases started to support XML so that no conversion was necessary. Today, we�ll look at XML support in MySQL and learn how to import and export data in XML format.

Twitter - Facebook SSWUG.ORG page vWorkshop - Last Days to Register - Register Now! SQL Server Performance - Presented by Stephen Wynkoop I'll be doing a virtual workshop THURSDAY - several hours on SQL Server performance.  Find out about indexes, TSQL tips,...(more)

(Shlomi Noach) Time for another charting SQL query. I wish to present a single-query generated multi-line/area chart. I�ll walk through some of the steps towards making this happen. By the end of this post I�ll present some real-data charts, area charts and colored charts.

(Nicholas Goodman) Here�s the scenario. You�ve got a table in MySQL for reporting that has a few million rows, and is denormalized for reporting. You�ve got a Pentaho Report that is querying this MySQL table. You have two problems with the current report. --Your users are complaining that the query is slow, and they have to wait around for longer than they�d like to see their report. (approx 40s) --Your DBAs are cranky because they see the size of this table is getting bigger. (approx 1.8GB)

Get Social! Twitter - Facebook SSWUG.ORG page vWorkshop - Just a Couple of Days Away - Register Now! SQL Server Performance - Presented by Stephen Wynkoop I'll be doing a virtual workshop THURSDAY - several hours on SQL Server performance.  Find out about indexes, TS...(more)

(Sarah Sproehnle) Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.

(Ulf Wendel) C and PHP MySQL clients can set a connection timeout before a connection is established to MySQL. The MySQL C API manual states about MYSQL_OPT_CONNECT_TIMEOUT , which is equal to PHPs MYSQLI_OPT_CONNECT_TIMEOUT:

Announcing - Next DBASchool - In-Person Class Instructor: Stephen Wynkoop I'll be teaching a 3-day class on the things that you really need to know about SQL Server.  We'll have hands-on exercises, lots of discussions and real-world lessons learned.  Check out the site here and reserve...(more)

(Baron Schwartz) MySQL Proxy is a really neat tool. I remember a few years back when I first saw Jan talking about it. Back in those days it was significantly different than it is now, but the concept remains the same: direct your database traffic through a man-in-the-middle. Chris Calender�s post on capturing erroneous queries with MySQL Proxy shows one use for Proxy. But wait. MySQL Proxy is just inspecting the MySQL protocol. And unless you�re using it for something else too, having a man in the middle to catch errors is like standing in the middle of the street and blocking traffic to count the cars on the street. Why don�t you stand on the sidewalk to count the cars instead?

Featured Article(s) Useful Undocumented Miscellaneous SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented miscellaneous DBCC commands that shipped with SQL Server 2008. Combine Named Sets and Calculated Members in Analysis Services, Pt. 3 Part 3: C...(more)

(Sergey Petrunia) MariaDB 5.1 beta is almost out, so it's time to cover some of its features. The biggest optimizer feature is MWL#17 Table Elimination.

Featured Article(s) Robust print view for SharePoint list views Nearly any intranet or extranet and especially Internet site will require to have a print view for pages or sections of the site. If you take a standard approach of modifying CSS you might be spending days trying to get details of l...(more)

Featured Article(s) Combine Named Sets and Calculated Members in Analysis Services, Pt. 2 Part 2: Combine Named Sets with Calculated members to meet client and employer business requirements. Join BI Architect Bill Pearson as he leads hands-on exploration of Named Set / Calculated Member combina...(more)

(Michael McLaughlin) All this time I thought MySQL was so progressive by eliminating the DUAL pseudo table when selecting a string literal. I also thought it interesting that they also supported selecting a string literal from the DUAL pseudo table. While playing around with examples for my students, I found out that there is a use case when MySQL requires you to use the DUAL pseudo table.

Did You Miss the Virtual Conference?  No worries... There's still time - you can catch it on-demand right now!  All of the sessions, all of the great content.  The sessions, demonstrations and help is second to none, period.  Take a look, check out the sessions, download the s...(more)

(Leo Hsu and Regina Obe) This is an unfortunate predicament that many people find themselves in and does cause a bit of frustration. You bring in some tables into your PostgreSQL database using some column name preserving application, and the casings are all preserved from the source data store. So now you have to quote all the fields everytime you need to use them. In these cases, we usually rename the columns to be all lower case using a script. There are two approaches we have seen/can think of for doing this one to run a script that generates the appropriate alter table statements and the other is to update the pg_attribute system catalog table directly.