Pass Summit 14 – Preconf (in progress)

Attending the preconf session Big Data: Deploy, Design, and Manage Like a Pro where Buck Woody (web), Adam Jorgensen (web | twitter) and John Welch (web | twitter) is doing their magic with Azure, HDInsight, PowerShell and everything in between.

B1iLXdiCQAA3SR6

Great questions from the attendees, and even greater answers.

Some keypoints from Buck is these, but I think they’ve always been relevant, but now even more in regards to Big Data.

  • Always ask the right questions
  • Never select the tech beforehand
  • Always select the TECHNOLOGIES after the questions have been asked and answered
  • Move 1TB data to Azure, DONT DO THAT
  • Send data i a trickle way, incremential data load

Powershell In A NutShell :

  • Scripting language
  • Based on Command Lets
    • Verb Noun
    • DIR becomes – Get child item
  • Variables always starts with a $
    • $Datasource
  • Everything is an OBJECT

John Welch is starting to talk about how to load data into your Azure storage, for this task we’re loading data from Twitter.com and Linkedin.com

John has a tool to download the XMLfeed from Twitter and Linkedin, the data needs to be preprocessed on record at at time

photo1

  •  Text files need to be in UTF-8 no BOM
  • Records is delimited by newline
  • Formats
    • Several formats can be used
    • Delimited text
    • SEQ. File
    • RCFile / Optimized Column File

 

More to come

In exactly 1 week I’m at PASS Summit 14

firsttimers

In exactly 1 week from now I’m in Seattle for my first ever Pass Summit, and I for one cannot tell you how much I look forward to be there with all the amazing people from the SQL community. As it my first time there i’m planning to attend the different “firsttimer” events, as well as all the other events that’s part of this summit.

We’re 3 guys travelling together this time, 2 from Rehfeld and 1 from Mærsk (whom used to be at Rehfeld) – and instead of crashing each night at different hotel rooms we’ve rented an whole appartment via AirBNB.

It seemed as the smartest, and it’s actually cheaper than hotels, only downside, is that the houserules says “STRICTLY NO PARTIES” – gonna be a tough one to manage ;o)

I’m attending 2 full day pre conference workshops, monday and tuesday and I’m really excited to learn from the best – and even pick up some tricks for use in my own presentations at SQLSaturdays around europe.

I’m in the process of trying to plan my session schedule, but I assure you, it’s a tough task – trying to pick which one of the sessions that I can skip to go for another.

Well until sunday next week, have a nice week, catch me on twitter, maybe we’ll see each other in Seattle.

 

CU 4 for SQL Server 2014 ready

sql-server-2014It’s a good day today, the release of Cumulative Update 4 for SQL Server 2014 will fix a lot of small and larger bugs.

Including the painfull one that task would shift to upper left corner in SSIS when resized.

Cumulative update package 4 for SQL Server 2014 (including update for SSIS) is available at http://support.microsoft.com/kb/2999197/en-us

This CU release contains a list of bug fixes for SQL in general, SSRS, SSAS and SSIS.

For SSIS fixes:

FIX: Tasks shift to upper-left corner when you move or resize them while designing a maintenance plan in SSMS 2014

FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS

FIX: SSIS 2012 or SSIS 2014 XML Source task cannot load data from URI

For SSAS Fixes:

FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model

FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014

SQL Performance Fixes:

FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server

SSRS Fixes:

FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 or SSRS 2014

For the full list look here

Campus Days 2014 – Our abstract got selected

uIIot3-P_400x400So this year I submitted an abstract for CampusDays ’14 – the conference of the year, well actually one of my friends and I submitted together. So I’m thrilled to be speaking in 2 sessions together with Régis Baccaro ( Twitter | Blog ), we’ll be talking about Azure, Azure Storage, HDInsight, Azure Machine Learning and a bunch more.

The speakers selected this year, is in the absolut top, there’s MVP’s (did I mention that Régis is MVP) experts in various fields, so if you would like to know the latest about Microsoft Technology – do not hesitate – hurry up and register for a great time, together with like minded people.

Have a look at the tracks, and other information about Campus days in Copenhagen – Click on the logo

 

Campusdays er stedet hvor IT Pro og udviklere mødes channel9.msdn.com/Events/Microso… #CampusDays #MSDevDK #DKITPro

Microsoft Exam 70-457/58 Passed

Amidst all the talk about the death of MCM certification from Microsoft, i’ve 

been reading and catching up on my SQL 2012 knowledge.

So that I could transition my current MCITP 2008 Business Intelligence to SQL server 2012 MCSE, I took the 70-457 exam last friday and passed with well over 800 points.

This morning I took the 70-458 exam and passed that as well, this time the administration of SQL server bumped the overall score down a little, but I passed.

Now in 14 days time I’ll have the last one, the 70-460 exam and after that i’ll med certified SQL Server 2012 MCSE ;O)

Great way to start my friday, and the weekend.

Exam prep for SQL server 2012 MCSA

Microsoft have just launched their youtube channel with exam prep videos for Microsoft SQL Server 2012 MCSA.

There are videos for the following exams:

  • 70-461 – Quering Microsoft SQL server 2012
  • 70-462 – Administering Microsoft SQL server 2012
  • 70-463 – Implementing a Data Warehouse with Microsoft SQL server 2012

They are all about 1 hour and 15 minutes long, so grab a coffee mug and a notepad og Onenote, and prepare yourself for your next exam.

http://www.youtube.com/playlist?list=PLahhVEj9XNTct1VslZ_LhNSI8F5_8Ikve