Sql Server Radio

  • Autor: Vários
  • Narrador: Vários
  • Editor: Podcast
  • Duración: 103:34:24
  • Mas informaciones

Informações:

Sinopsis

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 platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.

Episodios

  • Show 47 - How to Find a DBA Job with Brent Ozar

    12/05/2016 Duración: 34min

    Continuing the show from two weeks ago, we have another show with Brent Ozar we recorded when he was in Israel a few weeks ago. This time, we talk about what a DBA needs to know in order to get a job in this day and age. What should you know if you're a junior DBA? what should you know if you're a senior DBA? what are some interesting interview questions you might face? We also spend a few minutes talking about SQL Server on Linux, whether it makes sense, what does it really mean, and what should any SQL Server professional know today.  Items mentioned in the show: Brent Ozar - Secret Meeting Minutes for the SQL Server on Linux Decision* About Brent Brent Ozar (Blog | Twitter) is the founder and owner of Brent Ozar Unlimited. Brent loves pushing SQL Server past the speed limit and showing other people how to drive it faster. He enjoys translating between programmers, sysadmins, SAN admins, and project managers. They find the root of the problem quickly, together, and get everyone working towards the same so

  • Show 45 - Managing the New York Stock Exchange with Lior King

    21/04/2016 Duración: 35min

    In this show, we talk to Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange. Lior has many years of experience working with SQL Server, Oracle, .NET, MongoDB, Cassandra, and much more. We discuss the challenges and the MANY database systems that ICE works with. Among other topics, we talk to Lior about: What happens under the hood when someone buys a stock How Lior's team integrates the many data systems for providing a full solution How ICE use SQL Server Replication for synchronizing data around the world What Lior is looking for in SQL Server 2016 About Lior Lior King is carrying more than 25 years of experience in the IT world. His main expertise is database systems (SQL Server and Oracle), database programming, data access layers using .NET and NoSQL solutions (MongoDB, Cassandra and Hadoop). He started as a developer in the army (MAMRAM graduate) then a DBA, a team leader, a software architect and consulting group manager. He's always se

  • Show 44 - SSMS Can Beep

    07/04/2016 Duración: 37min

    Did you know SSMS can make sounds? We start the show with some interesting things you might do with it. In addition, we talk about: SQL Server on Linux Hadoop fundamentals SQL Server 2016 eBook Changes to auto update statistics in SQL Server 2016 New SQL Server 2016 database level configurations Distributed Availability Groups - what is it and use cases How AWS storage works Items mentioned in the show: Guy Glantser - Hadoop Fundamentals Denny Cherry - How to make SSMS beep when a query is done? Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2 Erik Darling - Changes to auto update stats thresholds in SQL Server 2016 Brent Ozar - SQL Server 2016: The Death of the Trace Flag Distributed Availability Groups

  • Show 43 - Projects We're Proud of

    17/03/2016 Duración: 27min

    In this show, we talk about a few projects we took part in and we're proud of.  

  • Show 42 - Database Testing and Continuous Integraton wiith Steve Jones

    07/03/2016 Duración: 42min

    In today's world where deployments to production are very frequent, continuous integration and testing code become more important than ever.  In this show, we talk to Steve Jones (Blog | Twitter), the editor of SQLServerCentral.com about how to do it. Among other topics, we talk to Steve about: His work at SQLServerCentral and his favorite parts over the years What he's looking for in SQL Server 2016 What is continuous integration and how it can be done with SQL Server How to test your database code before it gets to production Data Quality Services and Master Data Services Items mentioned in the show: SQLServerCentral Steve's Blog - Voice of the DBA Voice of the DBA podcast DBA Team - Steve on a horse Steve Jones - 100 Hours Josh Kaufman - The first 20 hours (TEDxCSU) tSQLt SQL Server Radio show 38 - DevOps, Cloud and Podcasting with Richard Campbell Practical Refactoring Redgate SQL Release About Steve Steve has been working with SQL Server since 1991, when he became the accidental DBA for a SQL Server

  • Show 41 - IFI

    21/02/2016 Duración: 26min

    In this show, we talk about: External deadlines The RS.EXE utility and what it is used for Why you shouldn't use Task Manager to check how much memory SQL Server consumes The Lock Pages in Memory option Stored procedure execution options under Transactional Replication Instant File Initialization checkbox in SQL Server 2016 setup SQL Server Agent job history Fixed server roles and how to correctly configure logins in SQL Server  Items mentioned in the show: Scott Murray - SQL Server Reporting Services RS.EXE Utility Gail Shaw - Stop using Task Manager to check SQL’s memory usage! SQLSaturday Israel Guy's Big Data seminar at SQLBits

  • Show 40 - Just Another Show

    28/01/2016 Duración: 30min

    Another two weeks have passed, and another show is live. Today on the show: Error handling in SSIS Why Big Data systems use ELT and not ETL What Data Scientists do What Data Analysts do and why they need to know SQL well  Azure Data Factory and Azure Data Catalog Compressing and decompressing data in SQL Server 2016 Configuration options for high-end SQL Server systems More SQL Server setup tips Items mentioned in the show: Guy's SQLBits precon - Big Data Made Simple Jeff Smith - They Just Write SQL Statements Recommended updates and configuration options for SQL Server 2012 and later versions with high-performance workloads  Built-in functions for compression/decompression in SQL Server 2016    

  • Show 39 - SQL Server and Independent Consulting with William Durkin

    14/01/2016 Duración: 37min

    In this show, we talk to William Durkin (Blog | Twitter), an Englishman "stuck in Germany". William just switched to being an independent SQL Server consultant, and we talk to him about going independent, how to price yourself the right way, and about many good SQL Server tips. Specifically, we talk about: His way for becoming an independent consultant How to price yourself by value and not by time SQL Server Replication tips Tips for upgrading SQL Server with minimal downtime What is the meaning of 5 nines and how much technical and financial investments it requires When and how to use DNS aliases with your SQL Servers Dynamic Data Masking use cases Linked Servers performance tips Items mentioned in the show: Double Your Freelancing - Student Success Story with William Durkin Global Azure Bootcamp SQLKonferenz About William William is an independent SQL Server consultant from England (now in Germany). He has experience as a DBA in large multi-national SQL Server environments and is a regular speaker arou

  • Show 38 - DevOps, Cloud and Podcasting with Richard Campbell

    30/12/2015 Duración: 38min

    On this show, we talk to the famous podcaster, Richard Campbell (LinkedIn | Twitter). Richard is the co-host of the .NET Rocks podcast, host of the RunAs Radio podcasts, and a long-time technology consultant and business owner. We talk to him about Devops, the Microsoft data platform, the cloud and podcasting. Among other topics, we cover: What is DevOps, and how the database fits in this kind of strategy The state of the Microsoft data platform and the new versions of SQL Server How Microsoft Azure competes with Amazon and Google Cloud Will you lose your job to the cloud? What was the original purpose of the relational model The history of the .NET Rocks podcast and how its done today Items mentioned in the show: .NET Rocks Podcast RunAs Radio Podcast Goldman Sachs on Microsoft: 'We Were Wrong' Serial Podcast .NET Rocks Show 1220 - Next Generation Airliners Geek Out About Richard: Richard Campbell wrote his first line of code in 1977. His career has spanned the computing industry both on the hardware and

  • Show 37 - Be Happy

    16/12/2015 Duración: 40min
  • Show 30 – Coffee and Water

    22/09/2015 Duración: 37min

    Do you know what FOMO means? It means “Fear of Missing Out”, and it’s a term used in the startup and venture capital fields. However, it’s also relevant for us as DBAs, and we start the show explaining why. Other than that, we talk about: Why you should be careful when using SQL Server’s Row Level Security Duplicate indexes The dangers of Indexed Views An important thing you need to know about Filtered Indexes Lots of ways to improve your productivity with Management Studio Allow Snapshot Isolation and Read Committed Snapshot Items mentioned in the show: Startup podcast 356labs Matan Yungman – 5 Ways to Improve Your Productivity with SSMS Forum discussion: ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT MCM readiness videos

  • Show 29 – Architecture, Microsoft APS and Azure SQL Datawarehouse with Bradley Ball

    07/09/2015 Duración: 44min

    We start to warm up the engines towards PASS Summit, which will take place in Seattle at the end of October. Before the summit, we will host a few speakers to talk about their sessions and share some of the stuff you can expect to hear. In this show, we have Bradley Ball (blog | twitter), Data Platform Management Lead at Pragmatic Works. Among other topics, we talk to Bradley about: What you can expect to hear in Bradley’s PASS Summit precon and session Data architecture What is Microsoft APS and what’s important when working with it How Azure SQL Datawarehouse took the APS idea a step further Message queuing Bradley’s military career Items mentioned in the show: Bradley’s PASS Summit session: Indexing Internals for Developers and DBAs Bradley’s PASS Summit precon: Optimize “All Data” with a Modern Data Warehouse Solution Jason Strate – sp_IndexAnalysis We also talk about some weird meanings of the acronym “APS”. About Bradley Bradley Ball is a SQL Server MVP with about 15 years of IT experience. Bradley

  • Show 28 – Backups, Scripting and Regular Expressions with Sean McCown

    22/08/2015 Duración: 01h34s

    A few months ago we hosted Sean McCown for a talk about indexing tips and backup performance. On this show, we have Sean again. Sean reveals tons of backup tips and tricks while talking about his new free product, Minion Backup. Among other topics, we talk about: What are VLF’s and why it’s not good to have many of them When you SHOULD use shrink Why Sean doesn’t like Policy Based Management How to monitor backup progress Regular Expressions in SSMS And as always with our guests, we play Scattergories, and Sean tells a VERY interesting story about cluster configuration. Items mentioned in the show: Minion Backup Sean’s PASS Summit session – Monster Text Manipulation: Regular Expressions for the DBA Sean’s PASS Summit precon – The Enterprise Scripting Workshop   About Sean: Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL

página 7 de 9