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
 

Time To Recharge

Redgate is a great place to work for a lot of reasons. One of those has come up for me. It's time for my sabbatical. Every five years we get six weeks paid leave. Mine starts Monday.

I'll still be clearing out my email (the thought of six weeks worth gives me horrors), and I'll be working on rewriting my query tuning book for SQL Server 2022 (that's independent from work). However, except for those two things, no work for me for a while.

Instead, I've got a couple of plans. First, off to see some American Civil War battlefields I wouldn't otherwise have visited. Only two on this trip, but one is a large one; Pea Ridge and Vicksburg. Second, I'm learning how to solder. Why are you looking at me like that? I'm a film school dropout, and a Nuke Machinist Mate. No CS degree, so no soldering. Third, I'm going to goof off. Play some golf. Take a hike. Maybe rent a boat & go fishing.

It's summer. Most people take at least a few days off. I think it's a necessary part of life. Not so much switching off the brain as building new pathways in it so that you can come back to work fresh. I hope you can take some time, even if it's not six weeks, to recharge.

Any plans?

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

Inside a radical new project to democratize AI

From Technology Review Feed - Tech Review Top Stories

PARIS — This is as close as you can get to a roc...

Training vs Inference – Memory Consumption by Neural Networks

From frankdenneman.nl

This article dives deeper into the memory consumption of deep learning neural network architectures. What exactly happens when an input is presented to a neural network, and why do...

Administration of SQL Server

SQLServerCarpenter Tools

From SQLServerCentral Blogs

Over the past couple of years, I’ve developed se...

How to install SQL Server 2022 step by step

From MSSQL Tips

In this article, we cover how to install SQL Serve...

Fixing Ordered Column Store Sorting In SQL Server 2022

From Erik Darling Data

Groove Is In The Heart When Brent posted about th...

New Database Job – The 90 Day Plan

From SQLServerCentral Blogs

In my first post, I reference that by the end of y...

Extended Events for Anything But Query Tuning: xml_deadlock_report_filtered

From Grant Fritchey

One of my favorite little bits of information abou...

Emulating the GROUPS Window Frame Option

From SQLPerformance

Itzik Ben-Gan shows two supported approaches to mi...

Azure SQL Interview Questions and Answers

From SQLShack

Interested in becoming an Azure SQL DBA but don’...

SQL Server 2022 DOP Feedback: Related Extended Events

From Erik Darling Data

Short Round Sort of on the heels of yesterday’s post, here are some Extended Events related to the DOP Feedback feature new to SQL Server 2022. Here’s the complete text of...

Importance of Disk Caching in Azure storage disks for SQL Server workloads

From SQLShack

This article will explore the importance of disk caching in Azure storage for SQL Server workloads. Azure premium storage is used to store IO-intensive workloads like SQL Server database...

Analysis Services / BI on the MS Stack

5 steps to build agile and resilient collections

From AllAnalytics

High unemployment rates of the post-pandemic era i...

The Whiteboard video series on the SQLBI YouTube channel

From Sqlbi

The Whiteboard is a new series on the SQLBI YouTube channel where I use a whiteboard to describe abstract DAX and Tabular concepts in a more interactive way. I...

Making the invisible visible: Doing more with data

From Technology Review Feed - Tech Review Top Stories

Thank you for joining us on “The cloud hub: From...

Azure Databricks, Spark and Snowflake

Snowflake Editions

From SQLServerCentral Blogs

You have decided that snowflake is the technology ...

Azure DevOps

Getting Started with Azure Automation

From AndyLeonard.blog()

Azure Automation has been around for a few years now. I just got started because my brother and friend, Aaron Nelson (@SQLvariant), shared some automation he’s been working on....

Azure SQL Managed Instance

Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance

From Azure Database Support Blog

We used to have cases where our customers reported...

Resumable restore improves SQL Managed Instance database migrations experience

From Azure SQL

Today we are announcing improvements that 1) Enable resumable database backup restores for Azure SQL Managed Instance in case of impactful system updates, and 2) Removal of the 36...

Community Interests

Thank You Allen!

From SQLServerCentral Blogs

I know I can say that I’m a friend of Allen Whit...

T-SQL Tuesday #152

From No Column Name

Words: 375 Time to read: ~ 3 minutes I don’t kno...

Register as a Pre-Con Speaker

From SQLServerCentral Blogs

I’ve been debating how we better organize speake...

Computing in the Cloud (Azure, Google, AWS)

AWS Week In Review – July 11, 2022

From AWS News Blog

This post is part of our Week in Review series. Ch...

AWS Announces Streamlined Deployment for .NET Apps

From Petri IT Knowledgebase

This past July 6, 2022, Amazon announced the relea...

Amazon Redshift Serverless – Now Generally Available with New Capabilities

From AWS News Blog

Last year at re:Invent, we introduced the preview ...

Google Cloud Announces First Arm-based VMs for High-Performance Workloads

From Petri IT Knowledgebase

Google Cloud today announced Tau T2A, its first virtual machines...

DMO/SMO/Powershell

#PowershellBasics: Write the output to a file.

From SQLServerCentral Blogs

Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading The post #PowershellBasics: Write the output to...

Data Access / ORMs

T-SQL Tuesday 152: An ORM Will Not Save You From Yourself

From FLX SQL

T-SQL Tuesday is a monthly blog party hosted by a ...

Data Mining / Data Analysis

A better 3D scatter plot macro

From AllAnalytics

SAS SGPLOT already provides the necessary graphica...

Why learn SQL?

From AllAnalytics

SQL (Structured Query Language) is the most widely...

Database Design, Theory and Development

MISSING DATA AND MULTI-RELATION QUERY RESULTS (T&N)

From Database Debunkings

Note: "Then & Now" (T&N) is a new version ...

Recording: Non relational data modeling & Database engine internals

From Ayende @ Rahien

A few days ago I talked for close to three hours d...

DevOps and Continuous Delivery (CI/CD)

T-SQL Tuesday #152 – Which version of my database was deployed? It depends!

From Eitan Blumin

One of the things that are not so clear about SSDT...

Process Orchestration: Connecting Process Automation Across People, Systems, and Devices

From Dataversity

As organizations push to be more customer-focused and efficient, most are trying to streamline their operations by automating processes. Recent research shows that 92% of IT decision-makers who are...

PowerPivot/PowerQuery/PowerBI

Using an IN Condition for multiple values in Power Query (Power BI)

From FourMoo

In the example I did not want to specify all the c...

Is it a KNOWN ISSUE in Power BI?

From Guy in a Cube

Hitting issues with Power BI can be frustrating. Having to call support can be even more frustrating! What if there was a way to see if it was a...

Quality Checks for your Power BI Visuals

From SQLServerCentral Blogs

For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their... The...

Professional Development

Government tech insider: Technology you need to know right now

From Technology Review Feed - Tech Review Top Stories

Thank you for joining us on “The cloud hub: From...

The Download: tracking teachers online, and how influencers navigate algorithms

From Technology Review Feed - Tech Review Top Stories

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

Replication

Transactional Replication: Where did my data go???

From SQLServerCentral Blogs

Good morning dear reader. Today I am writing this ...

SQL Server News

Upcoming updates to SQL Server container images on Microsoft Artifact Registry aka (MCR)

From MS SQL Server Blog

As you may be aware, SQL Server container images are published and available on the Microsoft Artifact Registry (aka MCR or Microsoft Container Registry). To know more, please see Overview...

Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed

From Azure SQL

Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is...

Security News and Issues

Data of Nearly 2M Patients Exposed in Ransomware Attack on Healthcare Debt Collection Firm

From Dark Reading: Dark Reading News Analysis

Professional Finance Company (PFC) was hit in Febr...

Estimating impact of data breaches on brands across industries and defining a future-ready strategy

From Technology Review Feed - Tech Review Top Stories

Thank you for joining us on “The cloud hub: From...

DHS Review Board Deems Log4j an 'Endemic' Cyber Threat

From Dark Reading: Dark Reading News Analysis

Vulnerability will remain a "significant" threat f...

How Hackers Create Fake Personas for Social Engineering

From Dark Reading: Dark Reading News Analysis

And some ways to up your game for identifying fabr...

Software Development

DateOnly and TimeOnly structures are introduced in NET 6. Can you save them to the database?

From Hasan Savran

       DateOnly and TimeOnly are the new mem...

How Reducing Technical Debt Improves Sustainability

From IT Pro - Microsoft Windows Information, Solutions, Tools

ITOps teams can become more environmentally friend...

Production postmortem: The data corruption in the node.js stack

From Ayende @ Rahien

A customer called us, complaining that RavenDB isn...

T-SQL and Query Languages

Generate Random Dates in T-SQL

From MSSQL Tips

In this article we look at how to generate random ...

Getting Starting with SQL COUNT() and COUNT_BIG() Functions

From MSSQL Tips

In this article, we look at how to get a count of ...

Tech News

How to Upgrade Your Internet Bandwidth

From Glenn Berry

Introduction I recently did some work and spent so...

New York City is drowning in packages

From Technology Review Feed - Tech Review Top Stories

Amazon, Hello Fresh, Stitch Fix. Click a button, a...

The James Webb Space Telescope just delivered some incredible new images of the universe

From Technology Review Feed - Tech Review Top Stories

The first images taken by the James Webb Space Tel...

Raspberry Pi Pico Adds USB Mouse Support to PlayStation 1

From Tom's Hardware US

This Raspberry Pi Pico project, created by Vojtěc...

The Virtual Office: What Challenges Does It Solve?

From IT Pro - Microsoft Windows Information, Solutions, Tools

VR, AR, and mixed reality technologies provide employees with different meeting and training experiences, and encourage productivity.

Raspberry Pi Peers into Deep Space with James Webb Space Telescope Digital Frame

From Tom's Hardware US

Cellar Nerd is using a Raspberry Pi to power his J...

Deloitte to Tech Companies: Carpe Diem on Digital Transformation

From IT Pro - Microsoft Windows Information, Solutions, Tools

Organizations should strategically ramp up on efforts that began during the COVID-19 pandemically, Deloitte said.

Low-code no-code applications will herald a revolution in app creativity and usability

From Technology Review Feed - Tech Review Top Stories

Thank you for joining us on “The cloud hub: From...

Razer’s Stream Controller Let’s You Control Your PC Easily

From Tom's Hardware US

Razer's Stream Controller has 12 haptic switchable...

How IoT Security Affects Data Monetization

From Dataversity

Understanding how IoT security affects data monetization is crucial for businesses to effectively trade intel without the risk of online threats. Today, almost every business shares important data, but...

Virtualization and Containers/Kubernetes

Liberty Mutual’s Container Deployment – From Docker to Kubernetes

From IT Pro - Microsoft Windows Information, Solutions, Tools

Liberty Mutual made an early bet on containers and...

 
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

 

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