Posting My Presentations from SQLSaturday #35 – Part I

This is a little bit embarrassing… I can’t upload the zip archive files with my presentation materials! Apparently WordPress.com, the host of this blog, does not allow zip files: Accepted Filetypes. My presentation materials include a mixture of PDF files, PowerShell and T-SQL script files, XML deadlock graph files, and a few other file types. I’ll post what I can (the PDF files), now, and then figure out a contingency plan or work-around tomorrow. Any suggestions would be appreciated!

About tnbarkhouse

I'm a SQL Server database administrator with a few tools to share.
This entry was posted in PowerShell, SQL Server and tagged , , , . Bookmark the permalink.

8 Responses to Posting My Presentations from SQLSaturday #35 – Part I

  1. Ryan Adams says:

    I’m assuming you have FTP access. If you do, what I did was create a downloads folder under the wp-content folder and copy my stuff there. Then I just found a download icon on the web, inserted it into my blog entry, and then hyperlinked it to the URL of where I uploaded the file. Here is the link to a post where I did that. My blog is slow and I am in the middle of moving it, so if you can’t see the post just try back the next day.

    http://www.ryanjadams.com/index.php/2010/03/lastlogon/

  2. Thomas Lunsford says:

    Can you post zip file as Filename.zip.txt (or other acceptable extension)?

    • tnbarkhouse says:

      I didn't try. I wasted quite a bit of time that night before I realized that WordPress.com simply prohibits Zip files. It seemed so absurd that it didn't occur to me that such a restriction would exist. Fortunately I have a solution now, as described here. Thanks!

  3. Thomas Lunsford says:

    Hmm, the previous post didn’t go. 2nd try…

    Can you do something like append .txt (or other acceptable extension) on to the zip file?

    • tnbarkhouse says:

      Comments on this blog won't appear until being moderated, a task to which I am finally attending!

  4. .docx is allowed, and that is a zip file under the covers. I wonder what would happen if you created a .docx with just the words “rename me to .zip” on the document, then renamed it to a .zip yourself, added your files, then back to .docx. This would, I bet, bypass any verification that WP is doing on the files while letting you post whatever you want. Just a thought (and a bit of a hack) :-)

    • tnbarkhouse says:

      That's an intriguing work around. :) At one point I was pulling a *.pptx file out of source control and accidentally ended up with three sub-directories and an XML document, but I didn't reach the conclusion of it being an archive file. Thanks for pointing that out! Of course now I've wasted time reading "How to: Manipulate Office Open XML Formats Documents!"

      I ended up leveraging Amazon's S3 service, which has worked out pretty well. Thanks for the suggestion all-the-same!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s