Sql Server

Download Episode (mp3) Another show is here, and this time we talk about: Out sessions at PASS Summit 2015 What is BIML Reporting Services new features DBA scariest sentences SQL Server 2000 troubleshooting, DBCC Inputbuffer and DBCC Outputbuffer Lots of SSIS stuff, including dynamic import and new features throughout the versions More about SQL Server 2016 Tempdb on SQL Server 2016 and in general Guy also shares a discussion he's heard about how to stay young and what he thinks about it. Items mentioned in the show: 24 Hours of PASS session recordings Matan Yungman - The Data Loading Performance Presentation

Download Episode (mp3) Show 40! During the show, we talk a little bit about Bob Marley, his songs and their meaning. We also talk about: Recommended bucket count for In-Memory OLTP On Index rebuild, disable and statistics update How the Datetime2 data type is stored Various SQL Server tuning switches Which operators can work in batch mode AlwaysOn Availability Groups enhancements in SQL Server 2016 Async_network_io issues The CXPacket and SOS_scheduler_yield wait types and what they mean  

Download Episode (mp3) This episode doesn't talk about SQL Server at all. It talks about changing the way we think and behave around work. Many of us High-Tech workers are constantly working long hours, checking emails on the phone and taking work home. We talk about how it can be done differently, and Guy brings his own personal story about how he's done it. We talk about working hours and adjusting between work and family life, but also about being home mentally and not only physically, about being disconnected, and about managing a company in a challenging and different way than what most companies do. You really don't want to miss this one. Items mentioned in the show: Ricardo Semler - How to Run a Company with (almost) No Rules Ricardo Semler Books

Download Episode (mp3) Another show is here, and as usual, we have a few items up our sleeves. Among other topics, we talk about: Best practices for patching SQL Server SQL Server 2016 In-Memory OLTP Enhancements JSON "support" in SQL Server 2016 and XML Database Kosher Certification Erland Sommarskog's beta_lockinfo SQL Server Monitoring How Albert Einstein came up with his theories We also talk about family meals, Bar Mitzvas, a funny Druze guy, and more.    

Download Episode (mp3) On this show, we have a guest again - Eitan Blumin! We talk to Eitan about his specialties and about what he loves about SQL Server and what project he's proud of. We also talk extensively about Azure DocumentDB, its concepts and when to use it rather than SQL Server. At the end, Eitan also gives a good advice to people just starting their database career. Items mentioned in the show: Eitan Blumin - Introduction to Azure DocumentDB Eitan Blumin - Efficiently UPDATE and DELETE using TOP and ORDER BY Eitan Blumin - Service Broker Sample: Asynchronous Triggers Eitan Blumin - Service Broker Sample: Multi-Threading  

Download Episode (mp3) Microsoft arranged to huge confrences lately - Build and Ignite, in which they announced some big news. We talk about the news in general, and the things that relate to us as data people. Among other topics, we talk about: SQL Server 2016 new features Azure SQL Database Enhancements Azure SQL Data Warehouse Azure SQL Data Lake The new way of Microsoft We also cover other "ordinary stuff": Internals of In-Memory OLTP Displaying format vs. storing format Items mentioned in the show: Ronen Ariely - Date displaying format, vs Date storing format

Download Episode (mp3) On this show, we talk about Alan Turing and how he broke the Enigma machine, about "Ma Yesh", "Zehu Ze", and about Sambusak. We also tell a few bad geek jokes. Oh, we also talk about SQL Server related stuff: About adjusting Log Shipping, about identity and sequence, about execution plans, Azure SQL Database backups, and about Columnstore. Items mentioned in the show: Matan Yungman - Can Log Shipping Work Without Shipping the Log? Azure SQL Database Backup and Restore Niko Neugebauer - Columnstore IO Rob Farley - Probe Residual when you have a Hash Match

Download Episode (mp3) On this show, we summarize our European trip, talk about some enhancements in Azure SQL Database and why it's now a big thing, talk about why In-Memory OLTP is not good enough yet, talk about the best sessions in PASS Summit 2014, talk a bit about MySQL, and more. Items mentioned in the show: Top 10 sessions of PASS Summit 2014 Next Israeli SQL Server User Group meeting Aaron Bertrand - More Online Operations for Azure SQL Database MySQL Query Cache

Download Episode (mp3) On this show, we take a deep dive into the Plan Cache and talk about how you can monitor and learn about query behavior using its DMVs. We also talk about how a Dates table can benefit you, and why, and about weird issues with Dynamic SQL and locking. Items mentioned in the show: Guy Glantser - Monitor Query Statistics

Download Episode (mp3) We have a special episode today: SQL Server Radio Purim edition

Download Episode (mp3) On this show, we summarize the technical part of SQLSaturday Israel which took part last month. We talk about the interesting sessions we attended, and about the things we covered about in our sessions. Among other topics, we talk about: What is Bulk Loading What is Minimal Logging and how you can achieve it (not as easy as you think) What is EAV and how you can make it super fast Clustered Index Scan vs Allocation Order Scan How to start thinking about "Big Data" technologies How we get prepared for delivering a presentation And more..  

Download Episode (mp3) We're in Israel, and unlike in this site where we write in English, some people (Maria Zakourdaev and Yoni Nakache) insist on writing in the language of the Hebrew man. That's how we learned about the word "סילומיות", and in the episode we explain what it means, with demonstrations. Another important milestone in this show is the fact that Guy is now an MVP!. We talk about how Guy got this achievement, and how you can do it too. In addition, we talk about: Azure SQL Database enhancements and possible mistakes Microsoft makes with the new features sp_MSforeachdb - How to use it the right way Gaps in Identity and Sequence Change Data Capture (CDC) SQLSaturday Israel recap And more.. Items mentioned in the show: Guy Glantser - I'm a SQL Server MVP! TechNet SQL Server Forum 15 #SQLFamily Wishes for 2015 Data Exposed - Insights into Azure SQL Database Amir Charania - Create Stunning Visualizations with Power View in 20 Minutes or Less Aaron Bertrand - A More Reliable and More

It's part 2 of the fascinating interview we had with Adi Sapir (LinkedIn, Twitter). On this part, we deal a lot with deploying changes to production, and mainly whether to do it using automatic tools or manually. In addition, we talk about: SSDT Continues Deployment The Cloud Version upgrades The next version of SQL Server Living in America We also talk about the cool handy tools Adi develops. Items mentioned in the show: doccolabs.com PASS is no longer "Professional Association for SQL Server"    

Download Episode (mp3) On this show, we have an important guest from abroad - Adi Sapir!  Adi (LinkedIn, Twitter) is a DBA for many years and today he's a Data Architect at Getty Images in Seattle. We had a fascinating talk and we divided it to two parts. On this part, we talk about: The role of the Database Architect The current place of SQL Server in the jungle of database systems What not to do with SQL Server Fighting with ORMs And more.. Adi also develops a few cool products for DBAs and developers. Check them out on www.doccolabs.com

Download Episode (mp3) On this show, our topic is Partitioning. We first talk about how we implemented Partitioning before SQL Server 2005 (or on Standard Edition). After that, we talk about: How to implement Partitioning When it's right and wrong to use it Will Partitioning help with query performance How to make sure you leverage its benefits Improvement Microsoft implemented over the years Partitioning maintenance tactics and much more..  

Download Episode (mp3) What's the best way to migrate from SQL Server 2008R2 to SQL Server 2014 with a possible fallback? We start the show with an interesting discussion about this subject. Later on, we talk about: Cool tips for SSMS Central Management Servers Plan Guides What needs does Azure DocumentDB come to address Delayed Durability Interesting behaviors of Availability Groups Database documentation Items mentioned in the show: Koen Verbeeck - The Magic Alt Button Matan Yungman - Five Ways to Improve Your Productivity with SSMS Dudu Sinai - Transaction Durability Itai Binyamin - What are Extended Properties Good For?

Download Episode (mp3) On this show, which is recorded in Seattle, we share our plans, schedules, thoughts and hopes for Pass Summit 2014. We focus on the schedule each one of us has built for the summit and reflect our thoughts about how the topics of those sessions can help all of us in our day-to-day jobs. We also discuss if and how the agenda fits the current Microsoft strategy.

Download Episode (mp3) It's show 24, and guess what - we have a guest again: Asaf Aviv! Asaf is very much into SQL Server Scale-Out solutions and SQL Server Replication, and not surprisingly, we take a VERY deep dive into those subjects (get ready for a lot of pro tips). In addition, we talk about the history of Asaf as a rock star, about guitars and how they are related to SQL Server, and about a very weird issue Guy had with a motorcycle...  

Download Episode (mp3) This is the monthly all-over-the-place edition of our show. As usual, we cover a lot of issues we encountered the past month, interesting blog posts, tips, tricks, events and random thoughts. Among other topics, we talk about: A weird scenario with backups, and the difference between Backupset and Mediaset A weird scenario with a procedure ran 150 times a second Visualization of DBCC SHOWSTATISTICS in SSMS Various New Azure templates Scenarios for In-Memory OLTP Presentation skills And more.. Items mentioned in the show: Maria Zakourdaev - Using Google Charts API to Visualize Schema Changes Mark Wiklinson - Visualizing Statistics in SSMS New Optimized OLTP and Data Warehousing SQL Server Images on Azure SQLSaturday Israel 24 Hours of Pass Summit Preview Edition Julie Koesmarno - I Want It NOW!" Data Visualization with Power View 24 Hours of Pass SQL Server 2014 Edition Sunil Agarwal - SQL Server 2014: In-Memory OLTP for Database Administrators Sunil Agarwal - Columnst

Download Episode (mp3) On show 22, we talk about career management. We actually recorded this show a few months ago, but it might be the best and most important show we've had. We talk about about our careers: How we got to be DBAs, how we progressed, our difficulties, what steps took us forward, what processes we went through, and how getting involved in the community has helped us. Furthermore, we talk about: Why consistent learning is so important How blogging and public speaking can help you Why it's important to have a mentor How Guy started his own company Time management tips And how are candies related to Guy's career? Let us know what you think about career management in the DBA world. We would love to hear what you think!