Category Archives: PASS Summit 2014

Five Things to Know About SQL Server’s In-Memory Technology

Last week was an exciting week for the SQL Server team, as one of our favorite events happened – PASS Summit. If you attended PASS, you probably heard a ton about the latest version of SQL Server 2014.

One of the key drivers of SQL 2014’s design was the in-memory technology that is built into the product. These capabilities and the way they were designed are a key differentiator for SQL Server 2014. Recently we discussed how using SQL Server 2014’s in-memory technology can have a dramatic impact on your business – speeding transactions, queries, and insights. Today let’s  delve a little deeper into our in-memory solution and our unique approach to its design.

We built in-memory technology into SQL Server from the ground up, making it the first in-memory database that works across all workloads. These in-memory capabilities are available not only on-premises, but also in the cloud when you use SQL Server in an Azure VM or use the upcoming in-memory columnstore capabilities within Azure SQL Database. So just what makes our approach so unique? This video describes it well.

We have five core design points for SQL Server in-memory. These are: 

  1. It’s built-in. If you know SQL Server, you’re ready to go. You don’t need new development tools, to rewrite the entire app, or learn new APIs.
  2. It increases speed and throughput. SQL Server’s in-memory OLTP design removes database contention with lock and latch-free table architecture while maintaining 100 percent data durability. This means you can take advantage of all your compute resources in parallel, for more concurrent users.
  3. It’s flexible. Your entire database doesn’t need to be in-memory. You can choose to store hot data in-memory and cold data on disk, while still being able to access both with a single query. This give you the ability to optimize new or existing hardware.
  4. It’s easy to implement. The new migration advisory built right into SQL Server Management Studio lets you easily decide what to migrate to memory.
  5. It’s workload-optimized. In-memory OLTP is optimized for faster transactions, enhanced in-memory ColumnStore gives you faster queries and reports, and in-memory built into Excel and Analysis Services speeds analytics.  

All of this combined leads to up to 30x faster transactions, over 100x faster queries and reporting, and easy management of millions of rows of data in Excel. Think about what this can do for your business.

Learn more about SQL Server 2014 in-memory, or try SQL Server 2014 now. 

Rainbow in the Cloud

Cloud tecnologies burst into our lives without asking our permission. 
At the beginning many of us thought the only thing that it brings would be the thunder and the rain. 
Time shows that, instead, it might even bring some color to our skies.
Today, on a first day Keynote of the 16th PASS Summit, Microsoft representatives 
 -Corporate VP Data Platform, Cloud & Enterprize T.K. “Ranga” Rengarajan , 
– General Manager of Power BI James Phillips 
– Corporate VP Information Management &Machine Learning Joseph Sirosh 
took stage one after another talking about the Microsoft Data Platform and what it can offer in the cloud space.
They have talked about the explosion of all kinds of data devices.  Those devices produce enourmous amouts of data. Many also consume enourmous amounts of data.
This data is changing the way we work, the way we do business, and the way we live. We all depend on data to make decisions.
Microsoft Data Platform allows us to do more. To achive more. In theory, i might add. Just because I had no chance to try their new products myself.
Microsot Data Platform has all kind of tecnologies that are used by many mission critical environments around the world.
Tecnologies based on the structured data & tecnologies based on unstructured data.
In memory & on disk data processing. 
Products that can scale up & products that can scale out. 
Technologies that can store data & tecnologies that only procees the data. 
Some can live on premises & some can live only in the cloud.
Microsoft Data Platform in the cloud has a lot to offer. 
Key/value pairs management using Microsoft Azure Tables ( )
Document management, schema free, write optimized plaform using new highly Scalable Azure DocumentDB ( )
Relational database-as-a-service ( )
File system computation using Azure HDinsight, which both process data and store it in the cloud ( )
Json based full indexing using Azure Search ( )
Broser-based data orchestration by Azure Data Factory ( )
Prediction models tecnology by Azure Stream Analytics and Azure Machine Learning. ( dashboards used in several demos today were very impressive with all its interactive and colorful reports. 
Loud music contributed to the great spirits of 3,941 attendees from 56 countries and 2,000 companies. Huge screens thanked all  community volunteers, chapter leaders and sponsors.
The World is excited about data.  Microsoft are excited about their data platform. I am excited to be at the PASS summit. 

Microsoft announces major update to Azure SQL Database, adds free tier to Azure Machine Learning

This morning at the Professional Association for SQL Server (PASS) Summit, we celebrated SQL Server 2014’s strong momentum and introduced new services that further expand Microsoft’s big data platform. We announced a major update coming to our database-as-a-service, Azure SQL Database, and easier access to our machine learning service, Azure Machine Learning. These new updates continue our efforts to bring big data to everyone by delivering a comprehensive platform that ensures every organization, every team and every individual is empowered to do more and achieve more because of the data at their fingertips.

I’m really pleased to be making these announcements today at PASS Summit, where, along with my colleagues Joseph Sirosh, corporate vice president of Machine Learning and Information Management; and James Phillips, general manager of Data Experiences; I delivered a keynote highlighting the momentum of SQL Server 2014 and other recent releases in our data platform such as Azure Stream Analytics, Azure Data Factory, Azure DocumentDB, Azure Search and Azure HDInsight. As the world’s largest gathering of SQL Server and business intelligence professionals, PASS is hugely important, enabling us to connect with SQL Server customers and gain valuable feedback to help inform the product’s development.

Customers embrace SQL Server 2014

SQL Server is the cornerstone of our big data platform. It is the world’s most widely-deployed database and is used across the globe for mission critical enterprise deployments. Last month, based largely on our work with SQL Server, Microsoft was recognized as a Leader in Gartner's Magic Quadrant for Operational Database Management Systems, and positioned furthest to the right in completeness of vision*. Earlier this year, we released SQL Server 2014, which includes built-in breakthrough in-memory OLTP and columnstore technologies, as well as hybrid cloud capabilities. Since then, SQL Server 2014 has seen tremendous growth and positive reception among customers, with more than 1.2 million downloads to date and 30 percent of Azure SQL Server virtual machines currently running SQL Server 2014.

Clalit, Dell, Eastman Chemical Company, GameStop, Kiwibank, LC Waikiki, Pros, Saab and Stack Overflow are just a few of the customers using SQL Server 2014. GameStop is using SQL Server 2014 in two main scenarios: disaster recovery and backup to Azure to accommodate the company’s infrastructure freeze for holidays and big game launches, and as the default install for new SQL Server instances. Stack Overflow is a question and answer site for professional and enthusiast programmers. By basing their platform on technologies like SQL Server 2014 (specifically taking advantage of AlwaysOn Availability Group replicas), they can have a highly available, high-performing platform that easily and quickly gets answers to thousands of global users.

Azure SQL Database, Azure Machine Learning

Later this year, we will preview a new version of Azure SQL Database that represents another major milestone for this database-as-a-service. With this preview, we will add SQL Server capabilities that will make it easier to extend and migrate applications to the cloud, including support for larger databases with online indexing and parallel queries, improved T-SQL support with common language runtime and XML index, and monitoring and troubleshooting with extended events. In addition, the preview will unlock our in-memory columnstore, which will deliver greater performance for data marts and continue our journey of bringing in-memory technologies to the cloud. We will offer these new preview capabilities as part of the service tiers introduced earlier this year, which deliver 99.99% availability, larger database sizes, restore and geo-replication capabilities, and predictable performance.

Microsoft Azure Machine Learning is a fully managed cloud service for building predictive analytics solutions, and helps overcome the challenges most businesses face in deploying and using machine learning. Starting today, it will be easier than ever for anyone to try Azure Machine Learning, as the service is now available to test free of charge without a subscription or credit card – all customers need to get started is a Microsoft account ID. This free tier is one more way Azure Machine Learning is making advanced analytics more accessible to more people. DBAs, developers, business intelligence professionals and nascent data scientists can now experiment with Azure Machine Learning at no cost.

Microsoft Data Platform

We are making all these investments in SQL Server and the rest of our data platform because we are living and working in an amazing time where organizations are utilizing data to make smarter decisions, better predict their customers’ needs and provide more differentiated products and services. Data has become the new currency and it is helping to differentiate today’s leading companies. 

To get there, organizations need a comprehensive platform to capture and manage all of their data, transform and analyze that data for new insights, and provide tools which enable users across their organization to visualize data and make better business decisions. Microsoft’s approach is to make it easier for our customers to work with data of any type and size – using the tools, languages and frameworks they want – in a trusted environment on-premises and in the cloud. To learn more about our approach to big data, visit our web page.

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Attending the PASS Summit

The PASS Summit is an annual gathering of SQL Server professionals and others interested in learning more about SQL Server. Folks come from all over. Here’s a few suggestions for getting more out of your PASS Summit experience. “What if I’m Not There?” Not everyone can attend the PASS Summit. You can still enjoy a taste of the activities via PASSTV, which will be streamed from the PASS Summit 2014 home page . Meet New People If this is your first (or one of your first) PASS Summit(s), don’t be shy….(read more)

PASS Summit: Networking, Onsite Activities & SQL Family

Just one week from now, PASS Summit will bring together the #SQLFamily in Seattle for the best week of SQL Server and BI learning and networking on the calendar, Nov. 4-7. With a record 200+ technical sessions across 3 jam-packed days of connecting and sharing with 5,000 fellow SQL Server professionals from around the world, PASS Summit 2014 will be the biggest Summit yet.

In addition to sessions with top community and Microsoft experts, guidance from Microsoft CSS, SQLCAT, and SQL Tiger teams at the popular SQL Server Clinic, and hands-on instructor-led workshops, Summit attendees can get 50% off Microsoft certification exams onsite. What else can you look forward to at this year’s Summit? Here are just some of the networking activities, onsite events, and opportunities to immerse yourself in the #SQLCommunity like never before.

First Timers

First-time Summit attendee? Don’t know what to expect at the conference? Don’t miss one of our First-Timers’ orientation sessions Tuesday before the Welcome Reception to get an inside look at what’s in store for you at PASS Summit and tips on getting the most from your week. Then, jump into a Speed Networking session with your fellow First-Timers, and start making connections. We’ll also have daily “Get to Know Your Community” sessions on how to navigate Summit and get more involved in PASS and the #SQLCommunity year-round.

Speaker Idol

For the first time ever, watch as 12 presenter compete for a guaranteed speaking spot at PASS Summit 2015. With three rounds across three days, a panel of judges from the community will give Speaker Idol contestants real-time feedback and select the finalists for Friday’s “speak-off.” Drop by the Community Session Room (Room 400) to watch this competition and cheer on your favorite speakers.

Community Zone

The Community Zone, on the level-4 Skybridge, is the place to mix and mingle with members of the community. Local and Virtual Chapter leaders, Regional Mentors, SQLSaturday organizers, and MVPs will be on hand Wednesday through Friday to answer any questions you have about PASS. The Community Zone will also feature a different country/language spotlight every hour – come by and talk with community leaders from your area and who speak your native language. Plus, meet community leaders from around the world and you could win a $250 VISA gift card in our SQL Around the World scavenger hunt-style game. 


This year’s Summit features two great opportunities tolearn more as you dig into lunch. Thursday’s Women in Technology Luncheon welcomes special guest keynoter Kimberly Bryant, founder of Black Girls CODE, to share her thoughts in a question-and-answer session. And join with MVPs, speakers, PASS Board members, and fellow attendees in our closing day Birds of a Feather Luncheon, focused on bringing people with the same passions together.

Evening Events

The fun continues even after sessions are over, with evening events designed to help you engage with the community and relax after an intense day of training. Help us kick off PASS Summit at Tuesday’s Welcome Reception, and rub shoulders with our sponsors and exhibitors at Wednesday’s Exhibitor Reception. Then enjoy Thursday’s Community Appreciation Party at the contemporary, cutting-edge Experience Music Project Museum, sponsored by PASS and Microsoft as a special thank you for being part of the #SQLCommunity.

Read what community bloggers are looking forward to at the SQL Server event of the year. And if you haven’t already, make sure you register by Oct. 31 to save $200 off the onsite rate. We can’t wait to see everyone there!

Microsoft sessions at PASS Summit 2014

Got SQL Server 2005 running on Windows Server 2003?  We have fantastic pre-con and general sessions to help you plan your upgrade and migration strategies.

Interested in the new Azure data services like Azure DocumentDB, Azure ML, and Azure Search?  We have awesome people lined up to give you all the details.

Want know the nitty-gritty about Azure SQL Database? We got you covered.

It is PASS Summit time and we are counting down the days. We have Microsoft experts from our Redmond campus, field experts flying in from Italy and the U.K., and we’re bringing customers to share their stories – just to name a few.  Check out the Microsoft sessions below and add them to your PASS Summit session builder along with great community sessions. 

7 Databases in 70 Minutes: A Primer for NoSQL in Azure, Lara Rubbelke and Karen Lopez

Analytics Platform System Deep Dive (APS), Paul Dyke

Analytics Platform System Overview (APS), Nicolle Whitman

Analyzing tweets with HDInsight, Excel and Power BI, Miguel Martinez and Sanjay Soni

Application Lifecycle Management for SQL Server database development, Lonny Bastien and Steven Green

Azure CAT: Azure Data Platform: Picking the right storage solution for the right problem, Kun Cheng, Rama Ramani, and Ewan Fairweather

Azure CAT: Azure SQL DB Performance Tuning & Troubleshooting, Sanjay Mishra, Kun Cheng, and Silvano Coriani

Azure CAT: Deep dive of Real world complex Azure data solutions: Lindsey Allen, and Rama Ramani

Azure CAT: Running your Line of Business application on Azure Virtual Machine Services, Juergen Thomas

Azure CAT: SQL Server 2014 Gems, Shep Sheppard

Azure CAT: SQL Server 2014 In-Memory Customer Deployments: Lessons Learned, Michael Weiner and Stephen Baron

Azure Search Deep Dive, Pablo Castro

Azure SQL Database Business Continuity and Auditing Deep Dive, Nadav Helfman and Sasha Nosov

Azure SQL Database Overview, Bill Gibson and Sanjay Nagamangalam

Azure SQL Database Performance and Scale Out Deep Dive, Torsten Garbs and Michael Ray

BI Power Hour, Matt Masson and Matthew Roche

Building a Big Data Predictive Application, Nishant Thacker and Karan Gulati

Built for Speed: Database Application Design for Performance, Pam Lahoud

ColumnStore Index: SQL Server 2014 and Beyond, Sunil Agarwal and Jamie Reding

Connecting SAP ERP and Microsoft BI Platform, Sanjay Soni

Data-tier Considerations of Cloud-based Modern Application Design, Scott Klein

Deep Dive into Power Query Formula Language, Matt Masson and Theresa Palmer-Boroski

Deploying Hadoop in a Hybrid Environment, Matt Winkler

Deployment and best practices for Power BI for Office 365, Miguel Llopis

End-to-End Demos with Power BI, Kasper de Jonge and Sanjay Soni

HBase: Building real-time big data apps in the cloud, Maxim Lukiyanov

Improve Availability using Online Operations in SQL Server 2014, Ajay Jagannathan and Ravinder Vuppula

In-Memory OLTP in SQL Server 2014: End-to-End Migration, George Li

Interactive Data Visualization with Power View, Will Thompson

Introducing Azure Machine Learning, Raymond Laghaeian

Introduction to Azure HDInsight and Visual Studio customizations, Matt Winkler

Just in Time Data Analytics with SQL Server 2014, Binh Cao and Tomas Polanco

Leveraging SQL Server in Azure Virtual Machines Best Practices, Scott Klein

Life in the fast lane with Azure DocumentDB, Stephen Baron

Making the most of Azure Machine Learning end-to-end, Parmita Mehta

Managing 1 Million+ DBs-How Big Data is used to run SQL Azure, Conor Cunningham

Match the database to the data – from on prem to the cloud, Buck Woody

Microsoft Azure SQL Database – Resource Management, Mine Tokus

Migration and Deployment Principles for SQL Server in Azure VMs, Selcin Turkarslan

Polybase in the Modern Data Warehouse, Artin Avanes

Power BI Hybrid Data Access via Data Management Gateway, Luming Han and Mini Nair

Power View with Analysis Services Multidimensional Models, Kasper de Jonge

Real world Healthcare BI transformations in the cloud, Matt Smith and Michael Wilmot

SQL Server 2014 AlwaysOn (High Availability and Disaster Recovery), Luis Carlos Vargas Herring

SQL Server 2014 in-Memory OLTP – Memory/Storage Monitoring and Troubleshooting, Sunil Agarwal

SQL Server 2014 In-Memory OLTP Query Processing, Jos de Bruijn

SQL Server 2014 In-Memory OLTP Transaction Processing, Jos de Bruijn

SQL Server 2014: In-Memory Overview, Kevin Farlee

SQL Server Hybrid Features End to End, Xin Jin

SQL Server in Azure VM Roadmap, Luis Carlos Vargas Herring

To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT, Jimmy May

Upgrading and Migrating SQL Server, John Martin

What's New in Microsoft Power Query for Excel, Miguel Llopis

Who Dunnit? A Walk Around the SQL Server 2014 Audit Feature, Timothy McAliley and Michael Ray


Still want more? No problem. Check back November 5th for additional sessions and speakers.

Only 28 More days until PASS Summit. You won’t want to miss it!

Repost for 2014: Come to the PASS Summit

I originally posted this five years ago. It’s about my first PASS Summit ten years ago. I’ve made a couple edits and added some links. I hope it will encourage you to attend the PASS Summit 2014. :{> "What’s the big deal about the PASS Summit, Andy?" Allow me tell my story (again): "Hello. My name is Andy Leonard, and I am an accidental database professional." ("Hi Andy.") I jumped the fence from applications developer to database person in 2003. I thought I understood…(read more)

3 reasons to get certified at PASS Summit 2014!

PASS Summit 2014 is right around the corner!  Register by September 26th 2014 to take advantage of the PASS Summit discounted pricing.  PASS Summit is not only a great opportunity to attend the highest rated technical sessions but it’s also one of the best times to get certified.

Why should you get certified at PASS Summit 2014?

1. Certifications help grow your career

With Microsoft Training and Certification you can keep your skills relevant, applicable, and competitive, and with the Certification Central onsite at PASS Summit, you’ll have the chance to learn, practice, and even talk one-on-one with the training experts on a variety of technologies. Microsoft Certification is an industry standard recognized worldwide.

2. Only PASS Summit attendees get special pricing

All Microsoft certification exams will be offered at 50% off the regular price to registered PASS Summit attendees! Take advantage of this great opportunity to fulfill your certification requirements at a 50% discount during PASS Summit 2014. This opportunity is only available to registered PASS Summit 2014 attendees – at just $75 USD per exam, it’s like getting two exams for the price of one.   

3. Free exam prep sessions and practice test only at PASS Summit


In order to secure your desired testing timeslot, pre-registering for your exams is always preferred – but of course you can register for your exams onsite. Visit us at Certification Central to find out which exams and certification paths are right for you, and register to take an exam.


Not sure you’re ready for that exam yet? Come over to The Study Hall, a dedicated, quiet environment where you can study on your own, take a FREE Practice Test, and select from hundreds of on-demand training.


Join us for a brand new kind of introductory certification session at PASS Summit. Updated from the original Certification 101 session, we’ll help you navigate through the new certifications, the new question types introduced in 2012 and 2013, the migration paths for individuals already certified, and the benefits of certification in your career. Want to get certified?  This is the place to start!


Get ready for your next certification test with these interactive study groups led by MCT Ambassadors onsite at PASS Summit. Your leaders will guide you through the most desired exams to ensure you’re prepared. Check the event session guide for exact dates and times – if you’re planning to take an exam, make sure you fit these into your week!


You don’t have to miss sessions or the parties – Wednesday, November 5th will host extended exam hours. The Exam Room and Study Hall will be open until 8pm on Wed night.  Space will be limited.



Certification Testing Center Hours:

Study Hall/Information Desk Hours:

Exam Prep Sessions

*subject to change




 No Exams











10:15 AM – 11:30 PM

Microsoft Certification and Your Career

1:00 PM – 2:45 PM

Exam Prep session for Exam 70-410, 70-411, 70-412 – MCSA: Windows Server 2012 

3:00 PM – 4:15 PM

Exam Prep session for Exam 70-461 – MCSA: SQL Server 2012




10:15 AM-8:00 PM



10:15 AM-8:00 PM



10:15 AM – 12:00 PM

Exam Prep session for Exam 70-410, 70-411, 70-412 – MCSA: Windows Server 2012

1:30 PM – 2:45 PM

Exam Prep session for Exam 70-462 – MCSA: SQL Server 2012

3:00 PM – 4:15 PM

Exam Prep session for Exam 70-463 – MCSA: SQL Server 2012




10:15 AM-6:00 PM



10:15 AM-6:00 PM



10:15 AM – 11:45 AM

Exam Prep Session for Exam 70-483: Programming in C#

1:30 AM – 2:45 PM

Exam Prep session for Exam 70-464 and 70-465 – MCSE: Data Platform

3:00 AM – 4:15 PM

Exam Prep session for Exam 70-466 and 70-467 – MCSE: Business Intelligence



10:30 AM-5:30 PM


 10:30 AM-5:30 PM


8:00 AM – 9:30 AM

Exam Prep session for Exam 70-461 – MCSA: SQL Server 2012 (Repeat)

9:45 AM – 11:15 AM

Exam Prep session for Exam 70-331 and 70-332 – SharePoint Server 2013

Don’t wait to register for your preferred exam time at PASS Summit 2014!   Follow these simple step-by-step instructions.

  1. Start your registration here with Pearson VUE
  2. Click:  Register for an exam
  3. Select  the exam you would like to take
  4. Click:  "Schedule with Pearson VUE"
  5. Confirm personal information and Select:  Submit
  6. Select:  "I will be scheduling for a future date at a test center"
  7. Click:  Next
  8. Select Language (if applicable)
  9. Verify Exam Details
  10. Click:  "Schedule this Exam"
  11. Select Test Center:  Microsoft Event Test Center
    Note:  You may need to search for: Seattle Washington first
  12. Click:  Next
  13. Select Date and Time
  14. Verify Exam order details
  15. Click:  Proceed to Checkout
  16. Verify Personal Information
  17. Click:  Next
  18. Select:  Microsoft Policies box
  19. Click:  Next
  20. Click:  "Add Voucher or Promo Code"
  21. Add promo code:  sqlpass
  22. Click:  Next
  23. Click:  Submit Order
  24. Click:  Return Home


2014 winners: 24 Hours of PASS

Thank you to everyone who took the time to enter the contest #pass24hop Challenge!  As always, we had a great time listening to such passionate community speakers.

Congratulations to all the winners!  You will be notified via a Direct Message (DM) with details on how to redeem your free Microsoft Certification Exam.

So without further ado, the winners are……

Session #1

Taiob Alia @SQLTaiob correctly answered the question: “What did N.U.S.E stand for?” posed by Brent Ozar who conducted the “Who Needs a DBA??”

Webcast Link:

Session #2

John Fewer @johnfewer correctly answered the question: “What is the default buffer size for SSIS pipelines?” posed by Brian Knight who conducted the “Performance Tuning SQL Server Integration Services”.

Webcast Link:

Session #3

Yang Shuai @shuaiyang correctly answered the question: “If it was required, what is the type of witness for quorum that would be used if using standalone instances of SQL Server in an availability group?” posed by Allan Hirt who conducted the “Availability Groups vs Failover Cluster Instances: What’s the Difference?

Webcast Link:

Session #4

Mike Cornell @DataMic correctly answered the question: “In the UPDATE demo, what city does John Smith move to?” posed by Kalen Delaney who conducted the “In-Memory OLTP Internals: How is a 30x Performance Boost Possible?”

Webcast Link:

Session #5

John Ludvig Brattas @intolerance correctly answered the question: “How many relationships can you define between two tables in Tabular?” posed by Marco Russo who conducted the “Create your first SSAS Tabular Model”.

Webcast Link:

Session #6

Sergio Pacheco @Sergmis correctly answered the question: “Using XE, how can you determine the number of times a query was executed during a specific timeframe?” posed by Erin Stellato and Jonathan Kehayias who conducted the “Everything You Never Wanted to Know about Extended Events”.

Webcast Link:

Session #7

The listeners were stumped on the question: “Who are the complainer hotel guests from the demo? What show are they from?” posed by Hope Foley who conducted the “Spatial Data: Looking Outside the Map”.

Webcast Link:

Session #8

The listeners were stumped on the question: “Without stats, what will the row estimation be for an equality predicate?” posed by Gail Shaw who conducted the “Guessing Games: Statistics, Heuristics, and Row Estimations”.

Webcast Link:

Session #9

@fja correctly answered the question: “What is the name of the executable that ships with SQL Server that can be used to collect diagnostic information?” posed by Tim Chapman and Denzil Ribeiro who conducted the “Troubleshoot Customer Performance Problems Like a Microsoft Engineer”

Webcast Link:

Session #10

Andrea Allred @RoyalSQL correctly answered the question: “What technology should you think about when you get a requirement to encrypt data on the fly?” posed by Argenis Fernandez who conducted the “Secure Your SQL Server Instance without Changing Any Code”.

Webcast Link:

Session #11

Theresa Iserman @Theresalserman correctly answered the question: “What are the 4 C’s of Hiring?”  posed by Joe Webb who conducted the “Hiring the Right People: Interviewing and Selecting the Right Team”.

Webcast Link:

Session #12

Andy Pho @andycsuf correctly answered the question:  “Why does Chris (@SQLShaw) recommend database mirroring as his primary technology choice to upgrade SQL Server?” posed by Chris Shaw and John Morehouse who conducted the “Real World SQL 2014 Migration Path Decisions”.

Webcast Link:

Session #13

Stephen Radford @stephen_radford correctly answered the question: “What are the first two cmdlets you should learn, when learning PowerShell?” posed by Robert Cain, Bradley Ball and Jason Strate who conducted the " Zero to Hero with PowerShell and SQL Server”.

Webcast Link:

Session #14

Mark Holmes @SQLJuJu correctly answered the question: “Which Excel data mining add-in offers functionality for the entire data mining lifecycle?” posed by Peter Myers who conducted the “Past to Future: Self-service Forecasting with Microsoft BI”

Webcast Link:

Session #15

P K Towett @pthepebble correctly answered the question: “SQL Server 2014 adds one piece of functionality to statistics maintenance, what is it?” posed by Grant Fritchey who conducted the “Query Performance Tuning in SQL Server 2014”.

Webcast Link:

Session #16

Allen Smith @cognitivebi correctly answered the question: “What is your first mission when trying to determine if indexes help or hurt you?” posed by Jes Borland who conducted the “Are your Indexes Hurting you or Helping You?”

Webcast Link:

Session #17

Andre Ranieri @sqlinseattle correctly answered the question: “What behavior is sometimes called 'the king of irreplaceable behaviors'?” posed by Kevin Kline who conducted the “Techniques to Fireproof Your IT Career”.

Webcast Link:

Session #18

Ginger Grant @DesertisleSQL correctly answered the question: “In what part of a predictive analytics project to people typically spend 60-80% of their time?” posed by Carlos Bossy who conducted the “Predictive Analytics in the Enterprise”.

Webcast Link:

Session #19

The listeners were stumped on the question: correctly answered the question: “What WSMan feature do you need to set up on your client system to remote to Azure VMs?” posed by Allen White who conducted the “Manage Both On-Prem and Azure Databases with PowerShell?”

Webcast Link:

Session #20

@wBob_uk correctly answered the question: “What is the name of the base theme used in the Adventure Works Power View demo today?” posed by Julie Koesmarno who conducted the “I Want It NOW!" Data Visualization with Power View”.

Webcast Link:

Session #21

Conan Farrell @SQL_Dub correctly answered the question: “What is the "mantra" for engineering a DWH solution?” posed by Davide Mauri who conducted the “Agile Data Warehousing: Start to Finish”.

Webcast Link:

Session #22

Nicky @ ADA @NickyvV correctly answered the question: “Which DAX function lets you access columns in other tables?” posed by Alberto Ferrari who conducted the “DAX Formulas in action”.

Webcast Link:

Session #23

Regis Baccaro @regbac correctly answered the question: “What R package do you need to use to connect R and PowerBI?” posed by Jen Stirrup who conducted the “Business Intelligence Toolkit Overview: Microsoft Power BI & R”.

Webcast Link:

Session #24

Anil Maharjan @Anil_Maharjan correctly answered the question: “Can the SSRS databases be clustered?” posed by Ryan Adams who conducted the “SQL Server AlwaysOn Quickstart”.

Webcast Link:


This is just a taste of what you can expect from PASS Summit 2014. To ensure you have a seat, register today at PASS Summit 2014 registration page.  

PASS Summit 2014 – Don’t miss the largest conference for SQL Server Professionals

Do you have the “Data Gene”? 

Preparations for PASS Summit 2014 in Seattle, Washington are well underway.  We are very excited to have this year’s event back in Seattle and look forward to bringing you some great sessions and activities throughout the event.    

Tune in to this week’s TechNet Radio special to listen to Jennifer Moser, Lara Rubbelke, Ann Bachrach and SQL RockStar, Thomas LaRock talk about the “data gene” and why you don’t want to miss this year’s event.

Don’t procrastinate, get registered for PASS Summit 2014!