SQL Server Radio

Download Episode (mp3)

We have a different show this time - in which we play a game!

On each round, as in the famous Scattergories game, we draw a SQL Server-related term and have to tell an interesting story about it.

Along the way, we cover quite a few topics and situations we've been to in our careers, like the time a job ran for 14 hours, and the time a job didn't finish at all.

At the end, both of us got 1 million points. Listen to know how.

We have a different show this time – in which we play a game!

On each round, as in the famous Scattergories game, we draw a SQL Server-related term and have to tell an interesting story about it.

Along the way, we cover quite a few topics and situations we've been to in our careers, like the time a job ran for 14 hours, and the time a job didn't finish at all.

At the end, both of us got 1 million points. Listen to know how.

Download Episode (mp3)

On this show, we host Niko Neugebauer, a.k.a "Mr Columnstore"!.

On this very fun conversation, we talk to Niko about his various roles and activities, about the improvements Microsoft is making version after version, about SQL Server 2016, and of course, about Columnstore.

Among other topics, we cover:

* What people need to know about Columnstore

* How to use Columnstore the right way

* Columnstore and In-Memory OLTP improvements in SQL Server 2016

 

About Niko

Niko Neugebauer is a Software Designer, living in Portugal.

In the recent years he's being fascinated by data (big and small) and its analysis.

Niko also likes to write about Clustered Columnstore Indexes and SQL Server.

Niko founded and leads the Portuguese SQL Server User Group , and he's the head of the organization committee for the SQLSaturday events in Portugal.

He works as a BI Consultant for OH22, where he creates intelligent solutions for Business with a focus on Data Quality.

Niko presents on the topics of Microsoft Data Platform around the world at SQLSaturdays, SQLBits, PASS Summit, User Groups and local events such as Microsoft BI Conference in Portugal.

He loves the human-computer interaction, and adores design, but most of all – he enjoys making technology to make life easier, and people more connected with each other.

LinkedIn: http://www.linkedin.com/in/webcaravela

Twitter: http://twitter.com/NikoNeugebauer

On this show, we host Niko Neugebauer, a.k.a "Mr Columnstore"!.

On this very fun conversation, we talk to Niko about his various roles and activities, about the improvements Microsoft is making version after version, about SQL Server 2016, and of course, about Columnstore.

Among other topics, we cover:

• What people need to know about Columnstore
• How to use Columnstore the right way
• Columnstore and In-Memory OLTP improvements in SQL Server 2016

About Niko

Niko Neugebauer is a Software Designer, living in Portugal.

In the recent years he's being fascinated by data (big and small) and its analysis.

Niko also likes to write about Clustered Columnstore Indexes and SQL Server.

Niko founded and leads the Portuguese SQL Server User Group , and he's the head of the organization committee for the SQLSaturday events in Portugal.

He works as a BI Consultant for OH22, where he creates intelligent solutions for Business with a focus on Data Quality.

Niko presents on the topics of Microsoft Data Platform around the world at SQLSaturdays, SQLBits, PASS Summit, User Groups and local events such as Microsoft BI Conference in Portugal.

He loves the human-computer interaction, and adores design, but most of all – he enjoys making technology to make life easier, and people more connected with each other.

LinkedIn: http://www.linkedin.com/in/webcaravela Twitter: http://twitter.com/NikoNeugebauer

Download Episode (mp3)

We start show 21 with some inspiring quote competition (and ending with some as well).

During the show, we talk about:

* Index rebuilds and fragmentation

* How efficient Columnstore is in terms of IO

* Debugging stored procedures

* Uses for Log Shipping and why it's still relevant

* Solving latch problems

* And more..

Items mentioned in the show:

* Niko Neugebauer - Columnstore IO

* Guy Glatnser - Debug Managed Code and Stored Procedures Seamlessly

* Matan Yungman - Can Log Shipping Work Without Shipping the Log?

* Matan Yungman - How to Fix Latch Problems when Working with Ascending Keys in SQL Server

We start show 21 with some inspiring quote competition (and ending with some as well).

During the show, we talk about:

• Index rebuilds and fragmentation
• How efficient Columnstore is in terms of IO
• Debugging stored procedures
• Uses for Log Shipping and why it's still relevant
• Solving latch problems
• And more..

Items mentioned in the show:

• Niko Neugebauer – Columnstore IO

Download Episode (mp3)

It seems like ages ago, but we had a pretty busy month on March, with lots of conferences and great time. We start the show by summarizing March Madness, with the presentations, the people, the parties and the food.

We then talk about:

* Things to take into account when upgrading to SQL Server 2014 and when installing a new server

* Windows Azure SQL Database backup options and new online features

* Cloud adoption considerations

* The top 10 presentations from PASS summit 2014

* And more..

Items mentioned in the show:

* Guy shares the holiday spirit at SQLRally Nordic 2015

* Top 10 sessions of PASS Summit 2014

* Azure SQL Database Backup and Restore

* Aaron Bertrand - More Azure SQL Database Online Operations

* SQL Server 2014 Upgrade Technical Guide

It seems like ages ago, but we had a pretty busy month on March, with lots of conferences and great time. We start the show by summarizing March Madness, with the presentations, the people, the parties and the food.

We then talk about:

• Things to take into account when upgrading to SQL Server 2014 and when installing a new server
• Windows Azure SQL Database backup options and new online features
• Cloud adoption considerations
• The top 10 presentations from PASS summit 2014
• And more..

Items mentioned in the show:

• Guy shares the holiday spirit at SQLRally Nordic 2015
• Top 10 sessions of PASS Summit 2014
• Azure SQL Database Backup and Restore
• Aaron Bertrand – More Azure SQL Database Online Operations
• SQL Server 2014 Upgrade Technical Guide

Download Episode (mp3)

Show 19 was recorded at the SQLBits conference in London, where we had the pleasure to interview PASS President, Thomas LaRock (blog | twitter).

We talk to Tom about his long time volunteering at PASS and about his current role as the president of the organization.

Among other topics, we cover:

* What does it mean to be PASS president?

* What's the path to being on the board of directors?

* How does Tom manage to balance between his job at Solarwinds, his role at PASS and his family?

* How did 24 Hours of PASS come to the world?

* What is PASS Summer Camp?

* And more..

About Tom:

Tom LaRock works as a Head Geek for Solarwinds, where his mission is to give IT and Data Professionals longer weekends.

He also serves as the president of the PASS board of directors.

He's a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and also a Microsoft Certified Trainer. He has over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administration.

Tom is also the author of DBA Survivor: Become a Rock Star DBA and have participated in the technical review of several other books.

Show 19 was recorded at the SQLBits conference in London, where we had the pleasure to interview PASS President, Thomas LaRock (blog | twitter).

We talk to Tom about his long time volunteering at PASS and about his current role as the president of the organization.

Among other topics, we cover:

• What does it mean to be PASS president?
• What's the path to being on the board of directors?
• How does Tom manage to balance between his job at Solarwinds, his role at PASS and his family?
• How did 24 Hours of PASS come to the world?
• What is PASS Summer Camp?
• And more..

About Tom:

Tom LaRock works as a Head Geek for Solarwinds, where his mission is to give IT and Data Professionals longer weekends.

He also serves as the president of the PASS board of directors.

He's a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and also a Microsoft Certified Trainer. He has over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administration.

Tom is also the author of DBA Survivor: Become a Rock Star DBA and have participated in the technical review of several other books.