SQL Server Radio

SQL Server Radio

By Guy Glantser, Eitan BluminNewsTechnologyTech News
Download on the App Store

SQL Server Radio episodes

  • Let Me Index That for You
    Download episode (mp3)
    Today in the show, we talk about:
    * Types of business analytics
    * Is cardinality estimation the most common cause for performance problems?
    * How to answer the question "what do you do"?
    * Old news about AWS max database size in RDS
    * New project architecture challenges
    * Reporting and comic books
    * Scary bug with mirroring and database snapshot
    33 min
  • [Replay] Show 11 – T-SQL
    Download Episode (mp3)
    Guy is currently having fun in Thailand, so we don't have a new show this week. Instead, we republish one of our earlier episodes, where we talk about our favorite language - T-SQL. We'll be back with a new show in two weeks.
    Did you know that SQL was initially called "Sequel" (Structured English Query Language)?
    On this show, we go back to basics and talk about our favorite language - Transact-SQL (T-SQL).
    We cover a lot of topics in the fields of development, performance and maintenance. Among them:
    * The logical phases of query processing
    * Our favorite and least favorite T-SQL features
    * T-SQL development best practices
    * How to avoid writing long Stored Procedures
    * How to avoid writing the "mother of all queries"
    * The Axis of Evil T-SQL featrues
    * Why you should (almost) never use table variables
    Items mentioned in the show:
    * Matan Yungman - The Axis of Evil
    * Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part1)
    * Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part2)
    39 min
  • Help the Optimizer

    There are many ways to write efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is - "keep it simple". In addition, we talk about use cases for Big Data, Ways for transferring data to a reporting server, an interesting BI project Guy is working on, and more

    29 min
  • Virtualization, Data Science and More
    Download Episode (mp3)
    In this show, we talk about:
    * How to tell if you have a CPU problem in a virtualized environment
    * SQL Server setup tips
    * Guy's experience from his data science course
    * How we change over time
    * More productivity tips
    35 min
  • Virtuaization, Data Science and More

    In this show, we talk about:

    • How to tell if you have a CPU problem in a virtualized environment
    • SQL Server setup tips
    • Guy's experience from his data science course
    • How we change over time
    • More productivity tips
    35 min
  • We Don’t Have a Name for This Show
    Download Episode (Mp3)
    * Replicating Tables in Azure SQL Datawarehouse
    * Persisting Statistics Sampling Rate, and Other Statistics Issues
    * Adding Tables with Default Values Online
    * The Microsoft Data Science Program
    * Followup on a Previous Item Global Temp Tables in Azure SQL Database
    * Loading a Trillion Rows into SQL Server
    37 min

About SQL Server Radio

From the publisher's feed

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data…

More shows like SQL Server Radio

Stuff You Should Know by iHeartPodcasts

Stuff You Should Know

78,393 Listeners

The Daily by The New York Times

The Daily

111,868 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners