Interesting & Different Tech News This Week

Database Weekly for December 10, 2022 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  Poking the Bear If you're an experienced, knowledgeable, seasoned (I won't say old), SQL Server data professional, and you choose to use Trace Events (Profiler), more power to you. That's it. That's all I have to say. Do what you think best. I'm never, ever (again), going to second guess you. Further, my apologies for ever having done so in the past. It's literally none of my business and I was wrong to have presumed otherwise. I'm sorry. However, if you're teaching Trace Events to the new kids, I think you're wrong. I totally understand why you want to continue using Trace. See above. I support you. I don't understand why you would choose to have new people, who are likely only ever going to work on newer versions of SQL Server, and working with cloud technology, learn a technology that hasn't grown or improved in 14 years and only partly works in the cloud. The only exception, if you're teaching these new people 2008R2 or less (and if so, I'm sorry for your pain). These are new, fresh, people, learning cool new tech, why inflict old school methods on them? You wouldn't trot out Query Analyzer (also from SQL Server 7) as a way to write queries in SQL Server 2022. Why teach them a monitoring tool from 1998? 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 [Executing Optional Code in Flyway Callbacks]( This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations. [Converting Data Across Time Zones: An In-Depth Primer]( This article dives into all the math required to convert historical times between time zones. [Express.js or Next.js for your Backend Project]( In this article, I will introduce two JavaScript frameworks that can be used to build backend projects. AI/Machine Learning/Cognitive Services [Data and Compute in Azure ML]( From Curated SQL Tomaz Kastrun continues an advent series on Azure ... [New York City Vies for AI Jobs at AI Summit New York]( From IT Pro - Microsoft Windows Information, Solutions, Tools EDC CEO says AI will stimulate all of NYC's core industries, including retail and health care. [How to Transform Customer Experience with Explainable AI]( From Dataversity In today’s competitive landscape, customer experience can make or break a business, and companies need to know more about their customers than ever before. One way to do so... Administration of SQL Server [Calculate SQL Server Page Counts for Tables, Indexes and Objects]( From MSSQL Tips Learn about how SQL Server stores data on a data p... [SQL Server Diagnostic Information Queries for December 2022]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [Dealing with the Bits of a Binary Value in SQL Server]( From Simple Talk In this article, I want to talk about a topic that... [Configure Auto-Failover Group for Azure SQL Database and Azure SQL Managed Instances for SQL Server]( From MSSQL Tips This tip will show how to configure auto-failover ... [I made a new demo/workshop database]( From Sunday morning T For a couple of years now, I’ve taught my SQL Se... Analysis Services / BI on the MS Stack [What’s New In Analysis Services 2022?]( From Chris Webb's BI Blog There was a time when a new release of SQL Server ... [Solving errors in CALCULATE filter arguments]( From Sqlbi The filter arguments in CALCULATE can be written a... [Solving errors in CALCULATE filter arguments]( From SQLBI This video explains the more common errors in CALCULATE filter arguments and how to solve them. Azure Databricks, Spark and Snowflake [Filtering and Aggregating Hive Tables with Spark SQL]( From MSSQL Tips Learn how to use the Apache Spark ecosystem to fil... [Making the SELECT work in Snowflake]( From Sherpa of Data With our last blog post, we started discussing Sno... [Learn Snowflake Constraints Primary Key, Unique Key, Foreign Key and Not Null]( From MSSQL Tips In this article, we look at constraints in Snowflake such as PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, and NOT NULL and how they are enforced in Snowflake. Azure SQL [Understanding business continuity solutions for Azure SQL PaaS services]( From SQLShack This article will explain various business continuity options available for Azure SQL PaaS services (SQL databases and SQL managed instances). Today we will learn about several options so that... [Build data driven business case for SQL Server migration to Azure]( From Azure SQL Azure offers you the ability to run your SQL Server workloads with optimized costs, greater flexibility, scalability, and availability along with a strong security and compliance posture all the... [Understanding Connectivity issues in SQL Database | Data Exposed]( From Azure SQL The connections established to Azure SQL Database from applications or client tools may be unexpectedly terminated and impact user environments due to internal (System) maintenance work, client networking, application-related... Azure Synapse (SQL Data Warehouse and Data Lake) [What Exactly is Microsoft Synapse?]( From Prologika (Teo Lachev's Weblog) The other day an exalted customer shared that they... [Implementing Row-Level Security in Azure Synapse Serverless SQL pools using TSQL]( From SQLShack Row Level Security is a very key requirement for m... [InvalidAbfsRestOperationException in Azure Synapse notebook]( From SQLPlayer Problem The first issue that developers in my team... [Six-minute crash course about Synapse Studio]( From Kevin Chant Reading Time: 6 minutes In this post I want to do a six-minute crash course about Synapse Studio. I wanted to do this follow-up post for a couple... Big Data [Ready-to-go sample data pipelines with Dataflow]( From Netflix TechBlog - Medium by Jasmine Omeke, Obi-Ike Nwoke, Olek Gorajek Int... Computing in the Cloud (Azure, Google, AWS) [Efficient Cloud Management Considerations]( From MSSQL Tips If you want to use cloud resources efficiently, le... [The Pros and Cons of Alibaba Cloud]( From IT Pro - Microsoft Windows Information, Solutions, Tools Is Alibaba Cloud a worthy alternative to the Big 3 public cloud providers? We examine its benefits and disadvantages to help you decide if it's right for your organization. Conferences, Classes, Events, and Webinars [New Flyway Course on Redgate University]( Flyway Desktop is the newest way to automate database deployments. In this brand new course Kathi Kellenberger provides an overview of DevOps, including definitions, tools, and demos of some of the advanced features available in Flyway Desktop. [New DevOps Process Improvement Course]( However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them. DMO/SMO/Powershell [How To Find Failed Logon Attempts in PowerShell]( From IT Pro - Microsoft Windows Information, Solutions, Tools Anyone who has ever sifted through the Windows Eve... [#PowershellBasics: Warnings and how to hide them.]( From SQLStudies One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading Data Mining / Data Analysis [Five Data and Analytics Trends: What Lies Ahead in 2023]( From Dataversity It’s rare, if not impossible, to find a business that does not have a digital presence. The convenience factor of digital is accelerating the pace at which businesses are... [Remaining resilient: Our 2023 analytics predictions]( From AllAnalytics In 2022, the world adjusted to and worked to recover from a global pandemic and international conflict that displaced millions of families. Energy costs increased sharply and supply chain... [Using the cspade action to find frequent gene sequences]( From AllAnalytics Building on a previous post on how the seqmc action can be used to mine frequent sequences, SAS' Amod Ankulkar explores an alternative algorithm. The post Using the cspade action... Data Science [How organizations can close the data science skills gap amid a shortage of talent]( From AllAnalytics From sparking innovation to reducing operational i... DevOps and Continuous Delivery (CI/CD) [Building emergency pathways in your software (never to be used)]( From Ayende @ Rahien Preconditions, postconditions, and invariants, oh ... [Solving DevOps Hiring Challenges: Automation Is the Only Way Forward]( From IT Pro - Microsoft Windows Information, Solutions, Tools With qualified DevOps engineers in short supply, b... [A Version Control Strategy for Database DevOps]( From Product learning – Redgate Software Our goal was to transform a 'serial' and manual development and release process into one that supported parallel development work and automated releases. This article explains step one: migrating... Hardware [Cool Pi 4: The RK3588S Eight-Core Raspberry Pi Alternative]( From Tom's Hardware US The Cool Pi 4 features the RK3588S chipset in a fo... Hardware Testing [How To Check SSD Health via GUI-based Options]( From IT Pro - Microsoft Windows Information, Solutions, Tools Solid-state drives don’t last forever. Here are ... [How To Assess SSD Health in PowerShell]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell can retrieve valuable information about... Oracle/PostgreSQL/MySQL/other RDBMS [PostgreSQL Community: Passionate, Knowledgeable, and Thoughtful]( From Software and Booz For PGSQL Phriday #003 (the last one of 2022), Pat... Performance Tuning SQL Server [SQL Server For Beginners: Why Declared Variables Cause Bad Estimates Lecture]( From Erik Darling Data +OK PowerPivot/PowerQuery/PowerBI [Comparing Power BI vs Tableau as Data Visualization Tools]( From MSSQL Tips In this article, we do a comparison of Power BI and Tableau, and which tool may be a better choice for your report and dashboard development. [Can you make a two-line dynamic title in Power BI?]( From Guy in a Cube Dynamic titles in Power BI can be really useful. What about a multi-line title? Patrick is answering a commenter's question on how to create a two-line dynamic title! Dynamic... Professional Development [The Good, The Bad, and Suboptimal of Sticking to What You Know]( From Simple Talk From personal observation and experience, most peo... [Books and Covers…]( From StraightPath Solutions SQL Blog Believe me, every heart has its secret sorrows, wh... [What’s next: Job search burnout]( From SQLStudies I was given 4.5 months notice this past June and w... [Types of data consulting engagements and what you can expect from them]( From DCAC There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, and the... [Go Language for Database Professional]( From Journey to SQL Authority with Pinal Dave The Go language is an open-source project started by Google. It is a statically typed, compiled language that feels like a dynamically typed, interpreted. First appeared on Go Language for... R Language [Using R and Python in Microsoft SQL Server 2022]( From TomazTsql In the late November 2022 Microsoft announced, tha... SQL Server on Linux [8 Linux Tools IT Operations Engineers Should Master]( From IT Pro - Microsoft Windows Information, Solutions, Tools Some are tried-and-true and others are newer, but all eight of these Linux tools should be in every ITOps engineer's tool belt. Security News and Issues [Cyberattack Shuts Down French Hospital]( From Dark Reading: Dark Reading News Analysis Patients transferred and operations canceled follo... [Hacker Fails for the Win]( From Dark Reading: Dark Reading News Analysis Security researchers share their biggest initial screwups in some of their key vulnerability discoveries. [Rackspace Incident Highlights How Disruptive Attacks on Cloud Providers Can Be]( From Dark Reading: Dark Reading News Analysis A ransomware attack on the company's Hosted Exchange environment disrupted email for thousands of mostly small and midsize businesses. [Leaked Signing Keys Are Being Used to Sign Malware]( From Schneier on Security A bunch of Android OEM signing keys have been leaked or stolen, and they are actively being used to sign malware. Łukasz Siewierski, a member of Google’s Android Security Team,... T-SQL and Query Languages [Why do we need Correlated Subqueries in SQL]( From SQLShack This article speaks about correlated subquery and why we need it when querying a SQL database. Additionally, we are going to understand the difference between simple subqueries and correlated... [SQL Tells a Human Story]( From Little Miss Data Read through your most complicated SQL files to le... [Bit Twiddling in T-SQL]( From Curated SQL Louis Davidson explains how bit operations work in... Tech News [Babies spend most of their time asleep. New technologies are beginning to reveal why.]( From Technology Review Feed - Tech Review Top Stories This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. Like many other people, I’m pretty... [These exclusive satellite images show Saudi Arabia’s sci-fi megacity is well underway]( From Technology Review Feed - Tech Review Top Stories In early 2021, Crown Prince Mohammed bin Salman of Saudi Arabia announced The Line: a “civilizational revolution” that would house up to 9 million people in a zero-carbon megacity,... [Uber’s facial recognition is locking Indian drivers out of their accountsÂ]( From Technology Review Feed - Tech Review Top Stories Correction: this story has been updated to include... [The metaverse fashion stylists are here]( From Technology Review Feed - Tech Review Top Stories When I met Jenni Svoboda, she was in the midst of designing a beanie with a melted cupcake top, sprinkles, and doughnuts for ears. “It’s something you’d probably never... [New year’s resolutions for CIOs]( From Technology Review Feed - Tech Review Top Stories From security to quantum, AI and edge to cloud, our digital world is evolving and expanding more quickly than ever. With so much “noise,” it can be hard to... [What is Robotics?]( From Past News - RSS Feeds The term robotics conquers up images of armies of humanoid machines, intent on taking over the world. Movies like Terminator, I Robot, and Star Wars suggest that robots are... Virtualization and Containers/Kubernetes [Analyzing Kubernetes Operational Data]( From Dataversity Kubernetes is an infrastructure platform commonly ...  [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -