Sql Server

  • Author: Vรกrios
  • Narrator: Vรกrios
  • Publisher: Podcast
  • Duration: 83:10:09
  • More information

Informaรงรตes:

Synopsis

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the SQL Server platform. The show is intended to add another platform of knowledge sharing to the already strong Israeli SQL Server community.

Episodes

  • ืžื›ื•ืคืฃ ื”ื‘ื ื ื•ืช

    01/06/2017 Duration: 33min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ืžื™ ื–ื” KillaDBA ืœืžื” ืื™ ืืคืฉืจ ืœืฉืžื•ืจ ืชืืจื™ื›ื™ื ืžืœืคื ื™ ืฉื ืช 1653 ื”ืžืœืฆื•ืช ืœื ื™ื”ื•ืœ ืžืงืคื˜ืŸ ืคื™ืงืืจื“ ื”ื”ืจืฆืื•ืช ืฉืœื ื• ื‘ื›ื ืก GroupBy ืขืœ Lightweight Profiling ื‘-SQL Server 2016 SP1

  • ืื•ืœื™ ืžืกืคื™ืง ืขื ื”ืฉื˜ื•ื™ื•ืช ื”ืืœื” โ€“ ื—ืœืง ืจืืฉื•ืŸ

    04/05/2017 Duration: 39min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื‘ืชื•ื›ื ื™ืช ื–ื• ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ ืžื” ืฉื“ื™ื‘ืจื ื• ื‘ื”ืจืฆืื” ืฉืœื ื• - "ืื•ืœื™ ืžืกืคื™ืง ืขื ื”ืฉื˜ื•ื™ื•ืช ื”ืืœื•"? ื”ืื Parameter Sniffing ื–ื” ื˜ื•ื‘ ืื• ืจืข? ื”ืื ืฆืจื™ืš ืœืขืฉื•ืช Rebuild ืœืื™ื ื“ืงืกื™ื?

  • ืกืžื™ ื•ืกื•ืกื•

    20/04/2017 Duration: 37min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ื‘ื™ืŸ ื”ื™ืชืจ ืขืœ: ื›ื ืก GroupBy ื”ื˜ืจื™ืง ื”ื‘ืขื™ื™ืชื™ ืฉืœ TOP 100 Percent ืžื—ื–ื•ืจ ื—ื™ื™ื ืฉืœ ื˜ื›ื ื•ืœื•ื’ื™ื•ืช ื”ืื ื›ื“ืื™ ื”ื™ื•ื ืœืœืžื•ื“ ืœื”ื™ื•ืช DBA SQLSaturday Israel

  • ืฉืœื’ ื‘ืื™ืกืœื ื“

    06/04/2017 Duration: 28min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ื‘ื™ืŸ ื”ื™ืชืจ ืขืœ: ืื™ืกืœื ื“ ืฉืœื•ืฉืช ื”ื“ื‘ืจื™ื ื”ื›ื™ ื—ืฉื•ื‘ื™ื ื‘ื ื•ื’ืข ืœ-SQL Server ื‘ืขื ืŸ ืฉืืœื•ืช ื—ื•ื‘ื” ืœ-DBA ื‘ืจืื™ื•ืŸ ืขื‘ื•ื“ื” ื”ืืชืจ ื”ื—ื“ืฉ ืฉืœ PASS

  • ื”ื™ื•ืžืœืคโ€ืฉ

    02/03/2017 Duration: 32min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ืงื•ืจืก ื—ื“ืฉ - T-SQL Programming for Developers ืฉืœ ืื™ืชืŸ ื‘ืœื•ืžื™ืŸ ืœืžื” ืงืฉื” ืœืงื•ื ื‘ื‘ื•ืงืจ ื˜ืขื™ื ืช ืžื™ื“ืข ืœืชื•ืš Azure SQL Data Warehouse ื˜ืขื™ื ื” ืžื”ื™ืจื” ืฉืœ ื ืชื•ื ื™ื ื‘ืžืงื‘ื™ืœ ื”ืชื ื’ื“ื•ืช ืœืฉื™ื ื•ื™ื™ื ืกื™ื‘ื•ืช ืœืขื–ื•ื‘ ืขื‘ื•ื“ื” ืœื™ื ืงื™ื ืžื”ืชื•ื›ื ื™ืช: ืœื”ืจืฉืžื” ืœืงื•ืจืก ืฉืœ ืื™ืชืŸ, ืœื—ืฅ ื›ืืŸ ืกืคืจ ืžื•ืžืœืฅ - The Secrets of Consulting

  • sp_configure ืื• sys.configurations

    16/02/2017 Duration: 25min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ ืื•ืคืฆื™ื•ืช ื”ืžืขืจื›ืช ืฉื—ืฉื•ื‘ ืœืฉื™ื ืืœื™ื”ืŸ ืœื‘ ื‘-sp_configure (ืื• ื‘ืฉืžื• ื”ืฉื ื™, sys.configurations)

  • ืงืงื™ ืžื—ื™ื™ืš

    01/02/2017 Duration: 23min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ืฉื™ืคื•ืจื™ื ื‘-Temporal Tables ื‘-SQL Server 2016 SP1 ืื™ืš SQL Server ืขืœ Linux ืขื•ื‘ื“ ื”ืจืฉืื•ืช ื‘-SSIS ื”ืคื™ืฆ'ืจ ื”ื—ื“ืฉ -ย Adaptive Query Plans

  • ืžื–ืœ ื˜ื•ื‘ ืœื’ื™ื

    19/01/2017 Duration: 31min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ืื ื—ื ื• ื—ื•ื’ื’ื™ื ื™ื•ืžื•ืœื“ืช ืœื’ื™ื ืฉื—ื’ื’ ืœืคื ื™ ื—ืžื™ืฉื” ื™ืžื™ื, ื•ื’ื ืžื“ื‘ืจื™ื ืขืœ: ืชืฉื•ื‘ื•ืช ืœืฉืืœื•ืช ื ืคื•ืฆื•ืช ืขืœย SQL Server ืžื” ื—ืฉื•ื‘ ื‘ื ื™ื˜ื•ืจ ืฉืœ SQL Server ืžื™ืžื•ืฉ ืฉืื™ืœืชื•ืช ื”ื™ืจืจื›ื™ื•ืช ื”ื›ื ืกืช ื ืชื•ื ื™ื ืœืฉืชื™ ื˜ื‘ืœืื•ืช ื‘ืžืงื‘ื™ืœ

  • ืื™ืฉ ืžื˜ืคืก ืขืœ ื”ืจ ื•ืžื“ืœื™ืง ื ืจื•ืช

    05/01/2017 Duration: 24min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ื›ืžื” ื ืจื•ืช ื—ื ื•ื›ื” ืžื•ื“ืœืงื™ื ื‘ืกืš ื”ื›ืœ ืื ืฉื™ื ืฉืžื˜ืคืกื™ื ืขืœ ื”ืจื™ื ื‘ืขื™ื” ืขื ื”ืคื™ืชืจื•ืŸ ื”ื ืคื•ืฅ ืœื‘ืขื™ื” ืขื Datediff ืฉืžื•ื ืข ืฉื™ืžื•ืฉ ื‘ืื™ื ื“ืงืก ืžื–ืžื•ืจื™ื ืœ-Power BI (ืื• ื”ืคื•ื ืงืฆื™ื” Accumlate)

  • ืขื•ื“ ืชื•ื›ื ื™ืช

    01/01/2017 Duration: 30min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ืคืจื•ื™ืงื˜ ื”ืงืžื” ืฉืœ Always On AG ืขืœ SQL Server 2016 ื‘ืœื™ Domain ืคื™ืฆ'ืจื™ื ื—ื“ืฉื™ื ื‘-SQL Server 2016 SP1 ื™ื“ืขืชื›ื ืฉ-xp_cmdshell ื”ื•ื Deprecated? ืื ื“ืจื•ืื™ื“ ื•-Power BI ืงื ื™ื•ืช ื‘ืื™ื ื˜ืจื ื˜ ื•ืขื•ื“..

  • ืฉื™ื™ืงโ€™ื” ืžื›ื” ืฉื ื™ืช

    12/12/2016 Duration: 38min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืฉื™ ืื ื’ืœื‘ืจื’ ืžืฆื˜ืจืฃ ืืœื™ื ื• ืฉื•ื‘ ื•ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ืขืœ ื”ื‘ื—ื™ืจื•ืช ื‘ืืจื”"ื‘ ื•ื”-Data ืฉืงืฉื•ืจ ืืœื™ื”ื ืžื™ ื‘ืืžืช ืžืฉืคื™ืขย ื”ื›ื™ ื”ืจื‘ื” ืขืœ ื”ื—ื™ื™ื ืฉืœื ื• ื”ืฉื•ืจื” ื”ืขืฆื•ื‘ื” ื‘ื™ื•ืชืจ ื‘ื”ื™ืกื˜ื•ืจื™ื” ืฉืœ ืฉื™ืจื™ ื”ื™ืœื“ื™ื ืžื™ืžื•ืฉ ื ื›ื•ืŸ ืฉืœ DR ืžื—ืฉื‘ื•ืช ืขืœ ื”ืงื”ื™ืœื” ืžื” ื—ืกืจ ื‘-Always On Availability Groups ืคื™ื ืช ืฉืืœื•ืช ื”ื‘ื–ืง ื•ืขื•ื“..

  • ื—ื™ื“ื•ืฉื™ื ื•ืฉื™ื’ื•ืขื™ื

    04/12/2016 Duration: 33min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ืืœื™ืคื•ืช ื”ืขื•ืœืย ื‘-Excel ื—ื™ื“ื•ืฉื™ืย ื•ืฉื™ืคื•ืจื™ื ืœ-Optimizer ื‘-SQL Server 2016 ืžืงืจื” (ื ื“ื™ืจ) ืฉื‘ื• ื˜ื•ื‘ ืœื”ื•ืจื™ื“ ืืช ื”-Maxdop ืœ-1 ื—ื™ืฉื•ื‘ื™ ืื—ื•ื–ื™ื ื‘-Live Query Statistics ื‘-SQL Server 2016 ืกื•ืคืจ Bulk Copy ื•ืขื•ื“..

  • ื—ื“ืฉื•ืช ืžื”ืขื•ืœื ืขื ืฉื™ื™ืงื” ื—ื•ืœืฆื” ืืคื•ืจื”

    16/11/2016 Duration: 43min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืžืฆื˜ืจืฃ ืืœื™ื ื• ืฉื•ื‘ ืฉื™ ืื ื’ืœื‘ืจื’, ื•ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ื—ื–ืจื” ื‘ื–ืžืŸ ืขื ื”-International Date Line ื”ืืžืช (ื•ื”ืคืขื ื‘ืืžืช) ืขืœ ืžืฉืชื ื™ ื˜ื‘ืœื” ื•ื˜ื‘ืœืื•ืช ื–ืžื ื™ื•ืช ืงื•ืจืก ืื•ื ืœื™ื™ืŸ ื—ื“ืฉ ืฉืœ ื’ื™ืย ืขืœ Performance Tuning ื˜ื™ืคื™ื ืœ-DBA ืฉื™ืฆื™ืœื•ย ืœื›ื ืืช ื”ื™ืฉื‘ืŸ ื”ื˜ื•ื‘, ื”ืจืข ื•ื”ืžื›ื•ืขืจ ืขื Varchar(Max) ืžื™ืžื•ืฉ ืฉื•ื ื” ืœ-Queue ื‘-SQL Server ืขื•ื“ ื“ื‘ืจื™ื ื—ื“ืฉื™ื ืžื”ื—ื•ื“ืฉ ื”ืื—ืจื•ืŸ ื‘ืงื”ื™ืœื” ื•ื‘-SQL Server ืงืฆืช ืžืžื” ืฉืชื•ื›ืœื• ืœืœืžื•ื“ ื‘ืงื•ืจืก ืฉืœ ื’ื™ื: ืžื”ื• ื”-Plan Cache ื•ืœืžื” ืฆืจื™ืš ืื•ืชื• ืื™ืš ืœืžืฆื•ื ืืช ื”ืฉืื™ืœืชื•ืช ื”ื‘ืขื™ื™ืชื™ื•ืช ืื™ืš ืœืงืจื•ื ื•ืœื ืชื— Execution Plans ืื™ืš ืœืžื“ื•ื“ ื‘ื™ืฆื•ืขื™ ืฉืื™ืœืชื•ืช ื‘ืขื™ื•ืช ื•ืคืชืจื•ื ื•ืช ืขื Parameter Sniffing ื”ืจื‘ื” Query Tuning Case Studies ื•ืคืจืงื˜ื™ืงื” ืœืงื‘ืœืช ืงื•ืคื•ืŸ ื”ื ื—ื” ืœืงื•ืจืก, ื”ืื–ื™ื ื• ืœืชื•ื›ื ื™ืช..

  • ื‘ืžื‘ื” ื•ื‘ื™ื™ื’ืœื”

    31/10/2016 Duration: 26min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ: ื”ื˜ืจื™ืง ื”ื—ื“ืฉ ืฉืœ ืื™ืฆื™ืง ื‘ืŸ-ื’ืŸ ืžืชื™ Seek ื”ื•ื ืœื Seek ืื™ืš ืขื•ืฉื™ื Unpivot ื‘ืขื–ืจืช Cross Apply ื”ืงื‘ืฆื™ื ืฉื”ืœื›ื• ืœื—ืคืฉ ืืžื ืื—ืจืช (ืคื•ืกื˜ ืฉืœ ืœื™ืจืŸ ื•ื™ื™ืžืŸ) ืงืฆืช ืขืœ ื”ืฉืคื” ื”ืขื‘ืจื™ืช ื”ืžืœืฆื” ืœืžืชื›ื•ืŸ ื•ืขื•ื“..

  • F*** the Color Blind

    25/09/2016 Duration: 33min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ย  ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช: ื”ืชืงื ืช SQL Server ืขื ืžืžืฉืง ืžืฉืชืžืฉ ื‘-Windows Core ืฉื™ืžื•ืฉ ื ื›ื•ืŸ ื‘ื’ืจืกืื•ืช Reporting Services ื”ืฆืคื ืช ื›ื•ื ื ื™ื (ืœื ืžืชื•ื›ื ื ืช) ื”ืื ืฆืจื™ืš ืœื”ื™ื•ืช ืœื ื• ืื›ืคืช ืžืžื—ื™ืจ ื•ืกื™ื‘ื•ื›ื™ื•ืช ืจื™ืฉื•ื™? ืงืฆืช ื“ืžื™ื•ืŸ ื•ืฉื•ื ื™ ื‘ื™ืŸ SQL Server ืœ-MongoDB ื•ืขื•ื“..

  • Wait Stats, Execution Plans and More

    11/09/2016 Duration: 33min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช: ืขืœ Insert..Select ืžืงื‘ื™ืœื™ ื”ืื ื—ื™ื™ื‘ื™ื ืœื—ื›ื•ืช ืœ-SP1? ืขืœ ื”ืฉื•ื•ืืช Wait Types ื‘ื™ืŸ ื™ืžื™ื, ืฉื‘ื•ืขื•ืช ื•ืจื‘ืขื•ื ื™ื ืขืœ Nulls ื‘-Execution Plans ืื™ืš ืœืžื“ื•ื“ ืงืจื™ื™ืจื” ื•ืขื•ื“..

  • ืชื•ื›ื ื™ืช 65 โ€“ ื‘ืขืœ ื”ืฉืื™ืœืชื•ืช

    25/08/2016 Duration: 38min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช: ืื™ืš ืœืขืฉื•ืช ืžื™ื’ืจืฆื™ื” ื‘ื™ืŸ ื’ืจืกืื•ืช ื›ืžื• ืฉืฆืจื™ืš ืขืœ ื”ืคื•ื ืงืฆื™ื” HASHBYTES ื•ื‘ืขื™ื•ืช ืฉื™ืฉ ืื™ืชื” ื‘ืขื™ื” ืขื Temporal Tables ืขืœย ื”ื”ื‘ื“ืœ ื‘ื™ืŸ SMP ืœ-MPP ืื™ืš ืœื”ืกืชื›ืœ ื ื›ื•ืŸ ืขืœ sys.dm_exec_query_stats ืขืœ Direct Seeding ืขื Availability Groups ื‘-SQL Server 2016 ืื™ืš ืœื‘ื“ื•ืง ืื Instant File Initilization ืžื•ืคืขืœ ืขืœ 24 ืฉืขื•ืช ืฉืœ PASS ื•ืขื•ื“ ืื”, ื•ื™ืฉ ื’ื ื”ืคืชืขื” ืงื˜ื ื” ื‘ื”ืชื—ืœื” ื‘ืื“ื™ื‘ื•ืช DJ ื ื•ืขื” ื‘ืจื•ื“ืฆืงื™....

  • Query Tuning Case Studies

    14/08/2016 Duration: 28min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช, ืื ื—ื ื• ืžื“ื‘ืจื™ื ืขืœ ื›ืžื” Case Studies ืžืขื ื™ื™ื ื™ื ื‘-Performance Tuning ืžืชื•ืš ื”ืงื•ืจืก ืฉืœื ื•, Advanced Query Tuning in SQL Server.

  • ืืกืคื• ื—ื•ื•ื™ื•ืช, ืœื ืคื•ืงื™ืžื•ื ื™ื

    29/07/2016 Duration: 32min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช: ื˜ืจื•ื ื™ื” ืขืœ ืฉื—ื–ื•ืจ ื‘ื™ืŸ ื’ืจืกืื•ืช ืขืœ ืฉื™ืžื•ืฉ ื ื›ื•ืŸ ื‘-Alerts ื•-Dashboards ื˜ืจื™ื’ืจื™ื ื‘-DB2 ืขืœ SQL Server 2016 CU1 ืขืœ ื”ื”ื“ืจื›ื•ืช ื”ืงืจื•ื‘ื•ืช ืฉืœื ื• ื‘ืืจืฅ ื•ื‘ืขื•ืœื ืœื™ื ืงื™ื ืœืงื•ืจืกื™ื ืฉืœื ื•: Become a SQL Server DBA Advanced Programming in SQL Server ย 

  • ืชื•ื›ื ื™ืช 62 โ€“ ื™ื•ืฉื‘ ื‘ืกืŸ ืคืจื ืกื™ืกืงื• ืขืœ ื”ืžื™ื

    14/07/2016 Duration: 33min

    ืœื—ืฅ ืœื”ื•ืจื“ืช ื”ืคืจืง ื”ื™ื•ื ื‘ืชื•ื›ื ื™ืช: ืขืœ Azure Cool Storage ืื™ืš ืขื•ื‘ื“ AlwaysEncrypted ืื•ืคืฆื™ื•ืช ื—ื“ืฉื•ืช ื‘-Maintenance Plans ื”ืจื•ื‘ื•ื˜ื™ื ืžืชืจื‘ื™ื ืื™ืš ืžืชื‘ืฆืข ื”ื—ื™ืฉื•ื‘ ืฉืœ ืคืจื’ืžื ื˜ืฆื™ื” ื‘ืื™ื ื“ืงืกื™ื ื”ืขืชื™ื“ ืฉืœ Machine Learning ืชืคื™ืกื•ืช ื‘ื ื•ื’ืข ืœ-NoSQL ื•ืขื•ื“.. ืžืงื•ืจื•ืช ืฉื”ื•ื–ื›ืจื• ื‘ืชื•ื›ื ื™ืช: ืื‘ื™ืืœ ืื™ืœื•ื– - ื‘ืขื™ื•ืช ื‘ื–ืžืŸ Rebuild ืฉืœ Heap ืขื Non Aligned Index

page 3 from 7