Sql Server

Download Episode (mp3) On show 21, we have a guest again - Noam Binyamini, Senior Support Engineer at Microsoft. We talk with Noam about his job, about interesting incidents he encountered, common mistakes customers make, and about the importance of installing service pack and cumulative updates. Later on, we talk about the massive investments Microsoft puts into the cloud, the right scenarios to work with the cloud, and the maturity of Microsoft Azure SQL Database (formerly SQL Azure).    

Download Episode (mp3) On show 20, we talk about High Availability. We start with talking about the distinction between High Availability and Disaster Recovery. Then, we talk about the importance of having a RESTORE strategy rather than a backup strategy. After that, we talk about the various High Availability/Disaster Recovery technologies: AlwaysOn Failover Cluster Instances, Log Shipping, Database Mirroring and AlwaysOn Availability Groups. We talk about the specifics and capabilities of each technology, in which editions its supported and its pros and cons.  

We're back from our trips, and on show 19, we juggle around a few topics. We talk about super indexes, trivial plans and whether they're the best choice, Dynamic SQL and automatic code, Replication, a hidden and yet important property of Failover Clusters, and more.. Also, Matan declares that User Defined Functions need to be wiped out. Listen to hear why! Links mentioned in the show: Super Index Kendal Van Dyke - Troubleshooting Transactional Replication Eitan Blumin - Let SQL Server Write Code for You Avi Niv - Generating Email Reports Using XML Michael J Swart - Trivia about Trivial Plans Paul White - Forcing a Parallel Query Execution Plan Guy Glantser - How to Use Parameters Like a Pro and Boost Performance Modifying Clustered Service Settings Global Hebrew Virtual Chapter August Meeting Israeli SQL Server User Group Meeting #145

On show 18, we talk a lot about the "Balagan" around the Pass Summit session selection process and around the last 24 Hours of Pass. We also talk about certifications, Guy's trips in Bnei-Brak, courses, what are number tables and why you need them, what we love about SQL Server, a strange problem with mirroring, and more.. Links mentioned in the show: Brent Ozar - Fast-Checking the 24 Hours of Pass Guy Glantser - What I Love About SQL Server ASK FAQ - Why Should I Consider Using an Auxiliary Numbers Table? Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part 1) Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part 2)

On our 17th show, we have updated about two major issues discussed on the previous show - Guy's running status and the post office. We also talk about wait types, a new trace flag, memory estimates in SQL Server 2014, data loss bug, events, and much more.. Items mentioned in the show: Next user group meeting Thomas LaRock - ESTIMATING MEMORY REQUIREMENTS IN SQL SERVER 2014 Aaron Bertrand - New Trace Flag to Fix Table Variable Performance Aaron Bertrand - Fixes for SQL Server 2012 & 2014 Online Index Rebuild Issue SP_SERVER_DIAGNOSTICS_SLEEP Wait Type Paul Randal - Wait statistics, or please tell me where it hurts

After a long time, we have a guest again - Shy Engelberg from HYNT! We had a great conversation that spanned a lot of subjects. Among other topics, we talked about Microsoft and Google, Views and bad plans, Hekaton best practices, good and bad features, the life of the consultant, how Shy is doing in his new adventure, and about the professionals who influenced us the most.  

On show 15, as always, we cover a lot of interesting stuff. We talk how our lives and databases will look in the year 2025. We also talk about changes to Azure SQL Database, Interesting webinars, weak passwords, Recompilations, SQL Server 2014, transaction nesting, and much more. Of course we talk about past and future events, and also about the top 3 jobs for DBAs. Guy also shares his running experience, and explains how a SQL Server feature is related to the post office.. Items mentioned in the show: Global Hebrew - Steve Rezhener: Introduction to SSRS, and SSRS on SSRS Azure SQL Database Service Tiers and Performance Levels SQLDownUnder with Paul Larson TechEd North America Lectures Pass Application Development - In-Memory OLTP for Developers RunAs Radio - SQL 2014 Panel with the SQL Team Geri Reshef - Transaction Nesting Paul Randal - Most common wait stats over 24 hours and changes since 2010 Shimon Gibraltar - On Security and Humans: Finding Weak Password in SQL Server SQL Server 2014 Manag

Show 14 is up, and as usual, we cover lots of stuff. We talk a lot about the new Cardinality Estimator, why Views are dangerous, and on the other hand, tricks you can do with them, what is the async_network_io wait type, and about another cool little feature in SQL Server 2014. We also cover two webinars worth watching, and translate (and invent) some words.. Items mentioned in the show: Adir Miller at Verint CSS Engineers - SQL Server 2014: TEMPDB Hidden Performance Gem CSS Engineers - SQL Server 2014’s new cardinality estimator Kendra Little - The SQL 2014 Cardinality Estimator Eats Bad TSQL for Breakfast Eitan Blumin - Eficiently UPDATE and DELETE using TOP and ORDER BY Michael Zilberstein - Clustered Columnstore Index in SQL Server 2014 Doug Lane - Refactoring T-SQL with Windowing Functions Aaron Bertrand - Some great news for Standard Edition customers in SQL Server 2014 Next User Group Meeting

It's launch day! SQL Server is officially released today. With In-Memory OLTP ("Hektaon"), Clustered Columnstore Indexes, Azure integration, AlwaysOn enhancements, Buffer Pool Extension, a new Cardinality Estimator, Delayed Durability, and other smaller but VERY handy features, SQL Server 2014 is an exciting version. On this show, we talk all about the features of the new version.      

After the live show, we're back in the studio. We covered quite a lot of topics. Among them are auditing, Extended Events and Event Notifications, cluster issues, database unit tests, SSMS Add-ins and Hadoop. In addition, we have a countdown featuring the 10 best presentations Pass Summit 2013. Oh, and we also talk about Matan's new job... Items mentioned in the show: SQL Server 2014 Launch Event Top 10 presentations of Pass Summit 2013 User group meeting #141 Michael Zilberstein - Clustered Columnstore Index in SQL Server 2014 Michael Zilberstein - Updateable Columnstore Index Gotchas Maria Zakourdaev - Think and Rethink Every Thing Meir Dudai - The List of Unsupported Things I Do with Replication Bob Pusateri - Auditing Database Snapshots Jonathan Kehayias - Event Notifications vs Extended Events Red-Gate SSMS Ecosystem Project Marc Pryce-Maher - Building an SSMS Add-in tSQLt Guy Glantser - How to Load Data from Excel in SSIS – 32-bit vs. 64-bit Matan Yungman - The Strange Story About the

This episode is the recording of the live show we had on the February meeting of the Israeli SQL Server user group. We had a great discussion with the crowd about Clustered Indexes vs. Heaps, load testing, the cloud, Filtered Indexes, SQL Alerts, and much more. We also conducted a quick survey about relevant topics for future meetings of the group. Items mentioned in the show: Thomas Kejser - Clustered Indexes vs. Heaps Matan Yungman - Know When it's Good Enough Brent's Crazy Career Challenges RunAs Radio - Distributed Replay in SQL Server 2012 Glenn Berry - Selecting a Processor for SQL Server 2014 - Part 1 Brent Ozar - What Do You Ask the Leaving DBA? Kenneth Fisher - The "most recent sql handle" column From the Forum - Filtered Indexes Issue Statistics IO Parser Meir Dudai - Experiences From the Field in Cloud Environment (recording)

Believe it or not, this is our 10th show! This time, we're going freestyle. We talk about a wide variety of topics, spanning query tuning, good and bad defaults, Tempdb, Azure, important trace flags, Logon Triggers and much more.. We don't forget recent and upcoming events, and in addition, Guy shares his special birthday celebrations and raises an idea for a new reality show.. If you don't already know, we will record a live show on the next Israeli SQL Server user group meeting. We will have 3 mics: One for Guy, one for Matan and one that will travel between people in the audience. Click here to register!   Items mentioned in the show: Next Israeli SQL Server User Group Meeting Previous and Next Global Hebrew Virtual Chapter Meetings Tribal Awards Pini Krisher - Problems Working with SQL Azure Thomas Kejser - Default Configuration of SQL Server Guy Glantser - SQL Server Error Log Management Tempdb Best Practices

On our 9th show, we host SQL Server MVP Geri Reshef. Geri just came back from the MVP summit in Seattle, and he's here to tell us how it was, in addition to telling us about his way to becoming an MVP and the benefits of being one. Geri also shares an unusual combination of T-SQL and the Hebrew calendar, his experience with SQL Server in Latin America and how blogging has helped him in his career. Items mentioned in the show: SQL Server on Wikipedia Hierarchical and Recursive Queries in SQL Server on Wikipedia Hebrew Calendar using T-SQL Pass Nicaragua Facebook Group 24 Horas de Pass   

After the conference season, we go back to the regular format of events, blogs, forum discussions and other goodies. Here's some of the topics we cover: Is index maintenance still necessary in 2013? How to really monitor page splits? "Smelly" code What CXPacket really means and how can we leverage it Past and future events We also have a very interesting "top 10" list, and much more.. Links mentioned in the show: Next Israeli SQL Server User Group meeting Previous Israeli SQL Server User Group meeting An index build takes a long time when a SQL Server database backup is running Guy Glantser - Forty Things You Didn’t Know About SQL Server The Data Loading Performance Guide Ola Hallengren's Index and Statistics Maintenance Script #FiveWordTechHorrors Eitan Blumin - Service Broker Sample: Asynchronous Triggers Matan Yungman - Using CXPacket Waits to Detect Query Bottlenecks Michael J. Swart - Overly Complex Views, Procedures And Functions Matan Yungman - Finding The Needle In The Haystack

Continuing our conference season summary from shows 6 and 7, this show is a special English edition that holds the interviews recorded on SQLRally Amsterdam with three of the biggest names in the industry: Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter). The interviews cover quite a few topics. Among them are professional development, the future of DBA work, SQL Server 2014, storage, parallelism, virtualization and SQLCLR. Update: On August 2014, we started the English edition of SQL Server Radio. If you liked the interviews, check out the other shows we have there. Items mentioned in the show: Brent Ozar - Rock Stars, Normal People, and You Brent Ozar - Why Index Fragmentation Doesn't Matter (Video) Denny Cherry's Podcast - People Talking Tech Adam Machanic - Next-Level Parallel Plan Forcing: An Alternative to 8649 Adam Machanic - Query Tuning Mastery: The Art and Science of Manhandling Paralellism Adam Machcnic - Data, Faster: Microsoft SQL Server Per

This show is the second part of our conference season summary. As in part 1, We are with Maria Zakourdaev again, and this time we talk about the professional side of the conferences and share some of the exciting things we learned. In addition, we have a very special and fun interview with Brent Ozar! Items mentioned in the show: Brent Ozar - Rock Stars, Normal People, and You Brent Ozar - Why Index Fragmentation Doesn't Matter (Video) Paul White - Iterators, Query Plans, and Why They Run Backwards Paul White - Parallel Query Execution (Video) Paul Randal - Index Fragmentation: Internals, Analysis, and Solutions (Video) Kimberly Tripp - Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Video) David DeWitt - Hekaton: Why, What, and How (Video) SQLSkills Extended Events Add-In Michael Zilberstein - New DMV: yes… no… that’s complicated (look at the comments) Thomas LaRock - SQL Someday (Video)  

After returning from PASS summit and SQLRally, we dedicate this and the next show to summarizing the conference season. For this cause, we are joined by Maria Zakourdaev (Blog | Twitter). We talk about the experiences we had in the events, about the special community we are a part of and about the various learning and networking opportunities it offers. We also give tips about how to convince your boss you should go, and who's it for. In addition, we have two very special interviews with two of the biggest names in the industry, Adam Machanic and Denny Cherry. Items mentioned in the show: Denny Cherry's Podcast - People Talking Tech Adam Machanic - Next-Level Parallel Plan Forcing: An Alternative to 8649 Adam Machanic - Query Tuning Mastery: The Art and Science of Manhandling Paralellism Adam Machcnic - Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR T-SQL Tuesday Rob Farley - Plan Operator Tuesday round-up Maria Zakourdaev - PASS summit 2013. We do not remember days. We reme

On the 5th show, we have a special guest: the one and only Ami Levin! Ami moved to the silicon valley about year ago. We talk to him about his new role and its challenges, the differences between the Israeli and American markets, his relocation experience and more.. In addition, Ami reveals his very interesting plans for helping the community in the near future...  

We have a really packed show this time. After the last show where we talked to Adi Cohen about his MCM experience, the MCM certification has been retired. We start the show describing how this was done and how the community reacted. In addition, we talk about new additions to Azure, awesome blog posts (including a nostalgic one), past and future events, tips and tricks, and more.. How's the Libyan ruler related? Listen to find out.. Below are some of the items mentioned in the show. Events: Guy Glantser - My Summary of 24 Hours of Pass 24 Hours of Pass Recordings Last User Group Meeting Session Materials Next User Group Meeting - Click to Register Glenn Berry - Selecting and Sizing Database Hardware Blog Posts: Maria Zakourdaev - Look back and realize how far you came Geri Reshef - How to Execute a Job with Parameters Paul Randal - Page Life Expectancy isn't what you Think Jeremiah Peschka - On Bobcats per 100 Orders and Other Spurious Metrics Matan Yungman - Using Change Data Capture and CLR

On the 3rd show, we talk with Adi Cohen about his way to being a Microsoft Certified Master of SQL Server, his work methodologies and his plans for the future in the USA. We also talk about SQL Server certifications in general, about Partitioning and about a tool DBAs use in the real world, although it's not "appropriate". Items mentioned in the show: Adi Cohen - The Road to the MCM Microsoft Learning Site MCM Readiness Videos As a reminder, you can listen to the show on this site or on your Smartphone using your favorite podcast app. Also let us know what you think about the show in the comments section, on the user group Facebook page, or using the contact form.   ========================================= Show intro: Professor Kliq - Bust This Bust That