Look for any podcast host, guest or anyone
Showing episodes and shows of

SQL Server Radio

Shows

Tina Huang
Tina HuangData Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #8 | Tina HuangData Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #8Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates ======================== My SQL for data science interviews course (10 full interviews): https://365datascience.com/learn-sql-for-data-science-interviews/365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina📲Socials ======================== instagram: https://www.instagram.com/hellotinah/linked...
2026-02-0809 minTina Huang
Tina HuangSQL Data Science Interview Questions and Answers (interview style walk-through) | SQL Sundays #4 | Tina HuangSQL Data Science Interview Questions and Answers (interview style walk-through) | SQL Sundays #4Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates ======================== My SQL for data science interviews course (10 full interviews): https://365datascience.com/learn-sql-for-data-science-interviews/365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina📲Socials ======================== instagram: https://www.instagram.com/hellot...
2026-02-0706 minMiner Vino
Miner Vino[PDF] download SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights BY Cathy Tanimura on Audiobook New VersionDOWNLOAD epub SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights BY Cathy Tanimura on Audiobook New Edition Read Online SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights is a great book to read and that’s why I recommend reading or downloading ebook SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights for free in any format with visit the link button below. Visit Link Bellow You Can Download Or Read Free Books   Link To Download => https://softebooks.com/?book=1492088781 Available ver...
2026-02-0600 minMiner Vino
Miner Vino[PDF/Kindle] SQL All-in-One For Dummies (For Dummies (Computer/Tech)) BY Allen G. Taylor Online Full FormatEPUB download SQL All-in-One For Dummies (For Dummies (Computer/Tech)) BY Allen G. Taylor on Kindle New Edition Read Online SQL All-in-One For Dummies (For Dummies (Computer/Tech)) is a great book to read and that’s why I recommend reading or downloading ebook SQL All-in-One For Dummies (For Dummies (Computer/Tech)) for free in any format with visit the link button below. Visit Link Bellow You Can Download Or Read Free Books   Link To Download => https://softebooks.com/?book=1394242298 Available versions: EPUB, PDF, MOBI, DOC, Kindle, Audiobook, etc. ...
2026-02-0600 minM365.FM - Modern work, security, and productivity with Microsoft 365
M365.FM - Modern work, security, and productivity with Microsoft 365Beyond SELECT: Why T-SQL Still Shapes Modern Data StrategyMost organizations believe modern platforms like Microsoft Fabric made SQL optional. This episode explains why that belief is dangerously wrong. T-SQL didn’t disappear—it moved upstream, into the layer where cost overruns, security drift, performance incidents, and audit findings are created long before anyone notices them. “Beyond SELECT” doesn’t mean beyond SQL; it means beyond responsibility. This episode reframes T-SQL as what it really is in modern data platforms: a contract language for enforcing intent—truth, access boundaries, and predictable compute—in systems that otherwise drift into entropy. If your cloud costs feel random, your dashboards disagree, or your security...
2026-01-1052 minProgramming Tech Brief By HackerNoon
Programming Tech Brief By HackerNoonI Got 15K People to Practice SQL by Turning Them Into Detectives This story was originally published on HackerNoon at: https://hackernoon.com/i-got-15k-people-to-practice-sql-by-turning-them-into-detectives. See how SQL Case Files became a top choice for anyone searching for free SQL games or challenging SQL puzzles. Check more stories related to programming at: https://hackernoon.com/c/programming. You can also check exclusive content about #sql, #learn-sql, #gamifying-sql, #sql-practice, #sql-case-files, #practice-sql, #sql-puzzles, #challenging-sql-puzzles, and more. This story was written by: @hackstarky. Learn more about this writer by checking @hackstarky's about page, and for more stories, please visit hackernoon.com. SQL practice is boring because you're querying...
2025-12-1911 minM365.FM - Modern work, security, and productivity with Microsoft 365
M365.FM - Modern work, security, and productivity with Microsoft 365The Secret to Putting SQL Data in Copilot Studio(00:00:00) The Limitations of AI Without Data (00:00:30) The Data Gateway: A Secure Bridge (00:00:49) The Power of Structured Data (00:03:14) The Data Gateway Explained (00:04:12) Secure and Scalable Implementation (00:07:16) Teaching Copilot to Read Your Data (00:11:33) Giving Copilot Hands: Controlled Write Backs (00:16:36) Designing the Hybrid Brain (00:20:08) The Secret to Hybrid AI Success 🔍 Key Topics Covered 1) Why Copilots Fail Without ContextLLMs without data grounding = fluent hallucinations and confident nonsense.The real memory lives in SQL Server—orders, invoices, inventory—behind the firewall.Hybrid parity goal: cloud intelligence with on-prem control, zero data exposure.2) The Power P...
2025-11-1321 minTina Huang
Tina HuangData Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #7 | Tina Huang Data Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #7 Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates========================My SQL for data science interviews course (10 full interviews):https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data science int...
2025-10-0215 minM365.FM - Modern work, security, and productivity with Microsoft 365
M365.FM - Modern work, security, and productivity with Microsoft 365R or T-SQL? One Button Changes EverythingHere’s a story: a team trained a model, everything worked fine—until the dataset doubled. Suddenly, their R pipeline crawled for hours. The root cause wasn’t the algorithm at all. It was compute context. They were running in local compute, dragging every row across the network into memory. One switch to SQL compute context pushed the R script to run directly on the server, kept the data in place, and turned the crawl into a sprint. That’s the rule of thumb: if your dataset is large, prefer SQL compute context to avoid moving rows over the network. Try it y...
2025-10-0219 minTina Huang
Tina HuangData Science SQL Interview Question Walkthrough | SQL Sundays #5 | Tina Huang Data Science SQL Interview Question Walkthrough | SQL Sundays #5 Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates========================My SQL for data science interviews course (10 full interviews):https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data science interview prep: htt...
2025-09-3017 minTina Huang
Tina HuangSQL Data Science Interview Question Walkthrough | SQL Sundays #6 | Tina Huang SQL Data Science Interview Question Walkthrough | SQL Sundays #6 Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates========================My SQL for data science interviews course (10 full interviews):https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data science interview prep: htt...
2025-09-2109 minTina Huang
Tina HuangReal Data Science SQL Interview Questions and Answers # 2 | Data Science Interview Questions | Tina Huang Real Data Science SQL Interview Questions and Answers # 2 | Data Science Interview Questions Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates========================My SQL for data science interviews course (10 full interviews):https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data sci...
2025-09-2114 minM365.FM - Modern work, security, and productivity with Microsoft 365
M365.FM - Modern work, security, and productivity with Microsoft 365LINQ to SQL: Magic or Mayhem?Have you ever written a LINQ query that worked perfectly in C#, but when you checked the SQL it generated, you wondered—how on earth did it get to *that*? In this session, you’ll learn three things in particular: how expression trees control translation, how caching shapes performance and memory use, and what to watch for when null logic doesn’t behave as expected. If you’ve suspected there’s black-box magic inside Entity Framework Core, the truth is closer to architecture than magic. EF Core uses a layered query pipeline that handles parsing, translation, caching, and materialization behind the scenes...
2025-09-1819 minTina Huang
Tina HuangData Science SQL Interview Question Walkthrough | SQL Sundays #9 | Tina Huang Data Science SQL Interview Question Walkthrough | SQL Sundays #9 Hi friends! Here's a SQL Sunday as part of the SQL Sundays series in celebration of the launch of my SQL for tech and data science interviews course! I know I know it's Tuesday :x Can we let this one slide? SQL for tech and data science interviews course with 10 mock interviews: https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=DF947818F15A561AE84E ($12.99 promotion until July 18th, 2021!) [expired] https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=A92E9C5BFB043A8FF039 ($9.99 promotion until...
2025-09-1417 minAhmad Hardyoni
Ahmad Hardyonipdf ?? SQL: Learn SQL (Using MySQL) in One Day and Learn It Well. SQL for Beginners with Hands-On Project by LCF PublishingTo Download or Read SQL: Learn SQL (Using MySQL) in One Day and Learn It Well. SQL for Beginners with Hands-On Project by LCF Publishing Visit Link Bellow You Can Download Or Read Free Books   Link To Download => https://closingbook.blogspot.com/id/1731039662 Available versions: EPUB, PDF, MOBI, DOC, Kindle, Audiobook, etc. read (PDF) SQL: Learn SQL (Using MySQL) in One Day and Learn It Well. SQL for Beginners with Hands-On Project pdf read (PDF) SQL: Learn SQL (Using MySQL) in One Day and Learn It Well. SQL for Be...
2025-09-0300 minTina Huang
Tina HuangReal Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions | Tina Huang Real Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates========================My SQL for data science interviews course (10 full interviews):https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data sci...
2025-08-2213 minTina Huang
Tina HuangSQL Data Science Interview Questions and Answers (interview style walk-through) | Question 3 | Tina Huang SQL Data Science Interview Questions and Answers (interview style walk-through) | Question 3 Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.This is another data science SQL interview question and answer done from beginning to end in a real interview style.🔗Affiliates========================My SQL for data science interviews course (10 full interviews):https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training)Check out StrataScratch for data science int...
2025-07-2117 min岡大徳のポッドキャスト
岡大徳のポッドキャストSQL不要！miiboで15分で作る分析AIがデータ活用を革新する方法株式会社miibo代表のmaKunugi氏が、SQLの知識がなくても高度なデータ分析を実現する画期的な方法を公開しました。同氏のnote記事では、会話型AI構築プラットフォーム「miibo」を活用し、わずか15分で自然言語によるデータベース検索を可能にする「分析AI」の構築手法を詳細に解説しています。この革新的なアプローチは、データ分析の民主化を大きく前進させる可能性を秘めています。今回紹介された手法の最大の特徴は、完全ノーコードでの実装です。SQLが書けない人でも、BigQueryと連携した本格的な分析AIを構築できます。完成したAIは、「今月の売上はどうだった？」といった自然な問いかけに対して、自動的にSQLを生成・実行し、分析結果を返します。この技術により、データ分析チームへの依頼待ちという業務上のボトルネックが解消され、誰もが即座にデータドリブンな意思決定を行えるようになります。Text2SQL技術が実現する新しいデータ分析の形maKunugi氏の記事で紹介された分析AIは、Text2SQL技術を活用しています。この技術により、自然言語の質問を適切なSQLクエリに自動変換することが可能になりました。記事では、実際の構築プロセスを通じて、この革新的な技術の実装方法を具体的に示しています。分析AIの構築には、Google Cloud PlatformのBigQueryを使用します。BigQueryは、大規模なデータセットに対して高速なクエリ実行を可能にするサーバーレスのデータウェアハウスです。miiboとBigQueryを連携させることで、企業が保有する膨大なデータに対して、SQLの知識なしにアクセスできる環境を構築できます。記事では、サービスアカウントの作成からAPIの有効化まで、BigQuery側の準備について詳しく解説されています。セキュリティ面での注意点も含まれており、実務での利用を想定した実践的な内容となっています。特に、必要最小限の権限設定やキーファイルの管理方法など、エンタープライズ環境での利用に不可欠な情報が網羅されています。miiboの革新的な機能が可能にする爆速AI開発miiboの新機能であるCustom ActionとWebhooksを活用することで、外部サービスとの連携が驚くほど簡単になりました。記事では、BigQueryとの連携に必要な2つのテンプレート「BigQuery SQL実行」と「BigQuery スキーマ取得」の設定方法を詳細に説明しています。Custom Action機能により、複雑なAPI連携もテンプレートを選択するだけで実装可能です。環境変数の設定として、サービスアカウントのJSONキーとプロジェクトIDを入力するだけで、BigQueryとの接続が確立されます。この簡便さは、従来のシステム開発では考えられないレベルの効率化を実現しています。Webhooks設定では、AIがデータベースのスキーマ情報を取得するタイミングとSQLを実行するタイミングを自動判断するように設定できます。Function Callingの仕組みを活用し、ユーザーの意図を理解して適切なアクションを実行する、真に実用的なAIアシスタントが構築できます。実務で即活用できる具体的な構築手順記事の最大の価値は、理論だけでなく実際に動作する分析AIを構築できる具体的な手順が示されている点です。プロンプトエンジニアリングの観点からも興味深い内容で、提供されているプロンプトテンプレートは実務ですぐに活用できます。提供されているプロンプトでは、AIの役割定義から制約事項、エラーハンドリングまで、実用的なAIアシスタントに必要な要素がすべて含まれています。特に注目すべきは、SQLエラー時の処理方法です。エラーが発生した場合には原因を分析し、修正案を提示するという高度な機能が実装されています。完成した分析AIは、miibo Agent Hubを通じて利用できます。また、miiboの特徴として、作成したエージェントはチャット画面だけでなく、LINE、Slack、API経由でも利用可能です。これにより、既存の業務フローに自然に組み込むことができ、真に「溶けこむAI」として機能します。データ分析の民主化がもたらす組織変革maKunugi氏が示した手法は、単なる技術的なソリューションを超えて、組織のデータ活用文化を変革する可能性を秘めています。SQLが書けない営業担当者やマーケティング担当者も、自分のタイミングでデータに基づいた意思決定ができるようになります。この変化は、組織全体のアジリティ向上に直結します。データ分析チームの負担軽減も大きなメリットです。定型的な分析依頼から解放され、より高度な分析や戦略立案に時間を割けるようになります。また、分析AIが生成するSQLを学習材料として活用すれば、非エンジニアのSQL学習にも役立ちます。記事では触れられていませんが、この技術は教育分野でも大きな可能性を持っています。データサイエンス教育において、SQLの文法学習に時間を費やす代わりに、データから洞察を得る本質的なスキルの習得に集中できるようになるでしょう。まとめmaKunugi氏が公開した「SQLが書けなくても大丈夫！代わりにSQLを書いて分析してくれる『分析AI』を爆速で作る方法」は、miiboの実用性と革新性を示す優れた実例です。わずか15分でSQLの知識なしに高度な分析AIを構築できるこの手法は、データ活用の新しい時代を切り開く可能性を秘めています。ノーコードでありながら本格的な機能を実現するmiiboの技術力と、それを実務に即した形で紹介するmaKunugi氏の知見が組み合わさることで、真に価値あるソリューションが生まれました。データドリブンな意思決定を全社員が行える未来は、もうすぐそこまで来ています。 Get full access to 岡大徳のメルマガ at www.daitoku0110.news/subscribe
2025-07-1806 minGeek Capsule
Geek CapsuleFundamentals - SQL00:00:00 Database Design00:02:15 Normalization00:04:49 Numeric Data in SQL00:07:09 Temporal Data Types in SQL00:09:30 Character Data Types in SQL00:11:31 NULLs: Missing Data in SQL00:13:38 Multiple Column Data Elements00:15:34 Table Operations00:18:09 Comparison or Theta Operators00:19:39 Valued Predicates00:21:18 CASE Expressions00:23:33 LIKE Predicate00:25:06 BETWEEN and OVERLAPS Predicates00:26:35 The [NOT] IN() Predicate00:28:14 EXISTS() Predicate00:29:54 Quantified Subquery Predicates00:31:50 The SELECT Statement00:33:37 VIEWs, Derived Tables, Materialized Tables, and Temporary Tables00:35:41 Partitioning...
2025-06-281h 00Azure & DevOps Podcast
Azure & DevOps PodcastBob Ward: SQL Server 2025 - Episode 354Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL Edge to Cloud. Bob has worked for Microsoft for 31-plus years on every version of SQL Server shipped, from OS/2 1.1 to SQL Server 2025, including Azure SQL. Bob is a well-known speaker on SQL Server, Azure SQL, AI, and Microsoft Fabric, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, DevIntersection, and VS Live. You can also learn Azure SQL from him on the popular series https://aka.ms...
2025-06-1642 minThe sql_squared Podcast!!!
The sql_squared Podcast!!!sql_squared: Ep. 4 - The Data Community & Database Testing w/ Lee BrownhillSend us a textIn this episode of The sql_squared Podcast, we're joined by our special guest, Lee Brownhill, for a deep dive into unit testing for databases, the importance of community, and the future of data platforms. As an expert with nearly 20 years of experience as a DBA and cloud consultant , Lee shares his unique insights on implementing the T-SQLT framework to create robust SQL unit tests. This conversation is centered around our guest's experiences and knowledge. Listeners will walk away with a deeper understanding of how to get started with T-SQLT , practical t...
2025-06-1157 minThe sql_squared Podcast!!!
The sql_squared Podcast!!!sql_squared: Ep. 3 - Database DevOps, Blogs & Speaking w/ Tonie HuizerSend us a textWelcome back to SQL Squared! In this episode, host David Morgan-Gumm is joined by Tonie Huizer, a respected Database DevOps expert, known for his blog posts for Redgate and his speaking engagements globally.Tonie, head of the Microsoft-focused consultancy ProMicro in the Netherlands, shares his journey into the data field. The conversation dives into his involvement with the recent SQL.NL event, aiming to recapture the SQL Saturday focus on SQL Server, and his podcasts, including The Tony and Tony Show which highlights Redgate articles.The core of the...
2025-06-1048 minSQL Server Radio
SQL Server RadioEpisode 176 - SQL Server 2025 and moreMany 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...
2025-06-0938 minEventual Consistency | Your reality check on what\'s actually happening in data.
Eventual Consistency | Your reality check on what's actually happening in data.Enhancing Developer Efficiency with SQL Mesh | Featuring Toby MaoIn this episode of Data BS, host James Winegar and Toby Mao, CTO and co-founder of Tobiko Data, discuss the development of SQL Mesh, insights from Toby’s experiences at Netflix and Airbnb exploring the innovative features of SQL Mesh, and the ability to promote data transformations to production seamlessly. Join us for a great conversation about how Toby co-founded his company and what’s next for the future in SQL Mesh. Introduction to Tobiko and SQL MeshVirtual Data Environments and Instant DeploymentsIntroduction to SQL Mesh and CI/CD IntegrationSQL Glot: Standardizing SQL Across PlatformsType Annotations and...
2025-02-2638 minDane Są Wszędzie
Dane Są Wszędzie# 4 - Data Community Poland - SQL Day - Od przeszłości do najnowszej działalności - rozmowa z Hubertem KobierzewskimCześć, Dzisiaj zapraszam do przesłuchania rozmowy z Hubertem Kobierzewskim, którego możesz kojarzyć w ramach działalności w Data Community Poland czy konferencji SQL Day. Wyszedł nam "kawał" ciekawej, podcastowej rozmowy. Od tego jak to wszystko się zaczęło i jak budowała się Społeczność, aż do dzisiejszej działalności Data Community Poland. Będzie trochę o SQL Dayu, w tym o nadchodzącej edycji 2025. Dowiesz się o kulisach, Gościach, o tym co zrobić, jeśli sądzisz, że masz ciekawy temat do zaprezentowania, wsparciu Wolontariuszy i nie tylko. Porozmawialiśmy też o działal...
2025-02-161h 01Engineering Kiosk
Engineering Kiosk#182 Happy Birthday SQL: 50 Jahre AbfragespracheÜber 50 Jahre Queries: Das relationale Datenbankmodell und die Sprache SQL haben Geburtstag!Relationale Datenbanken und die Abfragesprache SQL sind aus der modernen Welt nicht mehr wegzudenken. Egal ob du eine eigene Webseite mit WordPress betreibst, Business Intelligence Analysen für eine Versicherung machst oder die größte Oracle Datenbank der Welt betreibst - In allen Use Cases kommt das relationale Datenbankmodell und die Sprache SQL zum Einsatz.Und SQL ist bei weitem kein neuer heißer Scheiß. SQL ist inzwischen 50 Jahre alt und das relationale Datenbankmodell ist sogar noch 5 Jahre älter als SQL! Welche Technologie fällt d...
2025-02-111h 05VMware Communities Roundtable
VMware Communities Roundtable#713 - Disaster Recovery for MS SQL Server Workloads in VMware Cloud Foundation w/​​Deji AkomolafeTopic: Disaster Recovery for MS SQL Server Workloads in VMware Cloud Foundation The Importance of a Reliable Disaster Recovery Plan "Deji, disaster recovery (DR) planning is often overlooked until an actual disaster occurs. Why is it particularly crucial for MS SQL Server workloads, and what are the most common mistakes enterprises make when it comes to protecting mission-critical databases?" VMware Live Recovery (VLR): Transforming Disaster Recovery in VCF "Let’s talk about VMware Live Recovery (VLR)—VMware’s solution for disaster recovery within VMware Cloud Foundation (VCF). Can you explain what VLR does and how it ensures a reliable, repeatable, and si...
2025-02-051h 03TechCentral (main feed)
TechCentral (main feed)TCS+ | Shifting Microsoft Azure SQL into overdriveMicrosoft Azure SQL is a fully managed and scalable cloud database service – and its myriad benefits mean your company should be considering it if it isn’t already using it. To unpack this in more detail, Preegan Chetty, Microsoft Azure product manager at First Distribution, and Silicon Overdrive Microsoft business executive Jody Roberts join TechCentral’s business technology show TCS+. In the episode, they unpack: • The relationship between First Distribution and Silicon Overdrive; • Silicon Overdrive’s market focus; • What Azure SQL is and how it’s helping companies with their digital transformation initiatives; • Why many South African...
2025-01-2724 minTCS+
TCS+Shifting Microsoft Azure SQL into overdriveMicrosoft Azure SQL is a fully managed and scalable cloud database service – and its myriad benefits mean your company should be considering it if it isn’t already using it. To unpack this in more detail, Preegan Chetty, Microsoft Azure product manager at First Distribution, and Silicon Overdrive Microsoft business executive Jody Roberts join TechCentral’s business technology show TCS+. In the episode, they unpack: • The relationship between First Distribution and Silicon Overdrive; • Silicon Overdrive’s market focus; • What Azure SQL is and how it’s helping companies with their digital transformation initiatives; • Why many South African...
2025-01-2724 minLearn to Code in One Month
Learn to Code in One MonthTop 6 Reasons to Learn SQL in 2025SQL is the language of databases. In your career, if you plan to work with machine learning, artificial intelligence, build websites or apps or work with data analytics, you're going to need to know SQL.   In this episode of the Learn to Code podcast I'm going to dive deep into the top 6 reasons why you should be learning SQL. I'll cover:  * What is SQL? * How popular is SQL? * What famous websites use SQL?  * SQL vs. Python? * Excel vs. SQL Databases  1. What's SQL? SQL is the language of databases. In you...
2024-12-2818 minDataFramed
DataFramedBest of 2024: 50 Years of SQL with Don Chamberlin, Computer Scientist and Co-Inventor of SQLAs we look back at 2024, we're highlighting some of our favourite episodes of the year, and with 100 of them to choose from, it wasn't easy!The four guests we'll be recapping with are:Lea Pica - A celebrity in the data storytelling and visualisation space. Richie and Lea cover the full picture of data presentation, how to understand your audience, how to leverage hollywood storytelling and more. Out December 19.Alex Banks - Founder of Sunday Signal. Adel and Alex cover Alex’s journey into AI and what led him to create Sunday Signal, the potential of AI, p...
2024-12-2636 minAzure & DevOps Podcast
Azure & DevOps PodcastBob Ward: SQL Server - Episode 321Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL Edge to Cloud. Bob has worked for Microsoft for 30-plus years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022, including Azure SQL. Bob is a well-known speaker on SQL Server, Azure SQL, AI, and Microsoft Fabric, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, DevIntersection, and VS Live. You can also learn Azure SQL from him on the popular series aka.ms/azuresql4...
2024-10-2840 minTech Sessions
Tech SessionsEp. 8: Maximizing Efficiency: Cost Optimization through SQL Server Re-architecture on Google CloudIn this episode of the Tech Sessions podcast, host Jeff Dickman sits down with Roy Douber, Senior Director of DevOps and Architecture at e360, to discuss SQL migrations, cost optimization, and performance improvements through SQL Server re-architecture on Google Cloud. Discover how e360 tackles large-scale SQL environments to deliver significant cost savings and enhanced performance for their clients.Topics Covered:Initial challenges and state analysis of the client's SQL environmentImplementing failover clustering and automation for improved performanceAchieving significant cost savings and operational efficienciesKey Takeaways:The importance of a thorough financial analysis alongside...
2024-10-2342 minMavens of Data
Mavens of DataEvery Data Professional Needs To Learn SQL (w/ Thais Cooke)SQL is one of the most widely used data analysis tools around, often discussed as a cornerstone for Data Analysis, Data Science, and Data Engineering careers. In this episode, Thais Cooke talks about how she leverages SQL in her role as a Data Analyst and shares practical tips you can use to take your SQL game to the next level. You'll leave the show with an insider's perspective on where SQL adds the most value, and where you should focus if you want to build SQL skills that will advance your career. What Y...
2024-10-1853 minSQL Server Radio
SQL Server RadioEpisode 168 - New data types in SQL Server and a question about index fragmentationGuy 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...
2024-10-1432 minSQL Data Partners Podcast
SQL Data Partners PodcastEpisode 279: SQL Server Migrations DemystifiedIf you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we know there are risks and many things that can go wrong, the "new" Microsoft continues to put time and effort towards making successful SQL Server migrations attainable for everyone. In this episode of the podcast, we ch...
2024-09-201h 03SQL Data Partners Podcast
SQL Data Partners PodcastEpisode 279: SQL Server Migrations DemystifiedIf you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we know there are risks and many things that can go wrong, the "new" Microsoft continues to put time and effort towards making successful SQL Server migrations attainable for everyone. In this episode of the podcast, we ch...
2024-09-201h 03Oracle University Podcast
Oracle University PodcastEnhancements in SQL Plan Management, SecureFiles LOB Write Performance, and Column WidthJoin Lois Houston and Nikita Abraham, along with Senior Principal Database & Security Instructor Ron Soltani, as they discuss how the new Automatic SQL Plan Management feature in Oracle Database 23ai improves performance consistency and simplifies management. Then, Senior Principal Database & MySQL Instructor Bill Millar shares insights into two new features: one that enhances SecureFiles LOB Write Performance, improving read and write speeds, and another that increases the column limit in a table to 4,096, making it easier to handle complex data. Oracle MyLearn: https://mylearn.oracle.com/ou/course/oracle-database-23ai-new-features-for-administrators/137192/207062 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn...
2024-09-1717 minLearn to Code in One Month
Learn to Code in One MonthThe Complete Guide to Learn SQL in Just 15 Minutes for FreeSQL is the language of databases, and SQL programmers are in high demand. This week, I want to share how to learn SQL for free — and in your spare time — during quarantine. All you need to get started is access to an MYSQL database, as well as some datasets to play around with. 1. Install a Database — If you want to learn SQL, you're going to need a SQL database. One of the easiest ways to get a database is to register for a shared hosting account. If you go to hostgator.com and enter the code "onemonthcode,″ you'll g...
2024-08-0112 minJust Five Mins!
Just Five Mins!Episode 89 - MS-SQL Memory Optimised TablesMemory-Optimized Tables, also known as In-Memory OLTP, were introduced in SQL Server 2014. This feature was further enhanced in subsequent versions of SQL Server, including SQL Server 2016, 2017, and in Azure. However, in Azure, they're only available in the Premium tier.Memory-Optimized Tables in SQL Server are a feature that provides significant performance improvements by storing table data in memory and optimizing data access. Here's an overview:* What are Memory-Optimized Tables? Memory-Optimized Tables are tables that have their data completely held in memory, eliminating disk access except for durability purposes. This allows SQL Server to redesign how...
2024-07-2805 minSQL Server Radio
SQL Server RadioEpisode 165 - News in Azure SQL and Woes of ExcelGuy 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 H...
2024-07-0838 minSQL Data Partners Podcast
SQL Data Partners PodcastEpisode 276: Dynamic SQL and Testing in IsolationListener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQL can open the door to many undesirable results - SQL Injection attacks being the most frightening of these. It can also be difficult to read, making maintenance problematic; however, in this episode one brave soul - Marathon's own Laura Moss - explains how she uses Dynamic SQL to help refresh a subset of production data to be used in their development environments. You know...
2024-05-2141 minSQL Data Partners Podcast
SQL Data Partners PodcastEpisode 276: Dynamic SQL and Testing in IsolationListener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQL can open the door to many undesirable results - SQL Injection attacks being the most frightening of these. It can also be difficult to read, making maintenance problematic; however, in this episode one brave soul - Marathon's own Laura Moss - explains how she uses Dynamic SQL to help refresh a subset of production data to be used in their development environments. You know...
2024-05-2141 minRunAs Radio
RunAs RadioSQL Server and AI with Muazma Zahid & Bob WardHow does artificial intelligence fit in with SQL Server? At the Microsoft Fabric Conference in Las Vegas, Richard sat down with Muazma Fahid and Bob Ward to discuss the AI developments in SQL Server. Muazma talks about SQL Server as a crucial source of data for building machine learning models and the new features added to make SQL Server a key store for vector data and other elements of machine learning. There's also Copilot for Azure SQL Data to help with diagnostics in your databases and to use natural language to write queries - it SQL Server Natural Language...
2024-05-0134 minDataFramed
DataFramed#200 50 Years of SQL with Don Chamberlin, Computer Scientist and Co-Inventor of SQLOver the past 199 episodes of DataFramed, we’ve heard from people at the forefront of data and AI, and over the past year we’ve constantly looked ahead to the future AI might bring. But all of the technologies and ways of working we’ve witnessed have been built on foundations that were laid decades ago. For our 200th episode, we’re bringing you a special guest and taking a walk down memory lane—to the creation and development of one of the most popular programming languages in the world.Don Chamberlin is renowned as the co-inventor of SQL (St...
2024-04-2236 minInsights Tomorrow
Insights TomorrowLooking Back at the Evolution of SQL Server with Bob WardOn today's episode of Insights Tomorrow, Patrick LeBlanc and Bob Ward, Principal Architect for Microsoft SQL, join the show to discuss Bob's career journey. Starting from his college days, working on C programming against mainframe databases, and later specializing in database products like Ingress and Oracle, Bob shares his transition to Microsoft. He details joining the technical support team for SQL Server when internet and email were absent, relying on phone and fax communication. The conversation delves into the challenges of transitioning from on-premises databases to SQL and VM in Azure. Bob and Patrick touch on performance concerns and...
2024-03-1330 minInsights Tomorrow
Insights TomorrowLooking Back at the Evolution of SQL Server with Bob WardOn today's episode of Insights Tomorrow, Patrick LeBlanc and Bob Ward, Principal Architect for Microsoft SQL, join the show to discuss Bob's career journey. Starting from his college days, working on C programming against mainframe databases, and later specializing in database products like Ingress and Oracle, Bob shares his transition to Microsoft. He details joining the technical support team for SQL Server when internet and email were absent, relying on phone and fax communication. The conversation delves into the challenges of transitioning from on-premises databases to SQL and VM in Azure. Bob and Patrick touch on performance concerns and...
2024-03-1330 minPostgres FM
Postgres FMModern SQLMichael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, and author of SQL Performance Explained, to discuss Modern SQL — what Markus means by it, why it's important, some benefits, some examples, and at least one phrase that should be on a t-shirt. Here are some links to things they mentioned:Modern SQL (site) https://modern-sql.comUse the index, Luke! (site) https://use-the-index-luke.comSQL Performance Explained (book) https://sql-performance-explained.comOur episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknownIS DISTINCT FROM (null-safe not equals comparison) https://modern-sql.com/caniuse/is-distinct-fromUNIQUE NULLS DISTINCT https://modern-sql.com...
2024-02-0232 minKajoData - Analiza danych dla każdego
KajoData - Analiza danych dla każdegoSQL To Najważniejsza Technologia w IT | Dlaczego nauka SQLa jest taka ważna dla analityka | KajoData Podcast Chcesz opanować SQLa: https://kajodata.com/kursy/kurs-sql-dla-poczatkujacych/ SQL, czyli Structured Query Language, mimo rosnącej popularności sztucznej inteligencji, nadal pozostaje jedną z najważniejszych technologii, które powinieneś znać, jeśli zamierzasz jakkolwiek pracować z danymi. Serce Baz Danych: Większość przedsiębiorstw na świecie korzysta z baz danych, które obsługują SQL. Wiedza o tym, jak z nich korzystać, otwiera drzwi do analizy i manipulacji ogromnych zbiorów danych w praktycznie każdej branży. Nie tylko do wyciągania danych: SQL pozwala nie tylko na pobieranie, ale także na dodawanie, aktualizację i usuwanie danych, co umożliwia pełn...
2023-12-1517 minEngineering Kiosk
Engineering Kiosk#99 Modernes SQL ist mehr als SELECT * FROM - mit Markus WinandSQL is Dead, Long Live SQL!Fast jede Applikation hat irgendeine Form von persistenter Datenhaltung. Oft in Form einer Datenbank. Der Platzhirsch bei Datenbanken sind Systeme, die sich mit der Structured Query Language (kurz SQL) abfragen lassen. MySQL, PostgreSQL, Oracle, MSSQL Server, sqlite, Google BigQuery und so weiter.Die coolen Kids haben vielleicht irgendeine Form von NoSQL-Datenbank im Einsatz. Aber auch da kommt man nicht um SQL herum.Für die meisten Entwickler*innen ist SQL ein alter Hut. SELECT * FROM Tabelle WHERE foo = bar GROUP BY id. Das haben wohl die meisten g...
2023-11-281h 19Talking Postgres with Claire Giordano
Talking Postgres with Claire GiordanoSolving every data problem in SQL w/Dimitri Fontaine & Vik FearingIs being lazy a good reason to learn SQL? Dimitri Fontaine and Vik Fearing join Claire Giordano and Pino de Candia on the Path To Citus Con* podcast for developers who love Postgres—to discuss whether every data problem can be (or should be) solved in SQL. Have you tried to solve all the Advent of Code puzzles with SQL? Or written a book for application developers about The Art of PostgreSQL? Or tried to solve a murder mystery by running SQL queries? Regardless of whether you pronounce SQL as “sequel” or as “ess-cue-ell”, getting skilled at SQL is like going...
2023-11-031h 17Unplugged
UnpluggedUnplugged 96: Azure Data, SQL Database, PostgreSQL, ...Hoy toca hablar de novedades de Microsoft y de las últimas capacidades de Azure SQL Database, PostgreSQL, .... MICROSOFT: - Microsoft and Adobe partner to deliver cost savings and business benefits https://azure.microsoft.com/en-us/blog/microsoft-and-adobe-partner-to-deliver-cost-savings-and-business-benefits/ - How we interact with information: The new era of search https://azure.microsoft.com/en-us/blog/how-we-interact-with-information-the-new-era-of-search/ - Driving performance and enhancing services across Three UK’s 5G network https://azure.microsoft.com/en-us/blog/driving-performance-and-enhancing-services-across-three-uks-5g-network/ - Microsoft and Accenture partner to tackle methane emissions with AI technology https://azure.microsoft.com/en-us/blog/microsoft-and-accenture-partner-to-tackle-methane-emissions-with-ai-technology/ - Welcoming the generative AI era wit...
2023-10-101h 09Люди и код
Люди и кодВведение в SQL: ACID, диалекты, отличия от NoSQL, главные достоинства и недостаткиСодержание выпуска — Что такое SQL: зачем и когда он появился, как развивался и какой он сегодня. — Какие принципы лежат в основе SQL и реляционных баз данных. Что такое декларативная парадигма программирования. — Что такое ACID. — Сильные и слабые стороны SQL. — Какие альтернативы и конкуренты существуют у SQL; — Какие диалекты, реализации SQL существуют, чем и насколько они отличаются друг от друга; — Что у SQL с интероперабельностью. Как он взаимодействует с другими языками. — Есть ли в SQL такое понятие как «линтер». Какой код на языке SQL можно назвать красивым, а какой некрасивым. — Какого размера программы пишут на SQL и насколько их корректно называть программами или скриптами. — Кто такой профессионал в языке SQL? Что он способен делать в отличие от простого пользователя. — Как у SQL обстоят дела с безопасностью. Какие ошибки чаще всего совершают разработчики. — Какими знаниями и навыками, помимо языка, должен обладать специалист по SQL. Кто такой идеальный SQL-щик. — В каких чатах и форумах искать ответы на вопросы. Какие книги читать, на какие каналы подписаться, как и где оттачивать навыки. Гость. Юрий Данилов. CEO в DynSphere, Data Quality Expert. В IT более 17 лет. Начинал системным администратором и DBA в телекоме, руководил командами сопровождения, разработки и DevOps. Участвовал в проектах Альфа-Банка, Сбертеха и Сбербанка. Полезные ссылки Учебные ресурсы: — Руководство по SQL с примерами и упражнениями https://www.w3schools.com/sql/— Раздел с задачами по SQL в Leetcode https://leetcode.com/problemset/database/— Тренажер Hackerrank https://www.hackerrank.com/domains/sql— Уроки SQL с задачами и решениями https://sqlzoo.net/— Песочница для выполнения SQL-запросов онлайн http://sqlfiddle.com/Бесплатные курсы: — https://html5css.ru/sql/default.php — https://sql-academy.org/ru/guide Форумы: — https://forums.mysql.com/ — https://forums.oracle.com/ — https://asktom.oracle.com/ — https://www.postgresql.org/community/ — https://techcommunity.microsoft.com/t5/sql-server/ct-p/SQL-Server Каналы: — https://postgresteam.slack.com — https://mysqlcommunity.slack.com/ Книги: — «Изучаем SQL», Алан Бьюли; — «SQL для чайников», Аллен Тейлор; — «SQL: быстрое погружение», Уолтер Шилдс; — «SQL за 10 минут», Бен Форта; — «SQL. Сборник рецептов», Энтони Молинаро. Предложить тему, стать гостем подкаста, похвалить или поругать выпуск: code.media@skillbox.ru, t.me/antoxa_s95 Стартовать в программировании вместе со Skillbox: skillbox.ru/code Подписывайтесь, ставьте лайки, делитесь с друзьями и оставляйте комментарии!
2023-09-201h 01hickoytigkindle
hickoytigkindleR.E.A.D. [BOOK] SQL Pocket Guide: A Guide to SQL Usage {mobi/ePub}**Download SQL Pocket Guide: A Guide to SQL Usage Full Edition,Full Version,Full Book** by Alice Zhao Reading Now at : https://happyreadingebook.club/?book=1492090409 OR DOWNLOAD EBOOK NOW! [PDF] Download R.E.A.D. [BOOK] SQL Pocket Guide: A Guide to SQL Usage {mobi/ePub} Ebook | READ ONLINE Download R.E.A.D. [BOOK] SQL Pocket Guide: A Guide to SQL Usage {mobi/ePub} read ebook online PDF EPUB KINDLE Download R.E.A.D. [BOOK] SQL Pocket Guide: A Guide to...
2023-09-0600 minhickoytigkindle
hickoytigkindle(Read) PDF SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises [] [PDF]**Download SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises Full Edition,Full Version,Full Book** by Mark Reed Reading Now at : https://happyreadingebook.club/?book= OR DOWNLOAD EBOOK NOW! [PDF] Download (Read) PDF SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises [] [PDF] Ebook | READ ONLINE Download (Read) PDF SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises...
2023-09-0600 minbrusadhandkindle
brusadhandkindlePDF Download& SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (QuickStart Guidesâ„¢ - Technology) !^DOWNLOAD*PDF$**Download SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (QuickStart Guidesâ„¢ - Technology) Full Edition,Full Version,Full Book** by Walter Shields Reading Now at : https://happyreadingebook.club/?book=1945051752 OR DOWNLOAD EBOOK NOW! [PDF] Download PDF Download& SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (QuickStart Guidesâ„¢ - Technology) !^DOWNLOAD*PDF$ Ebook | READ ONLINE Download PDF Download& SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data Wit...
2023-09-0400 minsnowflerbook
snowflerbook{Kindle} SQL Pocket Guide A Guide to SQL Usage Free Book**Download SQL Pocket Guide: A Guide to SQL Usage Full Edition,Full Version,Full Book** by Alice Zhao Reading Now at : https://happyreadingebook.club/?book=1492090409 OR DOWNLOAD EBOOK NOW! [PDF] Download {Kindle} SQL Pocket Guide: A Guide to SQL Usage Free Book Ebook | READ ONLINE Download {Kindle} SQL Pocket Guide: A Guide to SQL Usage Free Book read ebook online PDF EPUB KINDLE Download {Kindle} SQL Pocket Guide: A Guide to SQL Usage Free Book PDF - KINDLE - EPUB - MOBI...
2023-09-0100 minKlatsch无鸡之谈
Klatsch无鸡之谈043 锻炼编程脑：手把手教你令人上瘾的SQL学习法大家好！这一期节目是真正的手把手，边录节目边装环境的那种。如果你需要快速上手SQL，或者很想通过一种浸润的方式获得“编程脑”，也就是俺们程序员的思考方式，那就来听听吧！1:30 学习SQL一点都不难，可以鼓励婆婆一起学（误！3:57 SQL是干嘛的？5:03 数据库是解决什么问题的？11:48 傻白认真地问：excel不行吗？13:30 0基础上手可能吗？14:18 SQL和其他变成语言的关系16:45 学习秘籍：学SQL就像选菜刀切菜！18:48《teach yourself SQL in 10 Minutes》/《SQL必知必会》22:20 第一步：下载软件 （学习过程的最大难点）>>>>>>> 划重点！此处应按下暂停，根据我们的安装提示开始打开链接。如果没有这个打算，建议直接跳到54分处，如果想感受傻白的痛苦，请继续→25:00 看说明书的能力！25:10 继续装34:59 继续装35:20 了解你安装了什么！36:18 继续装（数据库）51:09 继续装（进度条95%了！）>>>>>>> 搭环境过程结束！可以开始玩耍啦！55:25 第二步：终于可以拿出书来学习了！61:30 SQL真的很像excel啊63:48 有人愿意一起来学习这本书吗？附：安装方式下载并安装MySql Community Server和MySQL Workbench，创建schema下载路径：1）安装包：下载地址2）本书的schema文件及安装说明：地址 ，点击MySQL (and MariaDB) SQL scripts，里面的pdf是安装手册注意：1）MacOS不是最新版本的，点击Download Archives找到对应版本2）我安装的时候选了Legacy Encryption，如果选最新Encryption的话会无法连接
2023-09-011h 05nephoionlibrary
nephoionlibrary[PDFBOOKE-PUBMobi] epub_$ Python Programming and SQL The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises [POPULAR]**Download Python Programming and SQL: The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises Full Edition,Full Version,Full Book** by Philip Robbins Reading Now at : https://happyreadingebook.club/?book=B0BZ6MX1Q4 OR DOWNLOAD EBOOK NOW! [PDF] Download [PDF|BOOK|E-PUB|Mobi] epub_$ Python Programming and SQL: The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises [POPULAR] Ebook | READ ONLINE Download [PDF|BOOK...
2023-09-0100 minfalenasvirzbook
falenasvirzbook[PDFBOOKE-PUBMobi] epub_$ Python Programming and SQL The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises [POPULAR]**Download Python Programming and SQL: The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises Full Edition,Full Version,Full Book** by Philip Robbins Reading Now at : https://happyreadingebook.club/?book=B0BZ6MX1Q4 OR DOWNLOAD EBOOK NOW! [PDF] Download [PDF|BOOK|E-PUB|Mobi] epub_$ Python Programming and SQL: The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises [POPULAR] Ebook | READ ONLINE Download [PDF|BOOK...
2023-08-3100 mincellilanabook
cellilanabookebooks SQL 3 books 1 - The Ultimate Beginner Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises [READ PDF] Kindle**Download SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises Full Edition,Full Version,Full Book** by Mark Reed Reading Now at : https://happyreadingebook.club/?book= OR DOWNLOAD EBOOK NOW! [PDF] Download ebooks | SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises [READ PDF] Kindle Ebook | READ ONLINE Download ebooks | SQL: 3 books 1 - The Ultimate Beginner, Intermediate & Expert Guides To Master SQL Programming Quickly with Practical Exercises...
2023-08-3000 minshalienanread
shalienanread$BOOK^ SQL QuickStart Guide The Simplified Beginner's Guide to Managing Analyzing and Manipulating Data With SQL (QuickStart Guidesâ„¢ - Technology) READ PDF EBOOK**Download SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (QuickStart Guidesâ„¢ - Technology) Full Edition,Full Version,Full Book** by Walter Shields Reading Now at : https://happyreadingebook.club/?book=1945051752 OR DOWNLOAD EBOOK NOW! [PDF] Download $BOOK^ SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (QuickStart Guidesâ„¢ - Technology) READ PDF EBOOK Ebook | READ ONLINE Download $BOOK^ SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL...
2023-08-2900 mingwynnraekindle
gwynnraekindleRead Ebook Online Python Programming and SQL The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises Pdf Reader**Download Python Programming and SQL: The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises Full Edition,Full Version,Full Book** by Philip Robbins Reading Now at : https://happyreadingebook.club/?book=B0BZ6MX1Q4 OR DOWNLOAD EBOOK NOW! [PDF] Download Read Ebook Online Python Programming and SQL: The Definitive Guide for Beginners to Learn Python and SQL in 7 Days with Step-by-Step Guidance and Hands-On Exercises Pdf Reader Ebook | READ ONLINE Download Read Ebook Online...
2023-08-2900 minGerilla Karrier Podcast
Gerilla Karrier PodcastMiért érdemes SQL-t és adatbázis-kezelést tanulnod? - Interjú Győri Györggyel - Gerilla Karrier PodcastEbben az epizódban Győri György, informatikai mérnök, tapasztalt SQL oktatóval beszélgetünk az SQL jelentőségéről és felhasználási területeiről. Kérdések, amelyeket az adásban érintünk: - Miért van ilyen nagy jelentősége az SQL-nek? - Milyen munkaterületeken használják? - Milyen pozíciókat tudsz SQL tudással megpályázni? - Mi a különbség az SQL és NoSQL (Not oly SQL) adatbázisok között? - Pontosan...
2023-06-1538 minSociety Tech Brief By HackerNoon
Society Tech Brief By HackerNoonHow to Write Raw SQL Query Migration in Laravel This story was originally published on HackerNoon at: https://hackernoon.com/how-to-write-raw-sql-query-migration-in-laravel. We have created a laravel package to keep the track of raw SQL migration using package Laravel raw sql query migration Check more stories related to society at: https://hackernoon.com/c/society. You can also check exclusive content about #migration, #write-sql-query, #laravel, #sql, #sql-beginner-tips, #writing-sql-queries, #sql-database, #software-engineering, and more. This story was written by: @readerstacks. Learn more about this writer by checking @readerstacks's about page, and for more stories, please visit hackernoon.com. We have created a laravel package to k...
2023-06-1402 minPodlodka Podcast
Podlodka PodcastPodlodka #321 – SQLSELECT * FROM Episodes WHERE YEAR(published_at) > 2022 Думаете это все, на что способен SQL? Антон Жиянов, энтузиаст SQLite, красочно объясняет, что это заблуждение! Этот 2-х часовой 😱 выпуск можно смело использовать при подготовке к собеседованию: мы подробно разобрали как базовые конструкции, так и расширенные и современные фичи SQL: массивы, графы, рекурсию и многое другое. Поговорили, как готовить SQL с заботой о быстродействии и безопасности ваших баз данных, а также окунулись в мир SQL для анализа данных. Партнер выпуска – международная продуктовая IT-компания Garage Eight, которая создает экосистемы финансовых сервисов. Подписывайся на телеграм канал команды: https://t.me/+869_wYo7Zn82NDAy, чтобы не пропустить полезные кейсы и свежие вакансии! Поддержи лучший подкаст про IT: www.patreon.com/podlodka Также ждем вас, ваши лайки, репосты и комменты в мессенджерах и соцсетях!
 Telegram-чат: https://t.me/podlodka Telegram-канал: https://t.me/podlodkanews Страница в Facebook: www.facebook.com/podlodkacast/ Twitter-аккаунт: https://twitter.com/PodlodkaPodcast Ведущие в выпуске: Катя Петрова, Стас Цыганов Полезные ссылки: Серия курсов Databases от Стенфорда (01, 02, 03, 04) https://www.edx.org/course/databases-5-sql https://www.edx.org/course/advanced-topics-in-sql https://www.edx.org/course/modeling-and-theory https://www.edx.org/course/olap-and-recursion Курс «Интерактивный тренажер по SQL» https://stepik.org/63054 Книга "Use the index, Luke!" https://use-the-index-luke.com/sql/preface Методичка "Practical SQL for Data Analysis" https://hakibenita.com/sql-for-data-analysis Серия статей и курс «Оконные функции SQL» https://antonz.ru/window-functions/ Онлайн SQL-песочница https://sqlime.org/ Антон Жиянов https://antonz.ru/
2023-05-232h 10RunAs Radio
RunAs RadioSQL Server 2022 Hybrid Data Platform with Bob WardWhat can SQL 2022 do for you? Richard chats with Bob Ward about the upcoming release of SQL Server 2022 and its evolution toward data anywhere. Bob talks about running SQL on edge devices, on-premises, in containers, virtual machines, and, of course, in the cloud. The management tools like Azure Arc make it easy to take care of all the places your SQL data can now live - and let you be the data administrator you can be! Check out Bob's latest book on SQL Server 2022 and all its hybrid data capabilities!Links:SQL Server 2022SQL Server 2022 RevealedMicrosoft...
2022-11-0234 minEngineering Kiosk
Engineering Kiosk#41 SQL Injections - Ein unterschätztes RisikoSQL Injections: Eine der weitverbreitetsten Sicherheitslücken im Web, auch im Jahr 2022Der Großteil aller Applikationen interagiert in irgendeiner Art und Weise mit einer Datenbank. Deswegen werden die meisten Entwicklerinnen und Entwickler bereits von der Sicherheitslücke "SQL Injection" gehört haben. Seit 24 Jahren ist dies eine der weitverbreitetsten Sicherheitslücken im Internet und es ist kein Ende in Sicht. Was ist eigentlich eine SQL-Injection im Detail? Welche verschiedenen Arten gibt es? Was ist der Grund, dass uns dieses Einfallstor so lange beschäftigt? Woher kommt diese und wer hat sie entdeckt? Wie kann man sich schütz...
2022-10-181h 08SQL Server Radio
SQL Server RadioEpisode 142 - What is Your Favorite Feature in SQL Server 2022?Guy and Eitan discuss their favorite upcoming new features in SQL Server 2022, and talk about some major upcoming events and summits. Relevant links: SQL Server 2022 public preview is now available on Linux Introducing the SQL Server 2022 blog series by Bob Ward Contained Availability Groups in SQL Server 2022 | Eitan Blumin What is a contained availability group? | Microsoft Docs Erik Darling Blog series about Parameter Sensitive Plans XML Data Compression in SQL Server 2022 Link feature in Azure SQL MI for SQL Server Welcome to the new Azure SQL Database local development experience Planning new scenarios and use cases...
2022-07-1136 minRunAs Radio
RunAs RadioSQL Q&A from SQL Server & Azure SQL Conference Spring 2022In Las Vegas, once again, this is the Q&A session from the SQL Server & Azure SQL Conference in April 2022. Richard moderated questions and answers from SQL luminaries, including Bob Ward, Buck Woody, Pam Lahoud, Bradley Ball, Des Fitzgerald, Davide Mauri, Rie Merritt, and Kevin Farlee. The conversation ranges over Azure SQL migration, new features in SQL Server 2022, challenges in scaling, reliability, disaster recovery, and more!Links:SQL Server and Azure SQL ConferenceRecorded April 7, 2022
2022-05-1848 minUnplugged
UnpluggedUnplugged 41: Azure, Azure SQL, Azure Cosmos DB, ...Acompáñanos para conocer las últimas novedades del mundo Microsoft, en nuestro ambiente íntimo y desconectado de las redes sociales, sólo nosotros y los asistentes al directo. Comentaremos las últimas adquisiciones de Microsoft, las novedades más relevantes de Azure y Microsoft 365, los eventos más importantes, ... MICROSOFT: [MIN 7] Register now for Azure Cosmos DB Conf on April 19 – 20 https://devblogs.microsoft.com/cosmosdb/azure-cosmos-db-conf-april-19-20/ [MIN 9] Killed by Microsoft https://killedbymicrosoft.info/ [MIN 17] Microsoft HoloLens 2 and mixed reality bridge physical reality and digital experiences https://cloudblogs.microsoft.com/dynamics365/bdm/2022/02/23/microsoft-hololens-2-and-mixed-reality-bridge-physical-reality-and-digital-experiences/ [MIN 21] Linkedin - Bill Gates https://www.linkedin.c...
2022-04-121h 16Google Cloud Platform Podcast
Google Cloud Platform PodcastSQL Commenter with Nimesh Bhagat and Morgan McLeanFirst time co-host Jan Kleinert joins Mark Mirchandani this week to talk about database observability and the cool tools that make it possible. Morgan McLean and Nimesh Bhagat describe database observability, which uses metrics, logs, and other tools to help users understand the health of your database. We talk about Object Relational Mappers and the challenges with using these for debugging database performance. SQL Commenter helps database observability in two ways: it is both a library and a standard, Nimesh tells us. He describes the process for us, detailing exactly how SQL Commenter effects projects. Recently, SQL...
2022-03-1642 minSQL Server Radio
SQL Server RadioEpisode 135 - SQL Server 2022 and FriendsGuy and Eitan talk about the interesting new features announced in SQL Server 2022, a new sp_whoisactive version, and a bunch of Microsoft blog posts on Tech Community. Relevant links: SQL Server 2022: Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation Introducing SQL Server 2022 | Bob Ward Announcing the SQL Server 2022 Early Adoption Program SQL Server 2022 | Official Microsoft The new version of sp_whoisactive - v12.00 Extended Events to the Rescue - by Guy Glantser on SQLFriday New Microsoft support troubleshooting articles: SQL Server CE: Multiple single-column statistics SQL Server CE: Multiple single-column statistics connected...
2021-12-1335 minשיחות בין DBAs
שיחות בין DBAsפרק 141 - SQL 2022 - MuffinDBגיא ואיתן מדברים על הגרסה החדשה של SQL Server 2022 והפיצ'רים החדשים בו (לא כולל מאפים), ועוד הרבה נושאים מעניינים נוספים. אה, וגם גיטהאב נופל לנו באמצע ההקלטה, אז זה כיף. קישורים רלוונטיים: SQL Server 2022: Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation Introducing SQL Server 2022 | Bob Ward Announcing the SQL Server 2022 Early Adoption Program SQL Server 2022 | Official Microsoft The new version of sp_whoisactive - v12.00 Latest Blog posts from Madeira Data Solutions: Azure Data Platform Roles | Maria Zakourdaev Create Availability group with Automatic / Manual seeding with different paths for data and log file | Reut Almog Talmi How To Tune Performance - by Sagi Amichai (Chapter 1) How To Tune Performance - by Sagi Amichai (Chapter 2) What are my @@OPTIONS? | Guy Glantser Madeira Toolbox Roundup: Determining the SET Options for the Current Session.sql PUBLIC role with excessive permissions.sql
2021-12-0530 minThe Backup Wrap-Up
The Backup Wrap-UpMr. Backup and Mr. SQL argue over how to backup SQL ServerEver had questions about SQL Server, Azure, SQL Server ON Azure, how to backup SQL Server, or how to backup Azure? This is the episode for you. Denny Cherry, a SQL Server and Azure specialist and author of seven books, talks to us about both of these technologies. Before talking about anything important, we tackle the mystery of how you pronounce Azure. Surprise! I was pronouncing it wrong, according to Denny, who talks to Microsoft people all the time. We first talk about performance tuning, and Denny explains some things that most DBAs can do to improve...
2021-11-1555 minAzure & DevOps Podcast
Azure & DevOps PodcastBob Ward on SQL Edge to CloudThis week, Jeffrey is joined by Bob Ward, a Principal Architect for the Microsoft Azure Data team. Bob has worked for Microsoft for 27+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019, including Azure SQL. He is a well-known speaker on SQL Server and Azure SQL; often presenting talks on new releases, internals, and specialized topics. Additionally, he has a popular web series online, called "Azure SQL 4 Beginners." In this episode, Bob speaks about SQL Edge to Cloud; from the overall vision to recent developments, and what to look forward to...
2021-10-1139 minAzure & DevOps Podcast
Azure & DevOps PodcastAzure SQL Database with Anna HoffmanToday, Jeffrey is joined by Anna Hoffman; a Data & Applied Scientist and Program Manager on Microsoft's SQL Engineering team. Anna is also the host of the popular Azure SQL video show, Data Exposed, and a contributor to the recently published book, Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud. In this episode, Anna shares her insights and advice on Azure SQL Database. She speaks about the upcoming features and exciting news coming out of the Azure SQL space, why you may want to consider going serverless, how to get started...
2021-09-2834 minAzure & DevOps Podcast
Azure & DevOps PodcastData DevOps with the SQL TeamThis week on the show, Jeffrey Palermo is joined by two special guests, Arvind Shyamsundar and Drew Skwiers-Koballa! Arvind Shyamsundar is a Principal Program Manager on the Azure SQL DB Product Management team at Microsoft. He works to enable customers, partners, and colleagues to excel at what they do best by harnessing the power of data, advanced analytics, and cloud services. Arvind has worked at Microsoft for the last 18 years and was previously a part of the AzureCAT/DataCAT/SQLCAT group within Azure, and prior to that, a Principal PPE with Microsoft Services.
2021-06-1433 minEthical Hacking
Ethical HackingWhat is Structured Query Language(SQL) Injection ?hello everyone my name is vijay kumar Devireddy and i am glad to have you back on my episode 47 today we are discussing about SQL Injection.What is SQL?SQL, or Sequel, stands for the structured query language.And it's the way that a web application communicates to a database server to ask for information.Because this is the language used to communicate with the databases and  the databases hold lotsof valuable information,this has become a popular target for attacks.This brings us to the concept of an SQL Injection,which is an attack consisting of the insertion o...
2021-06-0411 minAzure & DevOps Podcast
Azure & DevOps PodcastDavide Mauri on Azure SQL for DevelopersThis week on the podcast, Jeffrey is joined by Davide Mauri, a Program Manager in the Azure SQL Database product group at Microsoft. Davide has been working in the IT field since 1997 and was awarded Data Platform MVP status for 12 consecutive years. He started his career as a full-stack and back-end developer, then focused on databases and data science for 15 years while still keeping alive his passion for development (mainly in C# and Python). He then moved to the Internet of Things (IoT) and big data space. Building from that experience, he joined Microsoft to...
2021-05-0336 minDavid Bombal
David Bombal#281: SQL InjectionDaniel demonstrates SQL Injection using sqlmap. This is one of his favourite tools. Big thanks to ITPro.TV for sponsoring this video. In future videos, he will show us additional tools. ====== Menu: ====== SQL Injection Demo: 0:00​ Daniel's top 5 hacking tools: 1:40​ SQL Injection: sqlmap and DVWA: 2:31​ Don't get shiny bracelets: 3:32​ Start attack: 5:44​ SQL tables: 8:00​ SQL dump: 9:35​ SQL Hashes: 9:45​ DVWA explained: 12:40​ sqlmap command: 15:27​ url: 16:06​ sqlmap uses the website: 17:34​ Change URL to handle special characters: 19:21​ cookies: 20:04​ How to find cookies manually: 21:41​ sqlmap switches dbs: 23:55​ sqlmap tables: 26:30​ sqlmap columns: 27:31​ sqlmap dump: 28:29​ Login as a user: 29:45​ Why is it called sql injection: 30:41​ Can you write to the database: 32:45​ What do you want to s...
2021-05-0341 minGoogle Cloud Platform Podcast
Google Cloud Platform PodcastCloud SQL Insights with Nimesh BhagatThis week on the podcast, Mark Mirchandani and Gabi Ferrara talk with Nimesh Bhagat about Cloud SQL Insights. This powerful tool enables developers to diagnose database issues for faster, smoother performance. Nimesh tells us the inspiration for Cloud SQL Insight's development and describes its biggest benefits. One of the important aspects of Insights is the ability for developers to gain an application-centric view by allowing them to tag database queries with SQL comments. These tags are aggregated in Insights and give developers a visual of the database queries. Here, developers can see load patterns and use that...
2021-02-1733 minIntellipaat
IntellipaatSQL Developer Career Path and Job OpportunitiesIntellipaat SQL training course: https://intellipaat.com/microsoft-sql-server-certification-training/ #SQLdeveloperCareer #CareerInSQL #SQLdeveloper #SQLtraining #SQLcourse #SQLcertification #SQLtutorial #Intellipaat  Why should you opt for a SQL career?   SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impact drastically on the performance. So learning this skill will definitely help you grab the best jobs in top MNCs after finishing Intellipaat SQL online training. The entire Intellipaat SQL course is in line wi...
2020-11-1317 minRunAs Radio
RunAs RadioAzure SQL Revealed with Bob WardWhere did Azure SQL come from and where is it going? Richard chats with Bob Ward about his new book, Azure SQL Revealed. The conversation starts out at the beginning of SQL Server in the 90s, all the way to SQL 2005, when the first discussions of a database in the cloud happened at Microsoft. Bob talks about the early days of SQL Server for Windows Azure that eventually became Azure SQL. Today Azure SQL works from the simplest of SQL Server workloads to some of the biggest hundred terabyte hyperscale servers - have a read!Links:...
2020-11-1135 minIntellipaat
IntellipaatLearn SQL for Beginners🔥Intellipaat SQL training: https://intellipaat.com/microsoft-sql-server-certification-training/ 👉In this SQL certification training session you will learn sql for beginners like what is sql, how to become a sql developer, skills required, various certifications available, job trends and salary a sql developer earns in detail.  #MSSQL #SQLCertificationTraining #MSSQLCertificationTraining #LearnSQL #LearnSQLforBeginners #SQLCertificationCourse #WhatisSQL #SQLTraining, Why should you opt for a SQL career? SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impa...
2020-11-0622 minIntellipaat
IntellipaatSQL vs MongoDB🔥🔥🔥Intellipaat SQL training: https://intellipaat.com/microsoft-sql-server-certification-training/ 🔥🔥🔥Intellipaat MongoDB training: https://intellipaat.com/mongodb-training/ 🡆In this session on SQL vs MongoDB you will understand about the difference between these two and which one should you use for better performance. So in this MongoDB vs SQL comparison some important parameters have been taken into consideration to tell you the difference between SQL and MongoDB & also which one is preferred over the other in certain aspects in detail.  #SQLvsMongoDB #MongoDBvsSQL #DifferencebetweenSQLandMongoDB #Intellipaat ⭐Why should you opt for a #SQL career?  SQL optimization has always b...
2020-10-1213 minIntellipaat
IntellipaatSQL vs NoSQL🔥🔥🔥Intellipaat SQL training: https://intellipaat.com/microsoft-sql-server-certification-training/ 🔥🔥🔥Intellipaat NoSQL training: https://intellipaat.com/nosql-cassandra-hbase-training/  🡆In this session on SQL vs NoSQL you will understand about the difference between these two and which one should you use for better performance. So in this NoSQL vs SQL comparison some important parameters have been taken into consideration to tell you the difference between SQL and NoSQL & also which one is preferred over the other in certain aspects in detail.  #SQLvsNoSQL #NoSQLvsSQL #DifferencebetweenSQLandNoSQL #Intellipaat Why should you opt for a SQL career?   SQL optimization has always...
2020-10-0717 minIntellipaat
IntellipaatDifference between SQL and PL-SQLIntellipaat SQL training: https://intellipaat.com/microsoft-sql-server-certification-training/ Intellipaat PL/SQL training: https://intellipaat.com/pl-sql-online-training/ In this session on SQL vs PL/SQL you will understand about the difference between these two and which one should you use for better performance. So in this PLSQL vs SQL comparison some important parameters have been taken into consideration to tell you the difference between SQL and PLSQL & also which one is preferred over the other in certain aspects in detail.  #PLSQLvsSQL #DifferencebetweenSQLandPLSQL #SQLandPLSQL #Intellipaat #SQLvsPLSQL Intellipaat Edge  24*7 Life time Access & Support   Flexible Cla...
2020-09-2407 minData Points
Data Points4. Optimizing Your SQL Performance (Benjamin De Boe)In this episode, we chat with Benjamin De Boe, product manager for data management and analytics, about optimizing the performance of your SQL queries in InterSystems IRIS. Benjamin will go over some of the most common issues that cause performance loss within your queries, the easiest ways to fix them, and some other items to look for in order to ensure your queries are healthy and efficient. For more information about Data Points, visit https://datapoints.intersystems.com. To try InterSystems IRIS today, head over to https://www.intersystems.com/try and launch your instance! You can find...
2020-02-2415 minDBA Genesis Audio Experience
DBA Genesis Audio ExperienceSQL Profile vs SQL Plan Management | #dailyDBA 21In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. What is materilized view and how can I purge the MV logs? 2. If locks are coming and releasing itself within 2-3 seconds, in this situation what we can do in oracle so locks does not occur even for few seconds. 3. Hi Arun, what happens if password file is deleted from the...
2020-01-2933 minGem FM
Gem FMGem FM 087 - SQL Live @ Loveland FestivalIn 2015 Loveland asked SQL to play a three hour live set for their mighty Live stage alongside Kolsch, Gui Boratto, Extrawelt, Kollektiv Turmstrasse, Mathew Jonson and Arjuna Schiks. The first time SQL ever played a live set of this length (only his own music, played live) turned out perfectly. We uploaded the full three hour ride with lots of unreleased material from one of Gem's finest and most talented. TRACKLIST 1 SQL - Sound mental state (live improvised version) 2 Untangle AKA SQL - Postpone (unreleased) 3 SQL - Unreleased live jam with Anushri, Acidlab miami and U-he DIVA 4 Olaf Stuut & SQL...
2019-01-073h 00Azure Lunch
Azure LunchAzure Lunch - SQL Heavy!In this episode Daniel Larsen and Matt Simpson, Senior Technical Evangelists at Microsoft, go "SQL Heavy" with some of the SQL Server news from Ignite 2018, including Azure SQL Managed Instances, Azure SQL Hyperscale and SQL Server 2019! Show links: Microsoft NZ Partner Hub Cloud practice playbooks Use SQL Database Managed Instance with virtual networks and near 100% compatibility Announcing Azure SQL Database Hyperscale public preview Hyperscale service tier (preview) for up to 100 TB What's new in SQL Server 2019 Ignite 2018: Azure SQL Database Hyperscale (Video) Download the Microsoft SQL Server 2019 technical white paper Azure Lunch is a regular...
2018-10-1719 minIT-Berufe-Podcast
IT-Berufe-PodcastSQL-Aufgaben in der schriftlichen IHK-Prüfung – Anwendungsentwickler-Podcast #117SQL-Aufgaben kommen in fast jeder schriftlichen IHK-Abschlussprüfung vor. Daher wird es Zeit, einmal detailliert über eine sinnvolle Vorgehensweise bei ihrer Beantwortung zu sprechen. Genau dieses Thema hat die einhundertsiebzehnte Episode des Anwendungsentwickler-Podcasts. Inhalt SQL-Aufgaben kommen in der Prüfung für Anwendungsentwickler eigentlich jedes Mal vor (in GA1). Aber auch in GA2 kommen durchaus häufiger SQL-Aufgaben zum Einsatz. Eine detaillierte Vorbereitung ist also für alle IT-Berufe zu empfehlen. Es gibt keine Ausrede, SQL nicht in- und auswendig zu kennen. Selbst wenn in fast jeder Prüfung ein Beiblatt mit der SQL-Syntax vorhand...
2018-02-0540 minThe InfoQ Podcast
The InfoQ PodcastArchitecting SQL Server on Linux: Slava Oks on Drawbridge, LibOS, & Addressing Between Windows/LinuxWesley Reisz talks to Slava Oks, who has worked at Microsoft for over 20 years on flagship products, including SQL Server. He also led the kernel team who worked on the Midori operating system. More recently, he has worked on bringing SQL Server to Linux. Why listen to this podcast: - Microsoft SQL Server runs on Linux through a containerised approach called Drawbridge - Drawbridge implements a Linux loader and a minimal set of ABI calls to allow an in-process NT user mode kernel to run - SQL Server runs on top of a SQL platform layer (called SQL OS) that...
2017-02-2430 minSounds of SQL
Sounds of SQLMr Whittles talks about presentationsIn this podcast Richard Douglas and I talk to Alex Whittles about presenting.  How and why he started presenting. He is the owner of Purple Frog – a SQL Server/ BI Consulancy. He’s a Microsoft MVP (Most Valued Professional)  and on the
2016-04-2200 minSounds of SQL
Sounds of SQLMr Douglas talks about presentationsIn this podcast I talk to Richard about presenting. How he got into presenting, how he wanted to be a teacher and more. How he gets his crazy ideas from watching movies. Abstract writing using the resources from SQL PASS Speaker Resources pages, how to put people off coming to your session and getting the level right and more.....
2016-03-2000 min