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
 

It's The People

Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel schedule this year may be contributing to that). However, I had such a great time last week. The vibe, the feeling in the hall, was really up, positive, and just generally good this year. Further, it reminded me of things to keep centered.

First, friends and acquaintances. Those who know me well, personally, will attest that I'm not always the greatest about reaching out and keeping in touch. However, seeing a lot of people I hadn't seen for a while, some not for years, reminds me just how important it is to actually maintain your contacts. I'm insanely lucky to know some pretty amazing individuals. I need to do a better job of keeping in touch with them.

Next, the hallway track. If you've never been to a large conference, you may not have seen the hallway track on full display. It's not the same at smaller events like a Data Saturday or SQL Saturday. Larger events will see people congregate in the halls, sometimes in designated spots, like the Community Zone at Summit. There, you frequently can get as good answers as you will asking a speaker in a session. Sometimes better. I made a point this year of spending more time out there and had some really meaningful and helpful conversations because of it.

Your hotel room is primarily for sleeping, but make sure you sleep. I get it. We're nerds (or geeks, or whatever your preferred term is for IT people). As such, introverts are probably overly represented amongst us. Further, as nerds, we can be much more comfy communicating with machines than people. However, if you want to truly take advantage of an event like the Data Community Summit, you need to spend the week, out with people. Make those contacts. Be open, aggressively friendly, and ready to talk to others. Sure, by the end of the week you're exhausted, but you only get a shot like this once in a while. These are your peers. Get to know them.

I'm sure you see a pattern. As much as I love attending sessions, and I do, I think these in-person events are all about the people there. Like it or not, we're not far removed from our cavemen ancestors and still largely communicate as they do. Our, and their, best way of communicating is face-to-face. So, when you get that opportunity for the best communication, take advantage of it. It's how you build your network. A good network, makes you happier, smarter, and more employable. If you haven't had the opportunity to make it to the PASS Summit, or another big in-person event, I'd strongly recommend you try it out. Just, when you go, plan to focus at least some of the time on getting to know a few people.

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

Claude AI to process secret government data through new Palantir deal

From Ars Technica

Critics worry Anthropic is endangering its "ethica...

How a stubborn computer scientist accidentally launched the deep learning boom

From Ars Technica

"You’ve taken this idea way too far," a mentor t...

New secret math benchmark stumps AI models and PhDs alike

From Ars Technica

FrontierMath's difficult questions remain unpublis...

The Role of Data Engineering in AI and Machine Learning Projects

From Dataversity

Artificial intelligence and machine learning are r...

Marketers tap AI for synthetic data generation

From AllAnalytics

Synthetic data generation, as its name suggests, i...

AI Agents Set to Transform Customer Experience Landscapes

From Past News - RSS Feeds

AI agents are at the forefront of a customer servi...

Google DeepMind has a new way to look inside an AI’s “mind”

From Technology Review Feed - Tech Review Top Stories

AI has led to breakthroughs in drug discovery and robotics and is in the process of entirely revolutionizing how we interact with machines and the web. The only problem...

The Download: diversifying AI voices, and a science-fiction glimpse into the future

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. How this grassroots effort could make AI...

OpenAI accused of trying to profit off AI model inspection in court

From Ars Technica

How do you get an AI model to confess what's inside?

Administration of SQL Server

Temporal Tables

From Prologika (Teo Lachev's Weblog)

I like SQL Server temporal tables for implementing...

SQL SERVER – Dynamic Data Masking (DDM) Introduction

From Journey to SQL Authority with Pinal Dave

Dynamic Data Masking (DDM) in SQL Server is a feat...

Monday Monitor Tips: Tracking The Cost of Instances

From SQLServerCentral Blogs

One of the things that I’ve been asked in every ...

SQL SERVER – Implementing Row-Level Security (RLS)

From Journey to SQL Authority with Pinal Dave

Row-Level Security (RLS) in SQL Server enables fin...

Video: SQL Server Backup Tuning and Configuration

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, I cover seve...

Master the Foundational Basics

From SQLServerCentral Blogs

It tells us to take the time to master the foundat...

New SQL 2022 Server and Database Roles and Permissions

From SQLRx

Well…..I just learned about these and thought th...

Analysis Services / BI on the MS Stack

Building Effective Data Governance Framework: Top Areas to Focus On

From Joyful Craftsmen – The Business Intelligence Agency

The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first on Joyful Craftsmen.

Cloud - AWS

Announcing new APIs for Amazon Location Service Routes, Places, and Maps

From AWS News Blog

Amazon Location unveils 17 new APIs with enhanced ...

AWS BuilderCards second edition at re:Invent 2024

From AWS News Blog

AWS BuilderCards 2nd Edition: Gamify AWS learning ...

Amazon ready to use its own AI chips, reduce its dependence on Nvidia

From Ars Technica

Annapurna Labs, acquired by Amazon in 2015, will r...

Introducing resource control policies (RCPs), a new type of authorization policy in AWS Organizations

From AWS News Blog

New Resource Control Policies let you centrally re...

Community Interests

PASS Keynote – Day 2 – Redgate

From Simple Talk

  Time to start! Annabel Bradford (Head of Events...

PASS Keynote – Day 3 – Community Keynote

From Simple Talk

Intro Ben Weissman, who is not going to retire aft...

PASS Data Community Summit 2024 Day 3 Keynote

From SQLServerCentral Blogs

It’s been an amazing week here, as well as a lon...

Social Anxiety and Events Like the PASS Summit

From SQLServerCentral Blogs

If you are an introvert like me, events like the P...

PASS Experts Clinic Was a Huge Success

From DCAC

Last week, at the PASS Summit in Seattle, the DCAC...

Computing in the Cloud (Azure, Google, AWS)

Our Cloud Storage Provider Went Down. Now I’m Rethinking Our Strategy.

From IT Pro - Microsoft Windows Information, Solutions, Tools

An IT admin is looking for practical strategies to...

Conferences, Classes, Events, and Webinars

The SQLskills Black Friday Super Sale!

Starting at 4pm PST on Thursday, November 28th, SQLskills will be offering our lowest prices ever for our signature Blackbelt bundle with more than 158 hours of top-quality training.

Data Mining / Data Analysis

why I’m not a fan of candy graphs (and what we should do instead)

From Storytelling with Data

After Halloween, my social media fills up with pic...

KQL: The top of a group in an easy way

From Simple Talk

When learning something new, we always compare it ...

Our Storytellers: Casey Hensley

From AllAnalytics

Balancing a career and raising a family is a juggl...

Turbocharging SQL Server OLAP in the Cloud: Unveiling the Real Impact of Hyperthreading on Performance

From The SQL Herald (Joey D'Antoni)

Database performance, especially in the cloud, is always a big concern. Traditionally, cloud storage has not performed as well as high-end on-premises storage. The introduction of faster cloud storage...

Creating loyal customers through personalized, mobile-first engagement

From AllAnalytics

As consumers increasingly embrace a mobile-first lifestyle, businesses across various industries – from retail and banking, to insurance and telecommunications – are under pressure to create personalized and engaging...

Data Warehousing

Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables

From MSSQL Tips

How we handle data warehousing updates to dimensio...

Database Design, Theory and Development

How Organizations Can Overcome Barriers to Leveraging Real-Time Data

From Dataversity

Digital-first businesses are managing an overwhelm...

From Chaos to Clarity: How Metadata Shapes the Future of Data Management

From Dataversity

Just as the sun serves as the gravitational center...

Navigating the Sea of Data Mapping Solutions

From Dataversity

This is the third and final blog post in my “Charting a Course Through the Data Mapping Maze.” If you’ve been following the previous posts, thanks for joining me on...

Fun with bugs: Advanced Dictionary API

From Ayende @ Rahien

In RavenDB, we really care about performance. That means that our typical code does not follow idiomatic C# code. Instead, we make use of everything that the framework and the language...

DevOps and Continuous Delivery (CI/CD)

How to Maximize DevOps Efficiency with Platform Engineering

From IT Pro - Microsoft Windows Information, Solutions, Tools

While platform engineering can enhance DevOps, poo...

Demystifying Continuous Integration vs. Continuous Delivery: Part 2

From Simple Talk

Welcome to part 2 of our Demystifying Continuous I...

Supercharge your debugging with git bisect

From You've Been HAACKED

Git bisect is an underrated but very powerful tool...

Simple Talks Episode 9–Data masking and subsetting

From SQLServerCentral Blogs

The episode on data masking and subetting is out. ...

An Automated Approach to Getting Data In And Out Of Databases

From Product learning – Redgate Software

Extracting and importing development and test data is often challenging due to difficulties with database constraints, dependencies and special data types. This article aims to provide a cross-RDBMS way...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Execute Stored Procedures in the Microsoft GraphQL API

From MSSQL Tips

This tip explores leveraging existing SQL Server s...

HA/DR/Always On/Clustering

How to see restore history of a deleted database?

From Andy M Mallon – AM²

Question For example, I had a database and I want ...

Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees

From IT Pro - Microsoft Windows Information, Solutions, Tools

As businesses rely more on SaaS applications, inte...

Why Overlooking Identity in Disaster Recovery Is Putting Businesses at Risk

From IT Pro - Microsoft Windows Information, Solutions, Tools

To protect critical operations, organizations shou...

Hardware

TSMC will stop making 7 nm chips for Chinese customers

From Ars Technica

US restrictions on semiconductor tech are spurring...

Understanding Smart Grids: The Future of Energy Management

From Past News - RSS Feeds

Smart grids are revolutionizing energy management,...

Review: The fastest of the M4 MacBook Pros might be the least interesting one

From Ars Technica

Not a surprising generational update, but a lot of...

IBM boosts the amount of computation you can get done on quantum hardware

From Ars Technica

Incremental improvements across the hardware and s...

After working with a dual-screen portable monitor for a month, I’m a believer

From Ars Technica

More pixels and versatility, but without the sacrifices of dual-screen PCs.

What Comes After HoloLens 2? Exploring Microsoft’s AR/VR Future

From IT Pro - Microsoft Windows Information, Solutions, Tools

Microsoft revealed no plans for an immediate HoloLens 2 successor, raising questions about the company’s commitment to its VR/AR technologies.

Hardware Testing

Review: Amazon’s 2024 Kindle Paperwhite makes the best e-reader a little better

From Ars Technica

If you use any Kindle other than the 2021 Paperwhite, this is a huge upgrade.

Internet of Things

Navigating the Convergence of Edge Computing, IoT, and OT With AIOps

From IT Pro - Microsoft Windows Information, Solutions, Tools

By providing contextualization within the larger IT estate, AIOps ensures seamless performance, enhanced security, and operational efficiency.

Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices

From SQLServerCentral Blogs

Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major milestone for ARM-powered devices. This new release opens the door for users to install Windows... The...

MDX/DAX

Collaborate with your Team and Customers with DAX Optimizer

From Sqlbi

Share analysis results (read-only) with customers ...

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

Importing items to Fabric workspaces sounds easier than it is

From Data – Marc

Obviously, you don’t want to start every solutio...

Fabric Data Factory Design Pattern – Execute a Collection of Child Pipelines from Metadata

From AndyLeonard.blog()

Please find the landing page for this series here....

How to create a Case Insensitive Warehouse in Microsoft Fabric

From FourMoo

This is a quick blog post to show you how to use a...

Performance Tuning SQL Server

T-SQL Tuesday #180: Good Enough is Perfect

From Andy Broadsword

This month, Josephine has asked how we achieve ...

SQLServer Gradually Becomes Slow Until Reboot

From Ajay Dwivedi's SQL Server Blog

How to resolve issue where SQLServer gets slow over time until reboot The post SQLServer Gradually Becomes Slow Until Reboot appeared first on SQLServer Performance Optimization and Automation.

How To Get Rid Of NOLOCK Hints Forever

From Erik Darling Data

How To Get Rid Of NOLOCK Hints Forever Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my...

PowerPivot/PowerQuery/PowerBI

Tuning Power BI Copilot With Summarize By

From Chris Webb's BI Blog

Continuing my occasional series of ways you can im...

Professional Development

How Employers Can Help Veterans Advance in Their Careers

From IT Pro - Microsoft Windows Information, Solutions, Tools

Veterans face unique challenges transitioning to c...

T-SQL Tuesday 180 – Good enough is perfect

From Kevin Chant

Reading Time: 3 minutes For this months T-SQL Tue...

T-SQL Tuesday 180 – The enemy of good?

From SQL Server Fast

Another month, another T-SQL Tuesday. Edition 180 ...

T-SQL Tuesday #180: Avoid Perfect for Good Enough

From SQLServerCentral Blogs

I'm listening to Effortless by Greg McKeon (link t...

Book Review – Humanizing Data Strategy by Tiankai Feng

From SQLServerCentral Blogs

This book was making its rounds on social media, a...

T-SQL Tuesday #180 – Good enough is perfect

From Simple Talk

Today’s post is in reply to the invitation post,...

T-SQL Tuesday #180: Good Enough is Perfect

From Callihan Data

For the penultimate T-SQL Tuesday invite of 2024, ...

Are standing desks good for you? The answer is getting clearer.

From Ars Technica

Whatever your office setup, the most important thing is to move.

Security News and Issues

Data Control Language (aka Security)

From Simple Talk

Like ancient Gaul, SQL is divided into three sub- ...

Criminals Exploiting FBI Emergency Data Requests

From Schneier on Security

I’ve been writing about the problem with lawful-...

Charges Unsealed for Alleged Hackers of Snowflake Customers

From IT Pro - Microsoft Windows Information, Solutions, Tools

50 billion call and text records were stolen from ...

Inside the DemandScience by Pure Incubation Data Breach

From Troy Hunt

Presently sponsored by: 1Password Extended Access ...

Linux Server Security: Essential Guide for Hardening Servers

From IT Pro - Microsoft Windows Information, Solutions, Tools

With Linux systems increasingly under threat, this...

Discord admin gets 15 years for “one of the most significant leaks” in US history

From Ars Technica

Former airman's arrest raised questions about who ...

New iOS Security Feature Makes It Harder for Police to Unlock Seized Phones

From Schneier on Security

Everybody is reporting about a new security iPhone security feature with iOS 18: if the phone hasn’t been used for a few days, it automatically goes into its “Before...

Consumer Sector Becomes Top Ransomware Target

From IT Pro - Microsoft Windows Information, Solutions, Tools

Although attacks slightly decreased last quarter, ransomware remains a critical threat, with new strains like Cicada3301 targeting Linux and ESXi systems.

Good Essay on the History of Bad Password Policies

From Schneier on Security

Stuart Schechter makes some good points on the history of bad password policies: Morris and Thompson’s work brought much-needed data to highlight a problem that lots of people suspected was...

T-SQL and Query Languages

Calculate a Moving Average with T-SQL Windowing Functions

From MSSQL Tips

Learn how to create a moving average in SQL Server...

Tech News

After decades, FDA finally moves to pull ineffective decongestant off shelves

From Ars Technica

Last year, FDA advisers unanimously voted that ora...

The voice of America Online’s “You’ve got mail” has died at age 74

From Ars Technica

His cassette recording, made for $200 in 1989, was...

Space policy is about to get pretty wild, y’all

From Ars Technica

Saddle up, space cowboys. It may get bumpy for a w...

DNA shows Pompeii’s dead aren’t who we thought they were

From Ars Technica

Integrating genetic data with historic and archaeo...

There are some things the Crew-8 astronauts aren’t ready to talk about

From Ars Technica

"I did not say I was uncomfortable talking about i...

Mapping License Plate Scanners in the US

From Schneier on Security

DeFlock is a crowd-sourced project to map license ...

Firefly Aerospace rakes in more cash as competitors struggle for footing

From Ars Technica

The Series D fundraising round was "oversubscribed...

How IoT Is Shaping Resilience and Innovation in a Changing World

From IT Pro - Microsoft Windows Information, Solutions, Tools

According to Eseye's 2024 report, IoT adoption is ...

Silicon Valley Eyes a Windfall From Trump’s Plans to Gut Regulation

From IT Pro - Microsoft Windows Information, Solutions, Tools

Some tech start-ups and investors anticipate a golden era when Donald Trump returns to office, thanks to government contracts and deregulation.

Data Is Not the New Oil: It’s More Like Uranium

From Dataversity

In today’s digital world, data is the most critical enterprise asset. Data is required to run software, drive business intelligence, and deliver new functionality. Consequently, companies have tried to...

We’re in our developer era

From AllAnalytics

Fearmongers would have you believe that AI will replace us, but I truly believe there has never been a better time in history to be a developer. With the...

FTC to launch investigation into Microsoft’s cloud business

From Ars Technica

Microsoft is accused of using punitive licensing terms for Azure.

The Lighter Side

CodeSOD: Pay for this Later

From Daily WTF

Ross needed to write software to integrate with a ...

This elephant figured out how to use a hose to shower

From Ars Technica

A younger rival may have learned how to sabotage t...

CodeSOD: The First 10,000

From Daily WTF

Alicia recently inherited a whole suite of home-gr...

What did the snowball Earth look like?

From Ars Technica

Entire continents, even in the tropics, seem to ha...

How To Repair Corrupt STL Files for 3D Printing

From IT Pro - Microsoft Windows Information, Solutions, Tools

Repair options include using dedicated STL repair software, manual CAD edits, or slicer repair tools, along with preventative practices like backing up files and checking geometry integrity to ensure...

Error'd: Tangled Up In Blue

From Daily WTF

...Screens of Death. Photos of failures in kiosk-mode always strike me as akin to the wizard being exposed behind his curtain. Yeah, that shiny thing is after all...

I, too, installed an open source garage door opener, and I’m loving it

From Ars Technica

OpenGarage restored my home automations and gave me a whole bunch of new ideas.

Virtualization and Containers/Kubernetes

New SMB-friendly subscription tier may be too late to stop VMware migrations

From Ars Technica

Broadcom acquisition was a "wake-up call" for VMwa...

 
RSS FeedTwitter
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

 

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