Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

SQL Server Radio

Player FM - Internet Radio Done Right

392 subscribers

MS Dev

הוסף לפני eleven שנים

תוכן מסופק על ידי Guy Glantser and Eitan Blumin. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי Guy Glantser and Eitan Blumin או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

Subtext and Discourse | Art World Podcast

1
From Conflict Zones to Community Change: Mark Neville on Photography as Activism 45:16

לפני 6 weeks45:16

הפעל מאוחר יותר

רשימות

לייק

אהבתי

45:16

What happens when photography becomes a tool for social change rather than just documentation? In this episode, Michael Dooney speaks with acclaimed British photographer and artist Mark Neville about his journey from art school to the front-lines of conflict, and how he uses collaborative photography projects to empower communities, challenge social norms, and effect real-world impact. Neville shares stories from his time as an official war artist in Afghanistan, discusses the making of influential projects like The Port Glasgow Book Project and Stop Tanks With Books , and reflects on his ongoing work in Ukraine. Listeners will gain insights into the ethics of documentary practice, the power of art as activism, and what it means to make photography for—and with—the people it represents. Timestamps (00:00) – Introduction and welcome (01:49) – Artist and photographer living and working in the Ukraine (04:54) – The Port Glasgow Book Project: Art for the community (08:04) – Getting attention of the art world (12:00) – Turning point towards a social engaged artistic practice (14:42) – Stop Tanks with Books Project: Art as activism in Ukraine (17:56) – Russian invasion of Ukriane (20:55) – Postcode Ukraine Charity (25:06) – War Artist in Helmand, Afghanistan (27:33) – Battle Against Stigma, book project (33:34) – Invitation to start making work in Ukraine (34:54) – Diary of a Volunteer, book project (37:51) – Individual experiences of Postcard Ukraine charity members (39:48) – Support for Ukrainian people (42:06) – How can listeners learn more and get involved? Mark Neville (b. 1966, London) is a British artist and photographer renowned for his socially engaged practice at the intersection of art, documentary, and activism. His projects often involve close collaboration with communities, aiming to empower subjects and address issues such as inequality, mental health, and conflict. Notable works include The Port Glasgow Book Project , Battle Against Stigma , Fancy Pictures , and Stop Tanks With Books . Neville has exhibited internationally, worked as an official war artist in Afghanistan, and was nominated for the Pulitzer Prize by The New York Times in 2012. Mark Neville official website: https://www.markneville.com/ Instagram page: https://www.instagram.com/marknevillestudio/ Postcode Ukraine: https://www.postcodeukraine.com/ This episode of Subtext & Discourse Art World Podcast was recorded on 28. March 2025 between Perth (AU) and Ukraine with Riverside . Michael Dooney official website: https://www.michaeldooney.net Instagram page: https://www.instagram.com/michaeldooney/…

לפני שנה 35:32

MP3•בית הפרקים

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible.

Relevant links:

265 פרקים

#MS Dev #Software Development #Tech News #Bigdata #Data #Microsoft #Sqlserver #Tech #News #Guy Glantser #Eitan Blumin #Database #Cloud IT #SQL

Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

SQL Server Radio

392 subscribers

published לפני שנה

שתפו

MP3•בית הפרקים

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible.

Relevant links:

265 פרקים

#MS Dev #Software Development #Tech News #Bigdata #Data #Microsoft #Sqlserver #Tech #News #Guy Glantser #Eitan Blumin #Database #Cloud IT #SQL

כל הפרקים

1
Episode 177 - Five and a Half Enhancements in SQL Server 2025 29:18

לפני 23 hours29:18

29:18

Guy and Eitan discuss Stephen Planck's blog post "Five SQL Server 2025 Enhancements DBAs Will Notice", and add some of their own insights. Relevant links: Five SQL Server 2025 Enhancements DBAs Will Notice - SQL Table Talk Configure a flexible automatic failover policy for an availability group - SQL Server Always On | Microsoft Learn Accelerated Database Recovery (ADR) in TempDB | Microsoft Learn Enable and Run tempdb on tmpfs for SQL Server 2025 Preview on Linux - SQL Server | Microsoft Learn Optimized Locking - SQL Server | Microsoft Learn Standard Developer edition in SQL Server 2025 | Microsoft Learn ABORT_QUERY_EXECUTION query hint - public preview | Microsoft Community Hub…

1
Episode 176 - SQL Server 2025 and more 38:14

לפני 29 ימים38:14

38:14

Many announcements and interesting releases came out this past month, so we got a lot to talk about in this episode! Relevant links: What's New in SQL Server 2025 - SQL Server | Microsoft Learn SQL Server 2025 - AI ready enterprise database from ground to cloud | Microsoft Community Hub Announcing Public Preview of DiskANN in SQL Server 2025 | Microsoft Community Hub SQL Server 2025: introducing optimized Halloween protection | Microsoft Community Hub SQL Server 2025: introducing tempdb space resource governance | Microsoft Community Hub Unlocking the Power of Regex in SQL Server - Azure SQL Devs’ Corner Announcing the General Availability (GA) of JSON data type and JSON aggregates | Microsoft Community Hub Announcing the Public Preview of JSON index in SQL Server 2025 | Microsoft Community Hub ZSTD compression in SQL Server 2025 | Microsoft Community Hub MSSQL Extension for VS Code: GitHub Copilot Preview + UI GA MSSQL Extension for VS Code: Introducing Schema Compare (Preview) - Azure SQL Devs’ Corner SQL Server Management Studio (SSMS) 21 is now generally available (GA) | Microsoft Community Hub Copilot in SSMS preview Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub Visual Studio 2022 Release Notes | Microsoft Learn Free SQL Managed Instance offer is now generally available Avoid T-SQL anti-patterns with the free T-SQL analysis tool - Azure SQL Devs’ Corner…

1
Episode 175 - Migrating from on-prem to AWS RDS 38:59

לפני 8 weeks38:59

38:59

Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS. Eitan talks about a new AI-related feature in Azure SQL Databases. And we also discuss the new SNAPSHOT backup T-SQL command in SQL Server 2022. Relevant links: Importing and exporting SQL Server databases using native backup and restore - Amazon Relational Database Service Learn about Amazon RDS maintenance window | AWS re:Post LLM Structured Output from Azure SQL Explained - Azure SQL Devs’ Corner Create a Transact-SQL snapshot backup - SQL Server | Microsoft Learn…

1
Episode 174 - Is SQL Server quality in decline? Or is it just friction? 32:37

לפני 12 weeks32:37

32:37

Guy and Eitan worry about the decline in SQL Server feature quality. But maybe there's something else behind it? Relevant links: Improving Azure SQL Database reliability with accelerated database recovery in tempdb | Microsoft Community Hub What the Decline of Sql Server Quality means for Developers and DBAs SLA for SQL Database | Azure AI will eliminate DBA Jobs faster than you think…

1
Episode 173 - SQL Noir and the fate of Azure Data Studio 34:36

לפני 17 weeks34:36

34:36

Guy and Eitan discuss a few interesting topics. Including a fun new game called "SQL Noir", how to implement statistical clustering model in SQL, about surrogate and natural keys, and the recently announced deprecation of Azure Data Studio. Relevant links: SQL Noir - A Detective SQL Game How to Write a Recursive CTE in SQL Server | LearnSQL.com Azure Data Studio Retirement - Azure SQL Devs’ Corner Relational Databases - Surrogate Keys and Logical Duplicates (by Ami Levin)…

1
Episode 172 - Between SQL Squid Games and SSMS 31:25

לפני 21 weeks31:25

31:25

Guy and Eitan answer an interesting question from the forum regarding the logic of NOT BETWEEN. And also, checking out the SQL Squid Game, discussing SQL Audit, and sharing some tips for SSMS. Relevant links: SQL Squid Game SQL Server Audit (Database Engine) - SQL Server | Microsoft Learn microsoft-dbas-club/Maintenance/SQLVersionUpdates Tell us how you did and whether you survived the SQL Squid Game! 😉…

1
Episode 171 - Clueless about SQL Server 2025 32:08

לפני 25 weeks32:08

32:08

Guy and Eitan talk about SQL Server 2025 (well, they try to, at least), and its various interesting upcoming features. Relevant links: Announcing SQL Server 2025 – SQLServerCentral What's New in SQL Server 2025 - Brent Ozar Unlimited® Optimized Locking - SQL Server | Microsoft Learn SQLBits is Coming Back to London in June 2025! - Brent Ozar Unlimited®…

1
Episode 170 - Interesting topics from PASS 2023 sessions 34:10

לפני 30 weeks34:10

34:10

Guy and Eitan go over the most popular sessions released from the SQL PASS archive of 2023, and discuss some other topics. Relevant links: Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud - Microsoft SQL Server Blog Sessions Archive for 2023 - PASS Data Community Summit Resolving and Preventing Deadlocks in SQL Server SSMS v21: Dark Mode, Git, Vertical Tabs, and More - Brent Ozar Unlimited® Copilot in SSMS is Kinda Like IE in SSMS - Brent Ozar Unlimited®…

1
Episode 169 - Resumable Incremental Database Integrity Checks 32:36

לפני 34 weeks32:36

32:36

Guy and Eitan discuss the common challenge of long-running database integrity checks (DBCC CHECKDB) and a solution to resolve it, and why do we need integrity checks at all? Relevant links: PASS Data Community Summit Incremental Integrity Check for Large Databases - Eitan Blumin's blog SQL Server Integrity Check - by Ola Hallengren tigertoolbox/MaintenanceSolution/5_job_Maintenance.sql · microsoft/tigertoolbox sp_can_tlog_be_applied (Transact-SQL) - SQL Server | Microsoft Learn T-SQL Script to Roll Forward Transaction Log Backups - Eitan Blumin's blog…

1
Episode 168 - New data types in SQL Server and a question about index fragmentation 32:49

לפני 38 weeks32:49

32:49

Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation. Relevant links: Resources from Microsoft: Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub Native JSON support now in preview in Azure SQL Managed Instance - Microsoft Community Hub EAP for Vector Support Refresh - Introducing Vector type - Azure SQL Devs’ Corner (microsoft.com) Calling external REST endpoints from Azure SQL Database | Microsoft Learn Index fragmentation: SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com) Should we do index maintenance on an Azure SQL Managed Instance or Azure SQL Database? (kendralittle.com) Stop Worrying About SQL Server Index Fragmentation (brentozar.com) Why SQL Server Index Fragmentation Isn’t A Problem On Modern Storage Hardware – Darling Data (erikdarling.com) Index fragmentation scripts: microsoft-dbas-club/Indexes/Table and Index High Unused Space.sql at MadeiraData/microsoft-dbas-club Check Index Fragmentation Based on Page Fullness and Fill Factor Upcoming webinar at the Cloud Data Driven Meetup: Database DevOps for Leaders - Eitan Blumin, Thu, Oct 24, 2024, 12:00 PM | Meetup…

1
Episode 167 - Let's Troubleshoot SQL AG Synchronization Latency 37:40

לפני 43 weeks37:40

37:40

Fair warning for all listeners! Before starting to listen to this podcast, very strongly recommended: Have the diagram at the bottom of this page ready in front of you, so that it'll be easier for you to follow along: Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency - Microsoft Community Hub (sorry in advance!) Additional relevant links: Index cleanup : Harder than it looks - Simple Talk (red-gate.com) Find Overlapping Indexes.sql at chadbaldwin/SQL (github.com)…

1
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files 35:32

לפני 47 weeks35:32

35:32

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible. Relevant links: 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub bcp utility - SQL Server | Microsoft Learn Altering lock escalation for SQL Server tables (mssqltips.com) dbatools docs | Import-DbaCsv A Fast Way to Load Large CSV Files into Microsoft SQL Server | by Sasha Korovkina…

1
Episode 165 - News in Azure SQL and Woes of Excel 38:44

לפני 52 weeks38:44

38:44

Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correctly in AlwaysOn Availability Groups. Relevant links: SQLBits Free Videos - YouTube JSON data type (preview) - SQL Server | Microsoft Learn Efficient Time-Based Audit Log Filtering for Azure SQL Database - Microsoft Community Hub UNISTR and ANSI SQL concatenation operator (||) (microsoft.com) SQL Server on Azure VMs: I/O analysis (preview) - Microsoft Community Hub Announcing the retirement of SQL Server Stretch Database - Microsoft SQL Server Blog 30 SQL Server Security Checks in 30 Days Archives - Straight Path Solutions Use Sparse Columns - SQL Server | Microsoft Learn SQL Server Jobs & AlwaysOn Interoperability | HADRMyJobs…

1
Episode 164 - The Good the Bad and the Ugly Transactional Replication 35:32

לפני 1 year35:32

35:32

Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases. Also, some important announcements from Microsoft about Azure SQL! Relevant links: Data API builder General Availability (microsoft.com) Build REST API with Azure Data API Builder (DAB) (mssqltips.com) Zero ETL, Near-real time replication, Mirroring Azure SQL Databases in Fabric (microsoft.com) Announcing EAP for Vector Support in Azure SQL Database - Azure SQL Devs’ Corner (microsoft.com) Update Policy for Azure SQL Managed Instance - Microsoft Community Hub Transactional Replication - SQL Server | Microsoft Learn MadeiraData/ReplicationManagementMechanism: Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures (github.com)…

1
Episode 163 - When and Why to HADR 34:37

לפני 1 year34:37

34:37

Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them. Relevant links for further reading: AlwaysOn Basic Availability Groups / Database Mirroring AlwaysOn "Enterprize" Availability Groups Failover Cluster Instance Log Shipping Transactional Replication…

ברוכים הבאים אל Player FM!

Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.

תקשיבו ל-500+ נושאים

392 subscribers

דומה לSQL Server Radio

Bounty Quick Size Paper Towels, White, 8 Family Rolls = 20 Regular Rolls (Packaging May Vary)

Amazon eGift Card - Bright Balloons (Animated)

Dr. Elsey's Ultra UnScented Clumping Clay Cat Litter 40 lb. Bag

פודקאסטים ששווה להאזין

SQL Server Radio « » Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

פודקאסטים ששווה להאזין

ברוכים הבאים אל Player FM!

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

Mighty Patch™ Original patch from Hero Cosmetics – The #1 Hydrocolloid Acne Pimple Patch for Shrinking Zits and Whiteheads in 1 use; Nighttime Spot Stickers for Face and Skin (36 Count)

Crayola Crayons Bulk (24 Packs), Kids Back to School Essentials, Teacher Classroom Must Haves, Bulk School Supplies for Preschool & Kindergarten

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

דומה לSQL Server Radio

מדריך עזר מהיר

SQL Server Radio « »
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files