SQL Server Radio

Most of us will have to deliver some kind of a presentation in our professional lives, whether it's inside the organization or at a conference. Today, we talk to Boris Hristov (blog | twitter) about this subject.

You might remember Boris from show 26 where we talked to him about Policy Based Management and Distributed Replay, but today he's in a completely different phase.

Boris started a company called 356labs that is targeted at helping speakers deliver better presentations.

During our chat, we cover:

• Why it's important to start presenting, and how to start doing it
• How to correctly deliver a message during a presentation
• What should you ask yourself before delivering a presentation
• Why are images better at delivering a message
• How to start a company and get clients
• Many practical tips for presenting

Items mentioned in the show:

• 356labs.com
• Train the trainer series
• pexels
• pixabay
• fontsquirrel
• freedigitalphotos

Download Episode (mp3)

In this show, we talk about:

The top 100 percent trick and whether or not it works

A weird bug that was solved in SQL Server 2012 SP2

What is SSISDB and an Intersting tip for its maintenance

How to start performance tuning a system

Misconceptions about order

Dynamic search conditions

How to share data between stored procedures

Our favorite sessions from today's 24 Hours of PASS

How to be more productive and scale yourself

And more..

Items mentioned in the show:

Scott Hanselman - Scaling Yourself

Erland Sommarskog's blog

Tim Radney - Tuning: A Good Place to Start

In this show, we talk about:

• The top 100 percent trick and whether or not it works
• A weird bug that was solved in SQL Server 2012 SP2
• What is SSISDB and an Intersting tip for its maintenance
• How to start performance tuning a system
• Misconceptions about order
• Dynamic search conditions
• How to share data between stored procedures
• Our favorite sessions from today's 24 Hours of PASS
• How to be more productive and scale yourself
• And more..

Items mentioned in the show:

• Scott Hanselman - Scaling Yourself
• Erland Sommarskog's blog
• Tim Radney - Tuning: A Good Place to Start

Download Episode (mp3)

Continuing the show from two weeks ago, we have another show with Brent Ozar we recorded when he was in Israel a few weeks ago.

This time, we talk about what a DBA needs to know in order to get a job in this day and age.

What should you know if you're a junior DBA? what should you know if you're a senior DBA? what are some interesting interview questions you might face?

We also spend a few minutes talking about SQL Server on Linux, whether it makes sense, what does it really mean, and what should any SQL Server professional know today.

Items mentioned in the show:

* Brent Ozar - Secret Meeting Minutes for the SQL Server on Linux Decision*

About Brent

Brent Ozar (Blog | Twitter) is the founder and owner of Brent Ozar Unlimited.

Brent loves pushing SQL Server past the speed limit and showing other people how to drive it faster. He enjoys translating between programmers, sysadmins, SAN admins, and project managers. They find the root of the problem quickly, together, and get everyone working towards the same solutions.

For the best conversation in your life, ask him about:

* Microsoft SQL Server performance tuning

* Making kCura Relativity faster

* VMware ESX/vSphere virtualization

* Storage and SANs

* Server hardware

* How Tim Gunn can make it work

Continuing the show from two weeks ago, we have another show with Brent Ozar we recorded when he was in Israel a few weeks ago.

This time, we talk about what a DBA needs to know in order to get a job in this day and age.

What should you know if you're a junior DBA? what should you know if you're a senior DBA? what are some interesting interview questions you might face?

We also spend a few minutes talking about SQL Server on Linux, whether it makes sense, what does it really mean, and what should any SQL Server professional know today.

Items mentioned in the show:

• Brent Ozar - Secret Meeting Minutes for the SQL Server on Linux Decision*

About Brent

Brent Ozar (Blog | Twitter) is the founder and owner of Brent Ozar Unlimited.

Brent loves pushing SQL Server past the speed limit and showing other people how to drive it faster. He enjoys translating between programmers, sysadmins, SAN admins, and project managers. They find the root of the problem quickly, together, and get everyone working towards the same solutions. For the best conversation in your life, ask him about:

• Microsoft SQL Server performance tuning
• Making kCura Relativity faster
• VMware ESX/vSphere virtualization
• Storage and SANs
• Server hardware
• How Tim Gunn can make it work

Download Episode (mp3)

A few weeks ago, Brent Ozar flew over to Israel for SQLSatursday, so we took the opportunity to get together and have a fun conversation about his and ours favorite mistakes.

Among other mistakes, we talk about:

* How did a company end up with a table named "C"

* Brent's first database disaster ever

* Why Guy spent two weeks in Microsoft Belfast

* Fire in the data center

* How does a manager need to respond during a crisis

* How should you react when you mess up

 

About Brent

Brent Ozar (Blog | Twitter) is the founder and owner of Brent Ozar Unlimited.

Brent loves pushing SQL Server past the speed limit and showing other people how to drive it faster. He enjoys translating between programmers, sysadmins, SAN admins, and project managers. They find the root of the problem quickly, together, and get everyone working towards the same solutions.

For the best conversation in your life, ask him about:

* Microsoft SQL Server performance tuning

* Making kCura Relativity faster

* VMware ESX/vSphere virtualization

* Storage and SANs

* Server hardware

* How Tim Gunn can make it work

Download Episode (mp3)

In this show, we talk to Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange.

Lior has many years of experience working with SQL Server, Oracle, .NET, MongoDB, Cassandra, and much more. We discuss the challenges and the MANY database systems that ICE works with.

Among other topics, we talk to Lior about:

* What happens under the hood when someone buys a stock

* How Lior's team integrates the many data systems for providing a full solution

* How ICE use SQL Server Replication for synchronizing data around the world

* What Lior is looking for in SQL Server 2016

About Lior

Lior King is carrying more than 25 years of experience in the IT world.

His main expertise is database systems (SQL Server and Oracle), database programming, data access layers using .NET and NoSQL solutions (MongoDB, Cassandra and Hadoop).

He started as a developer in the army (MAMRAM graduate) then a DBA, a team leader, a software architect and consulting group manager.

He's always seeking to improve my skills as a technology professional as well as my managerial and business skills.

His specialties are SQL Server and Oracle database administration, architecture and programming, Dot Net framework programming, software infrastructure design, the Hadoop platform and NoSQL solutions.

In this show, we talk to Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange.

Lior has many years of experience working with SQL Server, Oracle, .NET, MongoDB, Cassandra, and much more. We discuss the challenges and the MANY database systems that ICE works with.

Among other topics, we talk to Lior about:

• What happens under the hood when someone buys a stock
• How Lior's team integrates the many data systems for providing a full solution
• How ICE use SQL Server Replication for synchronizing data around the world
• What Lior is looking for in SQL Server 2016

About Lior

Lior King is carrying more than 25 years of experience in the IT world.

His main expertise is database systems (SQL Server and Oracle), database programming, data access layers using .NET and NoSQL solutions (MongoDB, Cassandra and Hadoop).

He started as a developer in the army (MAMRAM graduate) then a DBA, a team leader, a software architect and consulting group manager.

He's always seeking to improve my skills as a technology professional as well as my managerial and business skills.

His specialties are SQL Server and Oracle database administration, architecture and programming, Dot Net framework programming, software infrastructure design, the Hadoop platform and NoSQL solutions.

Download Episode (mp3)

Did you know SSMS can make sounds?

We start the show with some interesting things you might do with this option.

In addition, we talk about:

* SQL Server on Linux

* Hadoop fundamentals

* SQL Server 2016 eBook

* Changes to auto update statistics in SQL Server 2016

* New SQL Server 2016 database level configurations

* Distributed Availability Groups - what is it and use cases

* How AWS storage works

* Composite indexes

* Plan Cache issues

Items mentioned in the show:

* Guy Glantser - Hadoop Fundamentals

* Denny Cherry - How to make SSMS beep when a query is done?

* Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2

* Erik Darling - Changes to auto update stats thresholds in SQL Server 2016

* Brent Ozar - SQL Server 2016: The Death of the Trace Flag

* Distributed Availability Groups