When going to the PASS Summit 2014, don't forget about the focus group and the SQL Server clinic

Do you know that they have focus groups and SQL Server clinics at the PASS Summit 2014?

Here is what is available

Focus Groups

Room 201
Don’t miss this great opportunity to participate in one of the many focus groups that will be conducted at PASS Summit 2014.

Wednesday, November 5
12:00 – 1:00 PM: Power BI Visualizations and Formatting
You will soon have more control over the formatting of visualizations. Give us your opinion on visuals & formatting.

3:00 – 4:00 PM: Power BI Dashboarding
Give your opinions on the features you need to monitor the pulse of their business.

Thursday, November 6
12:00 – 1:00 PM: Power BI - Data Sources and External Connections
Give your opinion on what data sources we should support.

3:00 – 4:00 PM: Improving the user journey from data to insight in Excel
Discuss the user journey from data to insight in Excel desktop.

Friday, November 7
12:00 – 1:00 PM: Azure DocumentDB v-next
Shape future versions of Azure DocumentDB. We want to hear from developers, Architects and Decision Makers.

3:00 – 4:00 PM: Mobile BI - Your data, whenever & wherever you need it 
Review Mobile BI related use cases and scenarios in order to validate our customer hypotheses.


SQL Server Clinic

Room 4C
Work through your technical issues with top Microsoft Customer Service and Support (CSS) engineers and get architectural guidance from the SQL Server Customer Advisory Team (SQL CAT) and SQL Tiger Team. 

7:00 AM – 8:00 AM
10:00 AM – 8:00 PM

7:00 AM – 8:00 AM
10:00 AM – 6:00 PM

9:00 AM – 2:00 PM

And if somehow you think you need more material than is already available during the PASS summit, take a look at the more learning page: http://www.sqlpass.org/summit/2014/Sessions/MoreLearning.aspx You will find PASStv and instructor led workshops

Lego Ghostbusters and Back To The Future sets

Some pictures of the LEGO 21103 The DeLorean Time Machine Building Set and the Lego Cuusoo 21108 Ghostbusters Ecto-1, Limited Edition Set

My kids love these and play with them all the time


Lego Ghostbusters
Lego Ghostbusters

Lego Ghostbusters side view
Lego Ghostbusters side view

Lego Ghostbusters back view
Lego Ghostbusters back view

Marty McFly
Marty McFly

Marty and Doc
Lego back to the future Marty and Doc

Back to the future car
Lego back to the future car

Emmett Doc Brown
Emmett Doc Brown

Port Mercer Canal House in Princeton

It was a nice day today so I took a little walk near the canal where I live and snapped a couple of pics.

The Port Mercer Canal House is located at 4278 Quakerbridge Road in Lawrence Township, Mercer County, New Jersey, United States. It is situated along the Delaware and Raritan Canal near the border of West Windsor Township and Princeton, New Jersey. The house was built in the 1830s as housing for bridgetender and his family

Here are some pictures of the outhouse as well as the canal


Port Mercer sign

Port Mercer Canal Outhouse
Port Mercer Canal House

Port Mercer Canal Outhouse side view
Port Mercer Canal House side

Leaf turning red

Leaf tricolored
Leaf tricolored

Delaware and Raritan Canal
Canal Princeton

Turning red

Men’s shortlists for FIFA Ballon d’Or 2014 revealed

FIFA and France Football have today revealed the names for the men’s awards.

The final decisions will be made by the captains and head coaches of the men’s national teams as well as by international media representatives selected by France Football.


The following 23 men (in alphabetical order) are in contention for the FIFA Ballon d’Or 2014:

Gareth Bale (Wales)
Karim Benzema (France)
Diego Costa (Spain)
Thibaut Courtois (Belgium)
Cristiano Ronaldo (Portugal)
Angel Di Maria (Argentina)
Mario Goetze (Germany)
Eden Hazard (Belgium)
Zlatan Ibrahimovic (Sweden)
Andres Iniesta (Spain)
Toni Kroos (Germany)
Philipp Lahm (Germany)
Javier Mascherano (Argentina)
Lionel Messi (Argentina)
Thomas Mueller (Germany)
Manuel Neuer (Germany)
Neymar (Brazil)
Paul Pogba (France)
Sergio Ramos (Spain)
Arjen Robben (Netherlands)
James Rodriguez (Colombia)
Bastian Schweinsteiger (Germany)
Yaya Toure (Côte d’Ivoire)

The following ten coaches (in alphabetical order, first nationality and then team) are in contention for the FIFA World Coach of the Year for Men’s Football 2014:

Carlo Ancelotti (Italy/Real Madrid CF)
Antonio Conte (Italy/Juventus FC/Italy national team)
Pep Guardiola (Spain/FC Bayern Munich)
Juergen Klinsmann (Germany/ USA national team)
Joachim Loew (Germany/Germany national team)
Jose Mourinho (Portugal/Chelsea FC)
Manuel Pellegrini (Chile/Manchester City FC)
Alejandro Sabella (Argentina/Argentina national team)
Diego Simeone (Argentina/Atletico Madrid)
Louis van Gaal (Netherlands/Netherlands national team/Manchester United FC)


What do you think which player and coach will win the Ballon d’Or 2014 ?

Resources, tutorials, and tools to help you learn Microsoft’s big data solutions

Here are some resources, tutorials and tools to help you learn Microsoft's BIG DATA solutions.

SQL Server

What are the business benefits of in-memory technology?

How to Backup SQL Server to the Cloud

How to Migrate your Oracle Databases to SQL Server 2014


Power BI

Getting Started with Power Pivot – Part 1

3 Examples of Data-Driven Sales Growth

5 Minute Tutorial for Creating Custom Maps with Excel and Power Map

Retail Location Analytics Using Power BI

3 Steps to Gleaning Actionable Insights Using Power BI: Triathlon Edition


Microsoft Azure

How to Hadoop: 4 Reosurces to Learn and Try Cloud Big Data

The Ins and Outs of Apache Storm: Real-time Processing for Hadoop

Run Your Data Warehouse and OLTP Workloads in the Cloud: New Optimized Images on Azure

Predict What’s Next: Getting Started on Azure Machine Learning – Part 1

Predict What’s Next: Getting Started on Azure Machine Learning – Part 2

Simplify SQL Server AlwaysOn Configuration: New Template in Microsoft Azure Portal


 Interested in reading a bit more deeply? Check out these whitepapers:

 Whitepaper: Big data and retail services

 Whitepaper: Big data and financial services

Whitepaper: Best practices for building hybrid business intelligence environments

Whitepaper: Common Architectural Patters for In-Memory OLTP

Whitepaper: Design Considerations for SQL Server In-Memory

Whitepaper: Bringing In-Memory Transaction Processing to the Masses – An Analysis of Microsoft SQL Server 2014 In-Memory OLTP (GigaOm)


Everything you need to know about what's new in Microsoft Azure

Keeping track of all the announcements about Azure can be challenging. Check out this post where Rick Claus summarizes the most important Microsoft Azure updates and new features from the past year. Read here


Succeed in a hybrid world: 10 resources to get you started

How do you plan, build, deploy, and operate a hybrid cloud? Check out this list of resources to help you extend your datacenter by building a mix of on-premises and cloud infrastructure. Read here


SQL PASS 2014 Summit. Sessions I am attending....

This is my first time going to the PASS Summit, never been before so I am a PASS n00b! I have been to the MVP summit a couple of times so it will be interesting to see how that compares

Here are the sessions that I will be attending at the PASS Summit 2014

Tuesday November 4th

This is a full day session

Troubleshoot Customer Performance Problems Like a Microsoft Engineer (DBA-396-P)

Speaker(s):  Tim Chapman  Denzil Ribeiro 

Duration: full day

Track: Enterprise Database Administration & Deployment

Performance troubleshooting is arguably one of the most difficult aspects of being a database professional. Hardware and software continually get better, but data size and complexity continues to grow at an exponential rate. As Microsoft SQL field engineers, we service the largest customers in the world and see, troubleshoot, and fix challenging performance problems.  
In this full-day session join two SQL Server Microsoft Certified Masters, Principal PFE Denzil Ribeiro and Senior PFE Tim Chapman, as they tackle various challenging customer scenarios they've encountered. The class will start with developing a general performance troubleshooting methodology, which will include topics such as wait statistics, extended events, perfmon, DMVs, pssdiag, SQL Nexus. The rest of the day will cover hands-on troubleshooting of real performance problems. Customer problems will be reproduced and you will be involved in solving them , so expect an interactive class! Scenarios will relate to SQL Server 2008 - 2012 including how some of these are alleviated in SQL 2014.



Wednesday November 5th

8:15 AM - 9:45 AM Keynote: Evolving Microsoft’s Data Platform–The Journey to Cloud Continues  

Speaker(s):  T.K. Ranga Rengarajan  James Phillips  Joseph Sirosh 


10:15 AM - 11:30 AM [AD-210] Writing Faster Queries Using SQL Server 2014

Speaker(s):  Thomas LaRock  Tim Chapman 


1:30 PM - 2:45 PM Community Session: Checklist for Making the Most of PASS and Summit 

Speaker:  Wendy Pastrick 


3:00 PM - 4:15 PM [AD-307] Are You Optimistic About Concurrency? 

Speaker:  Kalen Delaney 


4:45 PM - 6:00 PM [DBA-318-M] SQL Server 2014 in-Memory OLTP - Memory/Storage Monitoring &Troubleshooting

Speaker:  Sunil Agarwal 



Thursday, November 06, 2014

6:45 AM - 8:00 AM Sponsor Breakfast: PASS The Bacon: Breakfast Panel 

Speaker(s):  Denny Cherry  Geoff Hiten  Joseph D'Antoni  Rob Volk 


8:15 AM - 9:45 AM Keynote: Cloud Databases 101

Speaker:  Rimma Nehme 


10:15 AM - 11:30 AM [AD-400] Query Tuning Mastery: Manhandling Parallelism, 2014 Edition

Speaker:  Adam Machanic 


1:30 PM - 2:45 PM [DBA-406] Solving Complex Problems with Extended Events 

Speaker:  Jonathan Kehayias 


3:00 PM - 6:00 PM [DBA-500-HD] Inside SQL Server I/O 

Speaker(s):  Bob Ward 


5:00 PM - 6:15 PM [DBA-412-M] Managing 1 Million+ DBs-How Big Data is Used to Run SQL Azure 

Speaker:  Conor Cunningham 

As you can see there is an overlap between these tow sessions, I will most probably attend the majority if not the whole session presented by Bob Ward before heading over to hear and see Conor present his session


Friday, November 07, 2014

8:00 AM - 9:15 AM [DBA-206] Table Partitioning: the Secret Weapon for Your Big Data Problems 

Speaker:  John Sterrett 


9:45 AM - 11:00 AM [DBA-309] Inside Ola Hallengren's Maintenance Solution

Speaker:  Ola Hallengren 


1:00 PM - 4:00 PM [DBA-501-HD] Locking Internals Deep Dive

Speaker:  Bradley Ball 


4:15 PM - 5:30 PM [DBA-305] Working with Very Large Tables Like a Pro in SQL Server 2014

Speaker:  Guy Glantser 


Those are all the sessions that I am attending. What do you think anything you like, would you say I should change some of them?  Keep in mind that I am primarily a developer who sometimes have to do some accidental DBA stuff

See you at pass and don't hesitate to say hello