(kolbe) The much-anticipated, long-awaited, and possibly irrelevant (Sphinx? Lucene?) InnoDB Fulltext finally makes a semi-official appearance in MySQL 5.6.4! MySQL 5.6.4, release December 20, 2011, is the newest “development milestone release” (“DMR”) of MySQL 5.6.
Other News
AlwaysOn: Making upto date statistics available on Readable Secondary, Read-Only database and Database Snapshot
(Sunil Agarwal) In the previous blog http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-challenges-with-statistics-on-readonly-database-database-snapshot-and-secondary-replica.aspx we described that stale or missing statistics will potentially lead to a sub-optimal query plan
On Error Resume Next
MDX Training (Chicago) Our training partner, SolidQ, will be hosting a hands-on, instructor-led course on Jan. 31-Feb. 2 from 8:30 a.m. to 4:30 p.m. in Lisle, Illinois. The course will guide students step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. Tim Peterson, the course instructor and author of several books on Business Intelligence, will provide […]
On Being a Database Facilitator
On Being a Database Facilitator Chris Shaw wrote in with thoughts on the posting Monday about being a Database Facilitator – "30 years ago we were just afforded the technology to watch a movie at home. If I wanted to see Star Wars more than once, my only option was to return to the theaters. 15 years ago if I […]
System Testing
Is Work/Life Balance for DBAs Just a Myth? Many database administrators started their careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what was considered “normal.” Today, with careers underway, how do DBAs build a life outside of their data? In our webcast next Wednesday, Meredith Ryan-Smith, who is a […]
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
(Pinal Dave) I recently received following question from reader. I would like to share the complete story in few short sentences with you to give you complete idea. Let us call the reader Margie. Our long email conversation is converted into chat like conversation
Study of WAITSTATS(Part 6) – LOGBUFFER
(SQLZealot) LOGBUFFER is one among the IO Wait types in SQL server. This wait type is one of the very rare wait type. As I described earlier, it has got relation with WRITELOG. Just to iterate the same, please look at the operations when transaction happens(also look at the WRITELOG wait type explan
SQL Server Row Count for all Tables in a Database
(Dattatrey Sindol) I am a database tester and one of my tasks involves getting the row counts from all the tables in the source database and comparing it against the corresponding table row counts in the target database. How do I get the row counts from all the tables in a SQL Server Database? What
System Testing
Is Work/Life Balance for DBAs Just a Myth? Many database administrators started their careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what was considered “normal.” Today, with careers underway, how do DBAs build a life outside of their data? In our webcast next Wednesday, Meredith Ryan-Smith, who is a […]
Is There a Place for Test Recorders Anymore?
SSWUG TV With Stephen Wynkoop, Sam Brace and Field Reporter – Kevin Kline If you are thinking about moving into the Cloud, you will want to watch the Interviews with SQL Azure MVP Scott Klein Watch the Show Enterprise ETL with SSIS Training Opportunity For those of you near Denver, Colorado we have an opportunity just for you in association […]