You Know We're Going to Talk About Crowdstrike

Database Weekly for July 27, 2024 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  We Stink! You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were not directly impacted, all the knock-on effects from the airlines and airports that were. Ended up getting home just a little bit late after lots of delays. Honestly, a normal travel day really. Now, my coworker, Ryan Booz, was trapped. He couldn't fly out at all and ended up taking a train to a place to get a plane to another place and still had to rent a car (or something, I lost track) to make it home. I've read about people being trapped in the Atlanta airport for days. Literally days. A bunch of friends had hundreds or even thousands of servers they had to deal with. Hospitals were down. 911 systems were offline. I'm not sure if we'll ever know how many, but this thing caused deaths. In short, a substantial chunk of planet Earth was negatively impacted. Here's where I tell you how you could have avoided the troubles if only.... Yeah, I can't. This illustrates one thing. We stink. Collectively, we're just not very good at this whole IT thing. We call ourselves engineers and architects and other grandiose terms. Let's be honest. If architects built buildings the way we build systems, there'd be a lot more of them falling over & catching fire than there are. If engineers ran manufacturing plants the way we run IT shops, well, a lot more cars would be flinging parts into the air rather than rolling down the road. What do we do? We have to get better. This illustrates that the world is truly interconnected in ways that it never was in history. A single, small change, mildly messed up, took down a chunk of the planet. That's simply not acceptable. We have to focus on resilience. We must try, to truly, treat IT like it is architecture or engineering, because, actually, it is. We have to get better, because we can hurt everyone if we don't. Kind of a scary thought, but here we are. Grant Fritchey [Join the debate, and respond to the editorial on the forums](  The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. Vendors/3rd Party Products [Using Bash with Flyway]( If you're using a Linux-based operating system, Bash is the obvious choice of scripting language for Flyway. This article demos the basics of dealing with credentials in team-based database development, when using 'traditional' flyway.conf files, and how to save and parse the JSON output of Flyway commands, for example to retrieve the current schema version. It provides a full automation example that will allow a team to maintain several copies of a database, one per development branch, from a Flyway project. AI/Machine Learning/Cognitive Services [Generative AI and Data: Using Knowledge Graphs and RAG Together]( From Dataversity Generative AI has huge potential, but it also face... [Software Architecture in an AI World]( From O'Reilly Radar - Insight Like almost any question about AI, “How does AI ... [Senate Democrats Demand OpenAI Detail Efforts To Make Its AI Safe]( From IT Pro - Microsoft Windows Information, Solutions, Tools Following a Washington Post report, five Senate De... [AI trained on AI garbage spits out AI garbage]( From Technology Review Feed - Tech Review Top Stories AI models work by training on huge swaths of data ... [Microsoft’s AI Assistants Will Revolutionize the Office — One Day]( From IT Pro - Microsoft Windows Information, Solutions, Tools Early adopters say deploying the company’s Copilot bots requires cleaning up corporate data and lots of employee training. [AI Studio and The New AI Features]( From Simple Talk When Microsoft announced the new AI Studio, it was easy to mistake it by any of the other studios available. All AI resources in Azure use a different studio... [Google DeepMind’s new AI systems can now solve complex math problems]( From Technology Review Feed - Tech Review Top Stories AI models can easily generate essays and other types of text. However, they’re nowhere near as good at solving math problems, which tend to involve logical reasoning—something that’s beyond... [How our genome is like a generative AI model]( From Technology Review Feed - Tech Review Top Stories This article first appeared in The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, and read articles like this first, sign up here. What does... Administration of SQL Server [Different ways to identify and change compatibility levels in SQL Server]( From SQLShack Compatibility level in SQL Server refers to a data... [Index cleanup : Harder than it looks]( From Simple Talk I’m not the first person to write about cleaning... [7 Best Online Advanced SQL Training Courses to Learn in 2024]( From SQLServerCentral Blogs The world runs on data, and SQL is the key to unlo... [Updating dbatools–Fixing the Certificate Failure]( From SQLServerCentral Blogs I was trying to update my dbatools install to test something and go this error. I fixed it with a little help. The Fix The short answer from Chrissy... The... [Comparing SQL Server and Oracle Backup Types]( From MSSQL Tips Learn about the similarities and differences of ba... [Auditing SQL Server – Part 3 – SQL Server Configuration Audit]( From Simple Talk This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. The next section went over server hardware... [Dealing with Multiple Database Snapshots]( From Andy Broadsword Last week we looked at using Database Snapshots t... [SQL Server Cross Platform Availability Groups and Kubernetes]( From DBA From The Cold Say we have a database that we want to migrate a copy of into Kubernetes for test/dev purposes, and we don’t want to backup/restore. How can it be done?... Azure SQL [Calling a REST Endpoint from Azure SQL DB]( From DCAC External REST endpoint invocation in Azure SQL DB ... [Using Managed Identities with Azure SQL DB]( From SQLServerCentral Blogs We are trying to get apps and users off of using SQL accounts to access the Azure SQL DBs where I work. To make our lives easier, we are... The... [Build AI Applications with Redis and Azure SQL Database | Data Exposed]( From Azure SQL Learn how you can create an AI enabled application using vector storage in Azure Cache for Redis and the Azure SQL Database.  Watch on Data Exposed  Resources: SQL AI Samples       Intelligent applications with... Career, Employment, and Certifications [3 Actions to Create an IT Strategic Workforce Plan]( From IT Pro - Microsoft Windows Information, Solutions, Tools In an era of rapid digital disruption, strategic workforce planning is crucial for aligning IT talent with business goals, addressing skills gaps, and ensuring organizational success. Cloud - AWS [AWS Weekly Roundup: Global AWS Heroes Summit, AWS Lambda, Amazon Redshift, and more (July 22, 2024)]( From AWS News Blog Last week, AWS Heroes from around the world gather... Community Interests [PASS Data Community Summit: A Personal Journey]( From SQLServerCentral Blogs As someone attending the event since 2011, I would... Computing in the Cloud (Azure, Google, AWS) [More Enterprises Want Hybrid Cloud, Not Public]( From IT Pro - Microsoft Windows Information, Solutions, Tools A new report from research firm ISG shows U.S. ent... Conferences, Classes, Events, and Webinars [Further your PostgreSQL knowledge at PASS Data Community Summit 2024]( As the adoption of different database platforms and technologies expand, more and more DBAs are supporting multiple database platforms. More than any other database, PostgreSQL is a central part of that transition. Whether you are new to PostgreSQL, want to build on what you’ve learnt from the PostgreSQL 101 series and our PostgreSQL learning resources hub, or perhaps you’re already a PostgreSQL pro; there are plenty of opportunities to learn, share and connect at this year’s PASS Summit, November 4 – 8. DMO/SMO/Powershell [Latest Update for Undercover Catalogue Powershell Interrogation Script]( From SQL Undercover We’ve been hearing of a few people getting error... Data Mining / Data Analysis [Data Concierge: Driving Business Intelligence Collaboration]( From Dataversity Discerning businesses are ensuring each area of th... [Lengths and formats in SAS: the long and short of it]( From AllAnalytics What's the difference between LENGTH and FORMAT in... [How to Ask Great Questions with a Data Science Lens]( From Dataversity When it comes to solving business problems, data scientists understand how crucial it is to formulate the right business question. While it’s easy to get sidetracked by intriguing data... Database Design, Theory and Development [New Paper: THE FINAL NULL IN THE COFFIN - A RELATIONAL SOLUTION TO MISSING DATA]( From Database Debunkings Available to order from the PAPERS pageTable of Co... DevOps and Continuous Delivery (CI/CD) [Using Bash with Flyway]( From Product learning – Redgate Software If you're using a Linux-based operating system, Bash is the obvious choice of scripting language for Flyway. This article demos the basics of dealing with credentials in team-based database... [Additional security tests when using GitHub for Microsoft Fabric Git integration]( From Kevin Chant Reading Time: 6 minutes In this post I want to share the results of some additional security tests when using GitHub for Microsoft Fabric Git integration. Which I... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Microsoft Fabric Glossary]( From RADACAD There are a lot of similar terminologies and words... [Introduction to Data Wrangler in Microsoft Fabric]( From Adatis What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science experience. This experience provides data scientists and Fabric users with capabilities to build and... Oracle/PostgreSQL/MySQL/other RDBMS [Volume Snapshots and Oracle Home Considerations]( From DBAKevlar In the midst of us needing to do more with less every day, many of us are incorporating clones to Tags:  Cloning, oracle Del.icio.us Facebook TweetThis Digg ... Performance Tuning SQL Server [Cardinality Estimation Feedback Explained by Kate Smith (@akatesmith)]( From Azure SQL The Problem of Cardinality Estimation There is a s... [A Little About Intelligent Query Processing Limitations In SQL Server]( From Erik Darling Data A Little About Intelligent Query Processing Limita... [Tweaking SQL Server Queries To Induce Parallel Execution Plans]( From Erik Darling Data Tweaking SQL Server Queries To Induce Parallel Execution Plans Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love... [Indexing only recent data - adventures with large datasets & archiving]( From Ayende @ Rahien We recently got a support request from a user in which they had the following issue:We have an index that is using way too much disk space. We don’t... PostgreSQL [Michael Christofides: Which cloud providers support auto_explain?]( From Planet Postgres Photo credit: Kenrick Mills From time to time ... [semab tariq: A Follow up on Key PostgreSQL Configuration Parameters for Enhanced Performance – Part 2]( From Planet Postgres In a previous blog post, we configured an EC2 inst... [Andrew Atkinson: You make a good point! — PostgreSQL Savepoints]( From Planet Postgres This post will look at the basics of PostgreSQL Sa... [Hans-Juergen Schoenig: Speeding up index creation in PostgreSQL]( From Planet Postgres Indexes are, by far, the most feature related to p... [Not All Query Folding is Created Equal...Performance Tuning PQ]( From Havens Consulting Video by: Reid HavensEveryone knows rule number on... [Using Query Store to Capture PostgreSQL Performance in Azure Database | Data Exposed: MVP Edition]( From Azure SQL Capturing query metrics in PostgreSQL can be a cha... [Andrew Atkinson: Wait a minute! — PostgreSQL extension pg_wait_sampling]( From Planet Postgres PostgreSQL uses a complex system of locks to balan... [David Wheeler: To Preload, or Not to Preload]( From Planet Postgres To preload, or not to preload, that is the questio... [PG Down Under show 3 with guest Ryan Booz is now published!]( From The Bit Bucket Welcome to show 3 for PG Down Under! Once again, I really enjoyed recording today's show. It features Ryan Booz. Ryan is an evangelist with our friends at Red-Gate,... PowerPivot/PowerQuery/PowerBI [Happy little accidents with the Power BI Card Visual]( From Guy in a Cube Ready to take the Power BI card visual to the next... [Power BI Dataset Gives Mashup Timeout Error While Refreshing]( From Purple Frog Systems Help – my Power BI dataset is giving mashup timeout error on refresh The mashup timeout error Incremental refreshes are a great benefit to have in order to reduce... Professional Development [Microsoft 365 Security and Compliance for Administrators, a Book Review]( From Data on Wheels (Steve Hughes) I was asked to review the following book by the pu... Python [An Introduction to Frappe Framework: Features and Benefits]( Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. Frappe is a “batteries included” framework because it equips developers with a comprehensive suite of features for building web applications efficiently. It includes everything from database management, user authentication, and customizable workflows to reporting and API integrations seamlessly integrated into the framework. It significantly lowers the barrier to entry, accelerates development, and ensures that developers can focus more on building unique application features rather than integrating and configuring multiple third-party components. Security News and Issues [Microservices vs. Monoliths: Which Are More Secure?]( From IT Pro - Microsoft Windows Information, Solutions, Tools Microservices offer security advantages by isolati... [Robot Dog Internet Jammer]( From Schneier on Security Supposedly the DHS has these: The robot, called �... [AI in Healthcare Demands Vigilant Security Measures]( From IT Pro - Microsoft Windows Information, Solutions, Tools The increased integration of AI in healthcare offers the potential for dramatic improvements in outcomes. But it’s not without risks. Software Development [CodeSOD: How to Validate an IP Address]( From Daily WTF Andy has some concerns about future proofing. In t... T-SQL and Query Languages [Index cleanup: Harder than it looks]( I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about how non-clustered indexes are expensive to store and maintain, that they can occupy valuable space in memory, and that they can negatively impact the performance of the write portion of any SQL Server workload. There are great scripts out there already – like sp_BlitzIndex – that can help identify index issues without any grunt work. So, nothing new in this area - but reinforcement can be beneficial. [Convert a String to JSON with SQL Server Queries]( From MSSQL Tips In this article, we look at various ways to genera... Tech News [Fallout From Faulty Friday CrowdStrike Update Persists]( From IT Pro - Microsoft Windows Information, Solutions, Tools Historic IT outage expected to spur regulatory scr... [GitLab Customers Hope to Stay Out of the Doghouse if Acquired by Datadog]( From IT Pro - Microsoft Windows Information, Solutions, Tools Rumors of Datadog acquiring GitLab could reshape t... [The race to clean up heavy-duty trucks]( From Technology Review Feed - Tech Review Top Stories This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. Truckers have to transport massive loads... [CodeSOD: Reflections on Privacy]( From Daily WTF Jaco's team had a problems with making an embedded web server shut down properly. Something about the shutdown process was deadlocking, so one of their "ninja Yoda coders" rockstarred... [Beer, hydrogen, and heat: Why the US is still trying to make mirror-magnified solar energy work]( From Technology Review Feed - Tech Review Top Stories The US is continuing its decades-long effort to commercialize a technology that converts sunlight into heat, funding a series of new projects using that energy to brew beer, produce... [‘Hug Your IT Folks’: The Crowdstrike Outage Turned Technicians Into Heroes]( From IT Pro - Microsoft Windows Information, Solutions, Tools When CrowdStrike took down millions of devices, IT workers became the thin line between corporate America and chaos. [Roundtables: CRISPR Babies—Six years later]( From Technology Review Feed - Tech Review Top Stories Recorded on July 25, 2024 CRISPR Babies: Six years later Speakers: He Jiankui, CRISPR Pioneer, Antonio Regalado, senior editor for biomedicine, and Mat Honan, editor in chief Gene editing... [The CrowdStrike Outage and Market-Driven Brittleness]( From Schneier on Security Friday’s massive internet outage, caused by a mid-sized tech company called CrowdStrike, disrupted major airlines, hospitals, and banks. Nearly 7,000 flights were canceled. It took down 911 systems and... [GitHub Innovation Graph Update Reveals Digital Divide, AI Growth]( From IT Pro - Microsoft Windows Information, Solutions, Tools GitHub's Innovation Graph for Q1 2024 finds a growing AI interest among developers and continued U.S. and EU dominance in software collaboration. Testing Software [10 tips for Test Data Management success]( From Blog – Redgate Software The role of effective Test Data Management (TDM) i...  [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -