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
 

Be Prepared

I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people.

It also inspired me to do another check on our emergency supplies and equipment. No, we don't have some secret bunker to which we're going to retreat when the zombiepocalypse finally hits. But history has shown that it's not crazy to have a few extra bits set aside. Food & water of course, some kind of shelter, flashlight, some batteries for that and maybe a spare phone charger, first aid of course, all worth having on hand. Also, put it all in one place so you can find it quickly. It's not a bad idea to introduce yourself to the neighbors so you can check on them, and they can check on you in an emergency. Finally, if you add equipment to your stash, water purifier or a fire starter, or, like me, a radio or two, be sure you've practiced using that equipment so you know how.

When bad things happen, you're the first person on the spot, so, may as well be as ready as you can be. The last few years have shown, a little preparation is a good thing. The Scout Motto is pretty simple but says it all: Be Prepared.

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.
AI/Machine Learning/Cognitive Services

Why we should all be rooting for boring AI

From Technology Review Feed - Tech Review Top Stories

This story originally appeared in The Algorithm, o...

Neural Networks vs. Deep Learning

From Past News - RSS Feeds

Find out the similarities and differences that exist between neural networks and deep learning and their role in modern AI. The post Neural Networks vs. Deep Learning appeared first on...

Protecting Intellectual Property in the Age of LLM Generative AI Tools

From Dataversity

The emergence of large language models (LLMs) has ushered in a new era of generative AI tools with unprecedented capabilities. These powerful models, such as ChatGPT and others, possess...

AI-Powered Apps Bring a New Level of Observability Challenges

From IT Pro - Microsoft Windows Information, Solutions, Tools

Increased integration of AI into software applications and cloud environments will make monitoring and observability even more difficult. Here's why.

Administration of SQL Server

SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly

From Journey to SQL Authority with Pinal Dave

Providing a comprehensive understanding of their r...

Fun with DATEDIFF – How long DID that process run for?

From Deb the DBA

I was working on a query this week that reminded m...

Generate Test Data Sets for Testing SQL Server Database Applications

From MSSQL Tips

In this article, we look at different approaches f...

SQL SERVER – Scripts to Retrieve Column Names

From Journey to SQL Authority with Pinal Dave

Understanding how to retrieve column names from a ...

Decrypting Stored Procedures with SQL Compare

From SQLServerCentral Blogs

I had a client that was struggling with some encry...

Delegating permission management using Roles vs WITH GRANT OPTION

From Azure SQL

Background In SQL Server/Azure SQL, database-level...

Delegating permission management using Roles vs WITH GRANT OPTION

From MS SQL Server Blog

The article is published here on the Azure SQL Blo...

Persisting data for SQL Server on Docker Swarm with Portworx

From DBA From The Cold

In my last couple of blog posts (here and here) I ...

Essential Database Maintenance Tasks Every DBA Should Know

From StraightPath Solutions SQL Blog

Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. In this blog post, we will explore key tasks and areas...

SQL SERVER – Checking If a Column Exists in a Table

From Journey to SQL Authority with Pinal Dave

Let us see a script that will help check if a Column Exists in a Table. One of the common tasks that developers deal with when working on database-related projects First...

SQL SERVER – Techniques for Retrieving Random Rows

From Journey to SQL Authority with Pinal Dave

This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth. First appeared on SQL SERVER – Techniques for Retrieving...

Analysis Services / BI on the MS Stack

Restoring SSAS Cubes to a SQL 2022 Server with CU5

From SQLServerCentral Blogs

I have a client who was upgrading some servers fro...

Azure SQL

Query Multiple Azure SQL Databases and Save Results Centrally

From MSSQL Tips

In this article, we look at how to query multiple ...

Azure SQL Managed Instance

Advanced scenarios with private endpoints to Azure SQL Managed Instance

From Azure SQL

In the previous installment of this mini-series, we covered basic scenarios involving private endpoints. If you aren’t familiar with private endpoints and Private Link in general, it might be...

Big Data

Is Terraform Still Open Source? It Depends Whom You Ask

From IT Pro - Microsoft Windows Information, Solutions, Tools

HashiCorp has changed the licensing of its widely ...

Cloud - AWS

AWS Weekly Roundup – AWS AppSync, AWS CodePipeline, Events and More – August 21, 2023

From AWS News Blog

In a few days, I will board a plane towards the so...

Community Interests

State of the Database Landscape Survey 2023

From Scary DBA (Grant Fritchey)

As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts...

Computing in the Cloud (Azure, Google, AWS)

How to Keep Cloud Cost Management In Sync with Cloud Maturity

From IT Pro - Microsoft Windows Information, Solutions, Tools

The more mature your cloud strategy, the more complex cloud cost management becomes. Here's how to manage mature cloud strategies cost-effectively.

The Struggles of Cloud and Data: Simplifying with a Single, Unified Solution

From Dataversity

In today’s world, a single-environment approach to IT is no longer supporting the needs of modern businesses. According to my company’s fifth annual Enterprise Cloud Index (ECI), organizations today, and moving...

DMO/SMO/Powershell

Tracking Windows Group Policy Changes With PowerShell

From IT Pro - Microsoft Windows Information, Solutions, Tools

This video tutorial explains how you can use Power...

Simplify Your Work with PowerShell Scripts: Running from the Command Line

From Joyful Craftsmen – The Business Intelligence Agency

Introduction You know that feeling when you have y...

How to Use the PowerShell Get-MessageTrace Command in Office 365

From Petri IT Knowledgebase

The PowerShell Get-MessageTrace command can help O...

Data Mining / Data Analysis

A simple way to bootstrap linear regression models in SAS

From AllAnalytics

I've written many articles about bootstrapping in ...

The new customer experience is here

From AllAnalytics

SAS SVP Kimberly May announces the launch of the n...

Data Visualisation

what is a flowchart?

From Storytelling with Data

  ...

Smart Data Visualization Tells a Story Your Users Will Love

From Dataversity

The Wharton School of Management reports that only...

Database Design, Theory and Development

Achieving Data Immutability in a Backup and Recovery Strategy

From IT Pro - Microsoft Windows Information, Solutions, Tools

Follow the journey of Mirazon, a managed service p...

The Need for Holistic Market Data in Today’s Information-Driven Landscape

From Dataversity

In the age of abundant information, companies face...

Improving Data Quality

From Prologika (Teo Lachev's Weblog)

Poor data quality is one of the most challenging h...

DevOps and Continuous Delivery (CI/CD)

Working with Flyway and Entity Framework Code First: Automation

From Product learning – Redgate Software

This article will demonstrate how to automate a hy...

Applying Agile principles to IT incident management

From Simple Talk

Agile development has grown in popularity in recent years due to its success in delivering software on time and on budget. If you’re looking for a way to make...

How NASCAR Is Racing to ITOps Digital Transformation with ServiceNow

From IT Pro - Microsoft Windows Information, Solutions, Tools

Looking beyond the racetrack, NASCAR has users and employees who are always on the move and need access to IT operations.

ETL/SSIS/Azure Data Factory/Biml

Data Provisioning: Ingest, Curate, and Publish

From Dataversity

A collection of facts from which inferences can be...

TaskFactory Activation Error in Azure-SSIS

From AndyLeonard.blog()

I regularly help customers migrate SSIS to Azure-SSIS integration runtimes, a nifty component of Azure Data Factory. I was recently stumped by an error activating TaskFactory (Task Factory for...

Hardware

Expert Panel on Data Mesh: Capital One Software and Pitney Bowes

From Past News - RSS Feeds

I spoke with an expert panel about the advantages of data mesh, which is a decentralized data architecture that organizes data by specific business domain. Among other advantages, data...

No Storage, No Future Tech: Why Cutting-Edge Innovations Rely on Tried-and-True Data Storage

From Dataversity

Imagine if you asked a large language model to write a fantasy story about a girl who wanders into a magical forest and meets a pirate with the same...

MDX/DAX

Simplifying [DAX] with Staging Tables & Relationships in Power BI

From Havens Consulting

Video by: Reid HavensLearn how to leverage model t...

Machine Learning

Video: Training a Code-First Model in Azure ML

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, we walk thro...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Should I Wait For Microsoft Fabric?

From Paul Andrew

Answer: No But, lets prepare for it in terms of th...

Unveiling Tenant Configuration in Fabric: Empowering User Exploration

From Data – Marc

It has been quiet for a few weeks due to summer br...

Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration

From Simple Talk

I have been working as a no-code data engineer: Fo...

Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 1 - Intro and prerequisites)

From SQLServerCentral Blogs

IntroductionOne integral part of modern Continuous...

Get and use Python Libraries within Microsoft Fabric

From Guy in a Cube

Sometimes you need python libraries that aren't pr...

Oracle/PostgreSQL/MySQL/other RDBMS

Optimizing PostgreSQL Cluster Performance, Part 1 – Load Balancing

Load balancing is a critical component of high availability clusters that optimises performance, scalability, and fault tolerance.

Learning PostgreSQL With Grant: Introducing VACUUM

From Simple Talk

While there are many features within PostgreSQL th...

A Year of PGSQL Phriday Blogging Events

From Software and Booz

Not quite two years ago I had the privilege to giv...

PGSQL Phriday #012: What Excites You About PostgreSQL 16

From Software and Booz

We’ve done it! One full year of mon...

Performance Tuning SQL Server

SQL Server Execution Plan Issues when using TOP Clause and Various Parameters

From MSSQL Tips

In this article, we look at how SQL Server may not...

A twisted tale of memory optimization

From Ayende @ Rahien

I was looking into reducing the allocation in a particular part of our code, and I ran into what was basically the following code (boiled down to the essentials): As...

Index Tuning Essentials Spools: All About Spools In SQL Server Query Plans

From Erik Darling Data

Away Days It’s August, and that means one thing: Family Vacation. I’m taking this month off from regular blogging, and posting some of my paid beginner training content for...

PowerPivot/PowerQuery/PowerBI

Log Out Of Power BI Automatically After A Period Of Inactivity

From Chris Webb's BI Blog

Set up activity-based timeout for Power BI in the ...

Part 2 – Storing the Log Analytics Queries in Azure Blob Storage (Power BI Query Usage and Performance Series)

From FourMoo

Following on in my series, in this blog post I am ...

Initial Microsoft Fabric Git integration tests for Power BI Reports

From Kevin Chant

Reading Time: 8 minutes In this post I to share m...

Get your measures organized in Power BI

From Guy in a Cube

As you make more measures in your Power BI Dataset, it can get hard to find the one you need. Sure you can use search... But you can also...

Access OneLake files from Power BI Desktop

From Data – Marc

Fabric content is all over the place by now. In Fabric, as a SaaS platform, most (if not all) services have interconnectivity. In a few clicks you connect your...

Professional Development

Robotic Process Automation: Is Your Job at Risk?

From IT Pro - Microsoft Windows Information, Solutions, Tools

Robotic process automation software is automating ...

How to Write a Technical Blog That Gets Read

From Simple Talk

There is a relatively simple and quickly learned t...

Improve Your Chances of Getting Noticed by AI on Job Sites with These Tips

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's how to best work with AI matching systems o...

Why I became a TechTrekker

From Technology Review Feed - Tech Review Top Stories

Asked to picture an entrepreneur, most people will...

The Download: introducing the Ethics issue

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our w...

How to Navigate the Integration of IT Consultants

From IT Pro - Microsoft Windows Information, Solutions, Tools

These best practices will smooth the integration of IT consultants with existing IT teams by building a culture of trust and respect.

SQL Server on Linux

How To Set up a Secure VPN Connection in Linux

From IT Pro - Microsoft Windows Information, Solutions, Tools

This guide explains VPN installation and configura...

The Best Linux Commands: A Comprehensive Guide for All Users

From IT Pro - Microsoft Windows Information, Solutions, Tools

This guide offers explanations and examples for important Linux commands. You will learn each command’s capabilities and practical use cases.

Security News and Issues

Tesla Data Breach Investigation Reveals Inside Job

From Dark Reading: Dark Reading News Analysis

The carmaker also reported it's taken legal action...

How culture drives foul play on the internet, and how new “upcode” can protect us

From Technology Review Feed - Tech Review Top Stories

The world of online misdeeds is an eerie biome, cr...

5 Early Warning Indicators That Are Key to Protecting National Secrets

From Dark Reading: Dark Reading News Analysis

The Defense Department must modernize user activit...

More Than Half of Browser Extensions Pose Security Risks

From Dark Reading: Dark Reading News Analysis

Spin.AI's risk assessment of some 300,000 browser ...

When Leadership Style Is a Security Risk

From Dark Reading: Dark Reading News Analysis

Risk-aware leaders can be a cybersecurity advantag...

T-SQL and Query Languages

SQL Server Essentials: Using the SQL GROUP BY Clause

From Petri IT Knowledgebase

SQL Server’s T-SQL query language has a plethora...

Tech News

The ice cores that will let us look 1.5 million years into the past

From Technology Review Feed - Tech Review Top Stories

Moving quickly and carefully in two layers of glov...

Why salt marshes could help save Venice

From Technology Review Feed - Tech Review Top Stories

Venice, Italy, is suffering from a combination of ...

Smart sutures for better healing

From Technology Review Feed - Tech Review Top Stories

Inspired by a technology developed thousands of ye...

A cell that does it all

From Technology Review Feed - Tech Review Top Stories

From “The Troubled Hunt for the Ultimate Cell”...

The beautiful complexity of the US radio spectrum

From Technology Review Feed - Tech Review Top Stories

Somewhere above you right now, a plane is broadcas...

The Lighter Side

The night sky of Cambridge

From Technology Review Feed - Tech Review Top Stories

By day, Evan Kramer, SM ’22, works on his PhD in...

Virtualization and Containers/Kubernetes

VMware Unveils New Multi-Cloud and Kubernetes Tools

From IT Pro - Microsoft Windows Information, Solutions, Tools

At its VMware Explore conference, the company intr...

Prelude Security Tackles Continuous Security Testing in Containers

From Dark Reading: Dark Reading News Analysis

Probes are tiny processes which run inside contain...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -