mysql

Quick Tips on Restoring a MySQL Full InnobackupEx Backup

As I recently started using MySQL (with many years of SQL Server under my belt), here are some quick tips on restoring an InnobackupEx backup.  There was a context switch for me  but I’m enjoying the experience. Introduction There are many ways to backup / restore database (s) for MySQL but the mechanism I’m referring to here is Percona’s InnobackupEx 2.1 for MySQL.  The instructions for this backup can be found at Preparing a Full Backup with innobackupex and  Making a Full Backup.  What’s great about this type of backup is that it backups all of the databases on the…

Rate this:

Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an Atom feed) and its data can be imported directly into a PowerPivot for Excel workbook.  To get this thing to work, one of the key things that I remind people regularly is to make sure you install  ADO.NET Data Services Update for .NET Framework 3.5 SP1. ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008 ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows…

Rate this:

Delegation, Claims, Active Directory…Oh My!…Aw Crap!

Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state  😉 Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written by yours truly) and Excel Services delegation (by PowerPivotTwins partner Dave Wickert).   More importantly, if you want to debug and troubleshoot your way through the PowerPivot / Excel Services delegation issues, the coup-de-grace is Lee Graber’s excellent post: that The data connection uses…

Rate this:

Ramblings about missing time … and #PowerPivot sneak peek!

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But I do have a good excuse!  Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…

Rate this:

Reading your #PowerPivot Profiler trace

To help troubleshoot your PowerPivot for Excel workbook, you can click on Settings within the PowerPivot selection in the Office Ribbon which will bring up the Support & Diagnostics tab within the PowerPivot Options & Diagnostics dialog.  Click on the checkbox next to “Client tracing is enabled” and after opening the PowerPivot window, you will have a trace recorded on your desktop. Figure 1: Click the checkbox to enable client tracing   In order to view this trace, you will use SQL Server Profiler to view it.  Yet, if you do not have a SQL Server 2008 R2 client components…

Rate this:

Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI

When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file.  This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the file than the Office Upload Center.  The Office Upload Center is included as part of Office 2010 and what is great about this feature is that you can save the file asynchronously.  What this means is that you can save the file and then continue…

Rate this: