Show 48 – Pomodoro

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:

Show 47 – How to Find a DBA Job with Brent Ozar

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:

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

Brent_Ozar_2016_Large

Show 46 – Big Mistakes with Brent Ozar

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

Brent_Ozar_2016_Large

 

 

Show 45 – Managing the New York Stock Exchange with Lior King

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.

Lior King

Show 44 – SSMS Can Beep

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:

Show 42 – Database Testing and Continuous Integration with Steve Jones

Download Episode (mp3)

In today’s world where deployments to production are very frequent, continuous integration and testing code become more important than ever.

In this show, we talk to Steve Jones (Blog | Twitter), the editor of SQLServerCentral.com about how to do it.

Among other topics, we talk to Steve about:

  • His work at SQLServerCentral and his favorite parts over the years
  • What he’s looking for in SQL Server 2016
  • What is continuous integration and how it can be done with SQL Server
  • How to test your database code before it gets to production
  • Data Quality Services and Master Data Services

Items mentioned in the show:

About Steve

Steve has been working with SQL Server since 1991, when he became the accidental DBA for a SQL Server v4.2 system running on OS/2 1.3.
Since that time Steve has worked with all versions of SQL Server at various jobs.

In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners that were bought out the next year. In 2002, Steve left his job with Peoplesoft to manage SQLServerCentral full time as editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Red Gate Software along with Database Weekly (then Database Daily). At that time Steve went to work for Red Gate and has continued his work with SQLServerCentral and Red Gate since that time.

Steve regularly speaks at SQL Saturday and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. If you are interested in inviting him come speak at your event, please feel free to contact him through email, Twitter, or Facebook. You can also get the text of his keynote talks.

Steve was first awarded the Microsoft MVP award in 2008 and has been renewed 3 times for his many contributions to the community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server. He also has an undergraduate degree from the University of Virginia in Economics.

Steve Jones