High Performance Analytics with Sunil Agarwal

At Microsoft Ignite 2017, I had planned an interview with Sunil Agarwal, and was very excited about it. Then Sunil asked if he could bring Kevin Farlee. Of course! Then he asked if he could also bring their customer, Aaron Gerdeman from FIS. Even better! :)

In this interview, we chat about SQL Server 2017, Resumable Index Builds, Adaptive Query Processing, Columnstore Indexes, High Availability, Real-time Analytics, Real-time Dashboards and the SQL Tiger Team.

High Performance Analytics with Sunil Agarwal, Kevin Farlee, Aaron Gerdeman

You can learn more in the SQL Server Database Engine Blog, follow Sunil Agarwal on Twitter @S_u_n_e_e_l and follow Kevin Farlee on Twitter @kfarlee.

I’m very happy they all managed to find time to talk to me, hope you enjoy the interview! To learn more, watch Sunil and Aaron’s session Delivering high performance analytics with columnstore index on traditional DW and HTAP workloads from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
SQL Server 2017 with Bob Ward
Azure Data Factory v2 with Mike Flasko

SQL Server 2017 with Bob Ward

During Microsoft Ignite 2017, I got to interview one of the nicest guys in Microsoft, Bob Ward! :)

In this interview, we chat about SQL Server 2017, SQL Server on Linux, Adaptive Query Processing, Auto Plan Correction and Columnstore Indexes.

SQL Server 2017 with Bob Ward – Microsoft Ignite 2017

You can read all of Bob Ward’s articles on his blog SQL Server According to Bob. Most of his slide decks and demos are published on aka.ms/bobwardms, and you can follow him on Twitter @bobwardms.

I know Bob had a very busy schedule at Microsoft Ignite, so I’m very thankful he was able to spend a few minutes with me! I hope you find this as interesting as I did :) If you want to learn even more, you can watch his session Experience Microsoft SQL Server 2017: The fast and the furious from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
High Performance Analytics with Sunil Agarwal
Azure Data Factory v2 with Mike Flasko

Data Science with Buck Woody

I got to interview Buck Woody about Data Science at Microsoft Ignite 2017! :)

In this interview, we chat about Microsoft Business Analytics and AI (formerly known as Cortana Intelligence Suite), Artificial Intelligence in Excel, intent-based programming, Predictive Analytics, DevOps for Data Scientists and life-long learning.

Data Science with Buck Woody – Microsoft Ignite 2017

Read all of Buck Woody’s great posts on his blog Backyard Data Science and follow him on Twitter @BuckWoodyMSFT. For more career advice, read his article Your Career is Your Fault on LinkedIn.

Oh, and we did get more coffee after we recorded this :)

I’m so thankful that Buck took some time out of his busy schedule to chat with me, and I hope all of you enjoy this interview. If you want to learn more, watch his full session DevOps for data science from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

SQL Server 2017 with Bob Ward
High Performance Analytics with Sunil Agarwal
Azure Data Factory v2 with Mike Flasko

The Biml Book is here!

Cathrine Wilhelmsen Co-Authored The Biml BookWoohoo! The Biml Book: Business Intelligence and Data Warehouse Automation is now available for pre-order from Amazon and Apress! :D

This is the first book I’ve co-authored, and I have to admit it’s a very strange feeling to see my name on the cover of a book. Am I allowed to say I’m quite proud? Oh, I’ll say it anyway. I’m proud and very honored to have written this book with such a talented group of people: Andy Leonard (@AndyLeonard), Scott Currie (@scottcurrie), Ben Weissman (@bweissman), Bill Fellows (@billinkc), Martin Andersson (@frysdisken), Peter Avenant (@PeterAvenant), Simon Peck (@biguynz), Reeves Smith (@SQLReeves), Raymond Sondak (@raymondsondak) and Jacob Alley.

What’s in The Biml Book?

The first part of the book starts with the basics: getting your development environment configured, Biml syntax, and scripting essentials.

The next part of the book guides you through the process of using Biml to build a framework that captures both your design patterns and execution management. In addition to leveraging design patterns in your framework, you will learn how to build a robust metadata store and how to package your framework into Biml bundles for deployment within your enterprise.

In the last part of the book, you will learn more advanced Biml features and capabilities, such as SSAS development, T-SQL recipes, automated documentation, and Biml troubleshooting.

When can I get The Biml Book?

Amazon says early December, but it might be available sooner. If you don’t want to wait, you can pre-order The Biml Book from Amazon or Apress right now.

Yay! This has been a long journey, and I’m so happy the other guys let me be a part of it :)

Speaking at SQLSaturday Denver 2017

Cathrine Wilhelmsen Speaking at SQLSaturday Denver 2017

On Saturday, September 16th, I’m speaking at SQLSaturday Denver 2017! I’m presenting my Level Up Your Biml: Best Practices and Coding Techniques session: Learn how to centralize and reuse code with include files and the CallBimlScript methods. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Since I last presented this session, BimlExpress 2017 has been released with a bunch of new features. I have updated my session to include some of these new features, and I’m looking forward to presenting with the new preview expanded Biml pane. Being able to see the expanded Biml is hopefully going to make it a lot easier for me to explain some of these things and for attendees to follow along :)

If you really like Biml, check out the three other Biml sessions at SQLSaturday Denver: Biml 101: Automation and Patterns by Yuliya Quintela, Stop Repeating Yourself – Automating Azure Data Movement With BimlScript by Levi Syck (@levisyck), and Metadata driven development by Bill Fellows (@billinkc).

Will you be attending SQLSaturday Denver? Come and say hi when you see me! :)

Page 2 of 25 1 2 3 4 5 ...10 20 ...Last »