Download Episode (mp3)

On this show, which is recorded in Seattle, we share our plans, schedules, thoughts and hopes for Pass Summit 2014.

We focus on the schedule each one of us has built for the summit and reflect our thoughts about how the topics of those sessions can help all of us in our day-to-day jobs.

We also discuss if and how the agenda fits the current Microsoft strategy.

Download Episode (mp3)

It's show 24, and guess what - we have a guest again: Asaf Aviv!

Asaf is very much into SQL Server Scale-Out solutions and SQL Server Replication, and not surprisingly, we take a VERY deep dive into those subjects (get ready for a lot of pro tips).

In addition, we talk about the history of Asaf as a rock star, about guitars and how they are related to SQL Server, and about a very weird issue Guy had with a motorcycle...

Download Episode (mp3)

This is the monthly all-over-the-place edition of our show. As usual, we cover a lot of issues we encountered the past month, interesting blog posts, tips, tricks, events and random thoughts.

Among other topics, we talk about:

A weird scenario with backups, and the difference between Backupset and Mediaset

A weird scenario with a procedure ran 150 times a second

Visualization of DBCC SHOWSTATISTICS in SSMS

Various New Azure templates

Scenarios for In-Memory OLTP

Presentation skills

And more..

Items mentioned in the show:

Maria Zakourdaev - Using Google Charts API to Visualize Schema Changes

Mark Wiklinson - Visualizing Statistics in SSMS

New Optimized OLTP and Data Warehousing SQL Server Images on Azure

SQLSaturday Israel

24 Hours of Pass Summit Preview Edition

Julie Koesmarno - I Want It NOW!" Data Visualization with Power View

24 Hours of Pass SQL Server 2014 Edition

Sunil Agarwal - SQL Server 2014: In-Memory OLTP for Database Administrators

Sunil Agarwal - Columnstore Technical Deep Dive

Jimmy May - Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit

Download Episode (mp3)

On show 22, we talk about career management.

We actually recorded this show a few months ago, but it might be the best and most important show we've had.

We talk about about our careers: How we got to be DBAs, how we progressed, our difficulties, what steps took us forward, what processes we went through, and how getting involved in the community has helped us.

Furthermore, we talk about:

Why consistent learning is so important

How blogging and public speaking can help you

Why it's important to have a mentor

How Guy started his own company

Time management tips

And how are candies related to Guy's career?

Let us know what you think about career management in the DBA world. We would love to hear what you think!

Download Episode (mp3)

On show 21, we have a guest again - Noam Binyamini, Senior Support Engineer at Microsoft.

We talk with Noam about his job, about interesting incidents he encountered, common mistakes customers make, and about the importance of installing service pack and cumulative updates.

Later on, we talk about the massive investments Microsoft puts into the cloud, the right scenarios to work with the cloud, and the maturity of Microsoft Azure SQL Database (formerly SQL Azure).

Download Episode (mp3)

On show 20, we talk about High Availability.

We start with talking about the distinction between High Availability and Disaster Recovery. Then, we talk about the importance of having a RESTORE strategy rather than a backup strategy.

After that, we talk about the various High Availability/Disaster Recovery technologies: AlwaysOn Failover Cluster Instances, Log Shipping, Database Mirroring and AlwaysOn Availability Groups. We talk about the specifics and capabilities of each technology, in which editions its supported and its pros and cons.

We're back from our trips, and on show 19, we juggle around a few topics.

We talk about super indexes, trivial plans and whether they're the best choice, Dynamic SQL and automatic code, Replication, a hidden and yet important property of Failover Clusters, and more..

Also, Matan declares that User Defined Functions need to be wiped out. Listen to hear why!

Links mentioned in the show:

Super Index

Kendal Van Dyke - Troubleshooting Transactional Replication

Eitan Blumin - Let SQL Server Write Code for You

Avi Niv - Generating Email Reports Using XML

Michael J Swart - Trivia about Trivial Plans

Paul White - Forcing a Parallel Query Execution Plan

Guy Glantser - How to Use Parameters Like a Pro and Boost Performance

Modifying Clustered Service Settings

Global Hebrew Virtual Chapter August Meeting

Israeli SQL Server User Group Meeting #145

On show 18, we talk a lot about the "Balagan" around the Pass Summit session selection process and around the last 24 Hours of Pass.

We also talk about certifications, Guy's trips in Bnei-Brak, courses, what are number tables and why you need them, what we love about SQL Server, a strange problem with mirroring, and more..

Links mentioned in the show:

Brent Ozar - Fast-Checking the 24 Hours of Pass

Guy Glantser - What I Love About SQL Server

ASK FAQ - Why Should I Consider Using an Auxiliary Numbers Table?

Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part 1)

Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part 2)

On our 17th show, we have updated about two major issues discussed on the previous show - Guy's running status and the post office.

We also talk about wait types, a new trace flag, memory estimates in SQL Server 2014, data loss bug, events, and much more..

Items mentioned in the show:

Next user group meeting

Thomas LaRock - ESTIMATING MEMORY REQUIREMENTS IN SQL SERVER 2014

Aaron Bertrand - New Trace Flag to Fix Table Variable Performance

Aaron Bertrand - Fixes for SQL Server 2012 & 2014 Online Index Rebuild Issue

SP_SERVER_DIAGNOSTICS_SLEEP Wait Type

Paul Randal - Wait statistics, or please tell me where it hurts

After a long time, we have a guest again - Shy Engelberg from HYNT!

We had a great conversation that spanned a lot of subjects. Among other topics, we talked about Microsoft and Google, Views and bad plans, Hekaton best practices, good and bad features, the life of the consultant, how Shy is doing in his new adventure, and about the professionals who influenced us the most.