SQL Server Radio

Itzik Ben-Gan has many T-SQL tricks. In this show, we talk about a few of them: How to get Batch Mode Processing with regular tables How to share Identity between different tables How to use Cross Apply for Unpivot In addition, we talk about what SOS_Scheduler_Yield means and answer the question - is it always the DBA's fault? If you would like your question to be featured on the show, just head o...

Guy is back from a one month trip in the United States, and we're back with another show of SQL Server Radio. In this show, we talk about a few of our upcoming speaking gigs (PASS Summit and SQL Server Days in Belgium), about File-Snapshot backups in SQL Server 2016, about triggers in DB2, SQL Server 2016 CU1, about where to spend your thinking time, and more.

Tomaž Kaštrun ( blog | twitter ) about what Data Science is, what does a Data Scientist do, what insights is he looking for, what tools does he use, what is R, and what R integration in SQL Server 2016 means. About Tomaž Tomaž Kaštrun  is BI developer and Analyst with more than 15 years of experience working with MS SQL Server and and 15 years of experiences on statistics and predictive analytics....

What's new in SQL Server 2016? In this show, we celebrate the official release of SQL Server 2016 and talk about the new features of the version.

We can't really believe it, but it's the 50th show of SQL Server Radio! Time does fly when having fun! To celebrate the 50th show, we have a countdown of the top 50 SQL Server features of all time..with a small twist..

Most of us will have to deliver some kind of a presentation in our professional lives, whether it's inside the organization or at a conference. Today, we talk to Boris Hristov ( blog | twitter ) about this subject. You might remember Boris from show 26 where we talked to him about Policy Based Management and Distributed Replay, but today he's in a completely different phase. Boris started a compan...

In this show, we talk about: The top 100 percent trick and whether or not it works A weird bug that was solved in SQL Server 2012 SP2 What is SSISDB and an Intersting tip for its maintenance How to start performance tuning a system Misconceptions about order Dynamic search conditions How to share data between stored procedures Our favorite sessions from today's 24 Hours of PASS How to be more prod...

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 minut...

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 w...

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...

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

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 Serve...

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...

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 I...

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 t...

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...

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 Fil...