Ozzie.eu

Announcement: Springpad is Shutting Down on June 25th

This Is rally a shame. Such a nice note taking app…

Computers are like bikinis. They save people a lot of guesswork.

Arbitrary XML file conversion to JSON

Here’s a script I cooked up to generate JSON from a given XML file, any file:

Magic …

Stack Exchange PowerShell Loader

Following a session I attended on a SQL Saturday event and reading a post from Brent Ozar, I got the idea for a new github project, a loader utility script made to import the Stack Exchange data dumps, in XML format, into a given Microsoft SQL Server database.

The data dumps are an anonymized dump of all user-contributed content on the Stack Exchange network. Each site is formatted as a separate archive consisting of XML files zipped via 7-zip using bzip2 compression. Each site archive includes Posts, Users, Votes, Comments, PostHistory and PostLinks.

You can find and choose to download the data dumps here: https://archive.org/details/stackexchange

The given DDL file for the schema and database object creation is adapted from Jeremiah Peschka’s soddi project. You can check it out here: https://github.com/peschkaj/soddi

In order to run the script, you should have Powershell v3 and MSSQL Server Management Studio 2012 or above:

You can chek the project’s page and get the source here:

http://mjlmo.github.io/SEPSLoader/

Happy scripting!

Série Templários

portugalsecrets:

Para quem gosta de história e dos nossos Templários, aqui está uma série interessante.

O Canal História vai estrear o 1º episódio dia 12 de Maio (2ºf) às 22h.

A série é composta por 6 episódios de 45 minutos cada, e vai ter como cenário o Castelo de Tomar e…

Já tenho programa para segunda-feira à noite.

Windows PowerShell 4.0 Quick Reference Guides

The PDF files in this download are short-form Quick Reference (also called “cheat sheet”) guides for IT professionals, developers, and scripting enthusiasts who want to learn tips, shortcuts, common operations, limitations, and proper syntax for using Windows PowerShell 4.0, Windows PowerShell Desired State Configuration (DSC), Windows PowerShell ISE, Windows PowerShell Web Access, Server Manager, WMI, and WS-Man in Windows Server 2012 R2 and Windows 8.1. 

To download go to the Microsoft Download Center:

http://www.microsoft.com/en-us/download/details.aspx?id=42554&ocid=aff-n-we-loc—ITPRO40886&WT.mc_id=aff-n-we-loc—ITPRO40886