תכנית 52 – בלפאסט

לחץ להורדת הקובץ

היום בתכנית:

  • Azure SQL Database Elastic Queries ו-Cross Database Queries
  • פיצ’רים ל-Security ב-Azure
  • האם Azure SQL Database כבר מספיק בשל
  • Actual Number of Rows Read ב-Execution Plans
  • שליטה על Memory Grants ברמת שאילתא
  • שינויים ב-Resource Governor שיכולים להאיץ ביצועים

וגם על ה-Precon שגיא יעביר ב-SQLBits, ומה הקשר בין העיר בלפאסט ל-Database Mirroring.

‘ביג דאטה וכסף באינטרנט עם גיא רפאלוביץ

לחץ להורדת הקובץ

הזכרנו בתכנית פעם או פעמיים את גיא רפאלוביץ’שהשפיע הרבה על הקריירה של גיא.

היום אנחנו מדברים איתו על המון דברים מעניינים.

בין היתר:

  • מה ההבדל בין Ops ל-DevOps
  • מה זה ביג דאטה ומה עושים עם זה
  • איך DBA יכול להתחיל לעבוד עם טכנולוגיות ביג דאטה
  • מה זה Data Scientist ומה הוא עושה
  • למה DBA צריך להבין את ה-Data שיש אצלו במערכות
  • איך עושים כסף באינטרנט

BigData

Show 50 – תכנית היובל

Download Episode (mp3)

It’s our 50th show, and it’s time to celebrate!

In this show, we look back and recap the first 50 shows. among other topics, we talk about:

  • How we started the show
  • How a podcast is made and how we make SQL Server Radio
  • Highlights from the first 50 shows
  • Speculations about the future of SQL Server and the data world
  • The worst feature in the history of SQL Server!

Show 49 – מצעד הבושה

Download Episode (mp3)

Next month is our 50th show!

To celebrate that, we decided to make a countdown of the 30 best features of all times in SQL Server.

But then we realized it would be boring, so we didn’t count from 30 to 1 like regular countdowns.

We count from 1 to 30, meaning we start with the best and count down to the worse and most awful features of all time in SQL Server. Who will be the worst?

Show 48 – צ’יף אחלה אופיסר

Download Episode (mp3)

Show 48 is here!

This time:

  • Our PASS Summit 2015 summary
  • Guy explains why he started his presentation as Superman
  • Performance Dashboard Reports
  • On Resource_Semaphore_Query_Compile waits
  • Why firms hire Chief Data Officers
  • And more..

Items mentioned in the show:

 

 

 

 

Show 47 – Justin Bieber

Download Episode (mp3)

In this show:

  • The new cloud witness
  • How to use digital signatures instead of cross database ownership chaining
  • What do you do when we have SQL Server connectivity issues?
  • Compare execution plans in SQL Server 2016
  • Guy’s SQL Server killer feature
  • How to manage the availability of Azure virtual machines using Availability Sets
  • Profiler – the DBA’s best friend

Show 46 – DBCC OPTIMIZER_WHAT_THE_F***

Download Episode (mp3)

In this show:

  • We congratulated Matan for being awarded as a SQL Server MVP. Go Matan!
  • We talked about the next Israeli SQL Server user group meeting and about the next SQL Saturday in Israel.
  • How to use SSIS to delete files older than a specified number of days?
  • Using OPTIMIZER_WHATIF and StatsStream to simulate a production environment.
  • Is it worth writing unit tests?
  • What is the Clipboard Manager in SSMS?
  • Why we hate indexed views…
  • Some interesting stories about forward-only cursors.
  • Which standup shows will make you laugh until you can’t breathe?

Show 44 – Disk D (fixed)

Download Episode (mp3)

Happy holidays everyone!

On this show, we talk about:

  • Some weird acronyms
  • The right way to move Tempdb files on Azure VMs
  • What is Optimize for Ad-hoc Workload and how it affects the Plan Cache
  • Web analytics and aggregations
  • What to do when a SQL Server instance doesn’t come up

And also Al and Kelly Bundy, Noah, the Pink Floyd, and much more..

Items mentioned in the show:

Show 43 – לא לנתק את הכבל

Download Episode (mp3)

On show 43, we talk about:

  • SQLSaturday Israel 2016!
  • The last and previous user group meetings
  • 24 Hours of PASS, which happens today (September 17)!
  • Matan’s experience from Oslo and travelling to Belgium
  • Row Level Security and why should be careful when using it
  • Optimizing Ad-hoc queries and Azure DocumentDB

We also have some ice cream recommendations and other “important” updates..