(Chuck Bell) The mysqldiff and mysqldbcompare utilities were designed to produce a difference report for objects and in the case of mysqldbcompare the data. Thus, you can compare two databases and produce a report of the differences in both object definitions and data rows.
Other News
Deploy new applications on IBM PureSystems with plug-ins, Part 1
(Chin Huang and Ton Ngo) The introduction of IBM PureSystems — an expert, integrated, enterprise-level family of cloud system that encompass applications, services, hardware, and even the expertise (delivered in the form of best practices patterns) — takes cloud computing to new heights.
Export data from MySQL to SQL Server
(Daniel Calbimonte) Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases l
The Good Side of Metro Design
SSWUGtv – SQL Server 2012 With Stephen Wynkoop In todays edition Steve interviews Gareth Swanepoel. Gareth talks about SQL Server 2012, extended events wizard and interface – how to performance tune, and more. Watch the Show The Good Side of Metro Design Now that I have spent some time with the things I don’t like about the Metro Style Design […]
SSWUGtv News: News of the week, including how big data will impact your privacy requirements.
Video Programming for IT Professionals
Metro? What Is Behind It All?
SSWUGtv – SQL Server 2012 With Stephen Wynkoop In todays edition Steve interviews Gareth Swanepoel. Gareth talks about SQL Server 2012, extended events wizard and interface – how to performance tune, and more. Watch the Show Metro – What Is Behind It All? I’d like to wrap up my concerns about the Metro design principles with another epistle from David […]
Row security and hierarchies–part 1
(Cathy Dumas) Fair warning: this is going to be complicated. In this post, I am going to assume that you’ve read the row security whitepaper, you are familiar with how parent/child hierarchies work in the tabular model, and you can deal with fairly complicated DAX concepts.
IAMs: Keeping Track of Space Used
(Kalen Delaney) When I initially start talking about space allocation on the first day of my five-day SQL Server Internals class, I have a simple demo using the sp_spaceused procedure which I use to illustrate how much space is actually allocated to a table. I use an example that creates a table wit
Changes Large and Small: WCF 4.5 and the ASP.NET Web API
(Peter Vogel) The Microsoft Windows Communication Foundation (WCF) seems to be approaching a kind of maturity. The upcoming release of the Microsoft .NET Framework 4.5, for instance, offers lots of improvements that will make your life better, but only one change that, I think, qualifies as critical
DAIA & describing organizations, services, collections in RDF
(Adrian Pohl) In January Jakob Voß published the request for comments for the final DAIA specification. DAIA – Jakob writes –