The Itzik Ben-Gan Trick

Download Episode (mp3)

Itzik Ben-Gan has many T-SQL tricks.

In this show, we talk about a few of them:

  • How to get Batch Mode Processing with regular tables
  • How to share Identity between different tables
  • How to use Cross Apply for Unpivot

In addition, we talk about what SOS_Scheduler_Yield means and answer the question – is it always the DBA’s fault?

If you would like your question to be featured on the show, just head over to SQLServerRadio.com, drop us a line, and we’ll talk about it in one of the upcoming shows.

Items mentioned in the show:

 

If You Need to Think, You’re Doing It Wrong

Download Episode (mp3)


Guy is back from a one month trip in the United States, and we’re back with another show of SQL Server Radio.

In this show, we talk about a few of our upcoming speaking gigs (PASS Summit and SQL Server Days in Belgium), about File-Snapshot backups in SQL Server 2016, about triggers in DB2, SQL Server 2016 CU1, about where to spend your thinking time, and more.

Items mentioned in the show:

 

Data Science with Tomaz Kastrun

Download Episode (mp3)

Data Science is a big deal today, but what is it exactly?

In this show, we talk to Tomaž Kaštrun (blog | twitter) about what Data Science is, what does a Data Scientist do, what insights is he looking for, what tools does he use, what is R, and what R integration in SQL Server 2016 means.

About Tomaž

Tomaž Kaštrun  is BI developer and Analyst with more than 15 years of experience working with MS SQL Server and and 15 years of experiences on statistics and predictive analytics. He is a frequent SQL Server community speaker, blogger, delivering sessions on local user group meetings, PASS or Microsoft related events (PASS, 24HOP, SQLSaturday) and publishing articles related to SQL Server.
He is working for Spar ICS GmbH / Spar Slovenija d.o.o. and is vivid coffee drinker.

Tomaz Kastrun

Show 49 – Presentation Design and More with Boris Hristov

Download Episode (mp3)

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:

About Boris

Boris is the Founder and CEO of Presentation Design and Training Agency 356labs. He has delivered sessions in 25+ countries and has not just once been rated as the top speaker of the event. Boris has numerous years of experience as a trainer and has trained companies like Microsoft and HP in topics like presentation skills and presentation design. The fastest way you can reach him is on Twitter where he writes under .

Boris Hristov

 

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: