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
 

Outside Interests

I'm a little excited because tomorrow I'm going to my first maker's faire. I'll be volunteering with our local radio club (100 year old, W5IAS, oldest radio club in Oklahoma). In addition, I'll be showing off a few controller chips & Raspberry Pis that I use with my radios for APRS, satellite tracking, and digital radio modes, among other things. I'll let people try to make digital contacts with my radios too. I'm also looking forward to seeing what else is on display at the maker's faire. Should be a good time overall.

"Oh no," I hear you thinking, "Grant's talking radio again. Can anyone shut him off?"

Short answer, no. But, bear with me a minute.

My wife is, as near as I can tell, allergic to radios. She's never going to get her license and doesn't care about the darned things at all. Instead, she loves taking art classes. We have a couple of bowls and some mugs she made at pottery class in use in the house. She loves going to the German-American club here in Tulsa to continue getting better at speaking German. We both go to trivia night sometimes at a couple of local bars.

In short, in addition to our jobs, we have outside interests. More geeky goodness in my case, art and language in hers (yeah, I know, I married up). Those outside interests do a lot for our mental, emotional, and even physical, health. In addition to engaging the brain so that it remains pliable, we meet with people on a social level. Actual humans, interacting. Plus, I even get outside sometimes to hike around & play Parks on the Air with the radio. All this contributes to better all-round health.

Look, you're not getting younger. If you don't have some outside interests, I strongly recommend you find them. It'll help with your emotional and mental well being. Plus, finding the right interest for you, it's just fun. Better health and fun means not only a longer life, but a more fulfilling one. So get on out there & do something (even if it's not radios).

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

Find the Version of a Flyway-managed Database

Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. The article describes various ways to get the current Flyway schema version from Flyway, and how to get it using SQL, in SQL Server, MySQL, PostgreSQL and SQLite.

AI/Machine Learning/Cognitive Services

How to fine-tune AI for prosperity

From Technology Review Feed - Tech Review Top Stories

When Chad Syverson loads the US Bureau of Labor St...

Appy Pie (2024 Review): What We Love and What We Don’t

From Past News - RSS Feeds

Looking for an Appy Pie review? Discover what we l...

We finally have a definition for open-source AI

From Technology Review Feed - Tech Review Top Stories

Open-source AI is everywhere right now. The proble...

AI could be a game changer for people with disabilities

From Technology Review Feed - Tech Review Top Stories

As a lifelong disabled person who constantly copes...

Administration of SQL Server

Troubleshooting High CPU Utilization in SQL Server

From MSSQL Tips

Check out this CPU monitoring solution for SQL Ser...

Auditing SQL Server – Part 4 – Database Configuration Audit

From Simple Talk

This continues my series on auditing SQL Server. T...

Why ‘Max Server Memory’ Isn’t Always the Limit

From Journey to SQL Authority with Pinal Dave

What if I told you that setting a limit with "max ...

Resuming Data Movement in Always On

From Callihan Data

Keeping an Always On Availability Group healthy is...

Large Uniquifier Values

From Michael J. Swart

Hey what’s up? It’s been a while. If you defin...

Effective Strategies for Storing and Parsing JSON in SQL Server

From Simple Talk

Like XML, JSON is an open standard storage format ...

How to Access the SQL Server Error Log

From MSSQL Tips

Learn about three different ways to access and rea...

LIKE Constraints

From Simple Talk

 

Azure Databricks, Spark and Snowflake

Even more Great Queries Using Query History

From Sherpa of Data

In our last post, we talked about some of my favor...

Change Data Capture Pipeline Automation in Snowflake

This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC capabilities. The examples will be using healthcare type data, but the basic tenets apply in most use cases.

Azure DevOps

Creating a Test Pipeline in Azure DevOps using a Windows Agent

From SQLServerCentral Blogs

A customer was having some trouble getting started...

Azure SQL

Automate shrink database in Azure SQL

From Azure Database Support Blog

While shrinking a database is typically not advise...

Cloud - AWS

My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github…

From SQLServerCentral Blogs

My personal experience Dockerizing a Ruby on Rails...

Add macOS to your continuous integration pipelines with AWS CodeBuild

From AWS News Blog

AWS CodeBuild now supports macOS, simplifying CI/C...

Now open — AWS Asia Pacific (Malaysia) Region

From AWS News Blog

The new AWS Asia Pacific (Malaysia) Region bolster...

Community Interests

SQL Saturday Denver 2024 Resources

From SQLServerCentral Blogs

Here are the resources from my talks today. Best P...

Back to Syracuse for SQL Saturday

From SQLServerCentral Blogs

Syracuse is having their first SQL Saturday on Sep...

Conferences, Classes, Events, and Webinars

Join us in London for our Redgate London Seminar: Database Monitoring

Now, more than ever, it is essential to have proactive, compliant, and automated monitoring of database estates. Join us in London on September 26th where our experts will demonstrate how Redgate Monitor can improve your estate and proactively detect issues before they impact your business. With morning and afternoon sessions, join for a morning of a technical deep-dive or afternoon of understanding strategic business value when implementing a robust monitoring solution.

Data Mining / Data Analysis

Your reports can get you fired!

From Sqlbi

Honestly, a slow report makes people angry, but a ...

Master Advanced SQL: 2 Essential Courses for Every Data Analyst

From SQLServerCentral Blogs

If you're a data analyst, you already know that SQ...

The future of insurance – predict and prevent

From AllAnalytics

Going forward, insurance will be based on data and...

(Livestream Replay) Building an Analytics Team - with Reza Rad

From Havens Consulting

DESCRIPTION With all the activities and announ...

Database Design, Theory and Development

The rising need for database monitoring in Financial Services

From Blog – Redgate Software

Every IT and data team in Financial Services is al...

Caching documents in RavenDB: The good, the bad and the ugly

From Ayende @ Rahien

RavenDB has a hidden feature, enabled by default a...

The rise of the data platform for hybrid cloud

From Technology Review Feed - Tech Review Top Stories

Whether pursuing digital transformation, exploring...

DevOps and Continuous Delivery (CI/CD)

Managing Database code

From Curious..about data

This is my own contribution to the T-SQL Tuesday I...

T-SQL Tuesday 177 roundup: Managing database code

From Curious..about data

I was privileged to host yet another T-SQL Tuesday...

Platform Engineering: The Next Step in Operations

From O'Reilly Radar - Insight

Platform engineering is the latest buzzword in IT ...

DevSecOps Needs Are Shifting in the Cloud-Native Era

From IT Pro - Microsoft Windows Information, Solutions, Tools

Research from ESG identifies DevSecOps gaps that o...

Using Flyway and Data Containers for Database Testing: Rapid Setup and Teardown

From Product learning – Redgate Software

This article demonstrates how to use the rgclone C...

Embracing Data and Emerging Technologies for Quality Management Excellence

From Dataversity

In today’s rapidly evolving business landscape, ...

Grafana Labs Raises $270M: What Does It Mean for State of ITOps?

From IT Pro - Microsoft Windows Information, Solutions, Tools

Grafana Labs is powering forward as it tackles the...

Hardware

Qualcomm Adds Snapdragon 7s Gen 3: Mid-Tier Snapdragon Gets Cortex-A720 Treatment

From AnAndTech

Qualcomm this morning is taking the wraps off of a...

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

Microsoft Fabric: Troubleshooting Query Parameters in Published Semantic Models

From BI Insight

Power Query is a powerful tool within the Microsof...

Which Microsoft Fabric SQL Analytics Endpoint should you use?

From Guy in a Cube

Both the Microsoft Fabric lakehouse and warehouse ...

Performance Tuning SQL Server

What Are the Most Common Blockers to Adopting SQL Server Extended Events?

From Scary DBA (Grant Fritchey)

Yeah, stupid long title. It’s a question I put t...

Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes

From MSSQL Tips

This article explores how raising the Cost Thresho...

A Little About Computed Columns, Filtered Indexes, and Indexed Views in SQL Server

From Erik Darling Data

A Little About Computed Columns, Filtered Indexes,...

PostgreSQL

Jeremy Schneider: Good Benchmark Professionals and Postgres Benchmark Week

From Planet Postgres

There are four major components to being a good be...

Hayato Kuroda: PGConf.dev 2024 - New logical replication features in PostgreSQL 17

From Planet Postgres

The PostgreSQL Development Conference 2024 was hel...

PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used

Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only as a means to increase performance on large tables. While it’s certainly useful for this, it’s also an invaluable tool for solving common data maintenance problems. In this article, we’ll examine the feature from this perspective.

Professional Development

Cisco Cuts Thousands, Looks to Profit as Enterprises Prep for AI

From IT Pro - Microsoft Windows Information, Solutions, Tools

Revenue dropped 10% year-over-year, and Cisco's br...

GM to Cut More Than 1,000 Software Engineers, Mostly in US

From IT Pro - Microsoft Windows Information, Solutions, Tools

The automaker has been developing in-car software...

Tech Company Layoffs: The COVID Tech Bubble Bursts

From IT Pro - Microsoft Windows Information, Solutions, Tools

UPDATED Aug. 17, 2024 — As COVID-19 drove everyo...

Navigating the Tech Job Market to Land the Perfect Role

From IT Pro - Microsoft Windows Information, Solutions, Tools

Navigating the evolving tech job market demands th...

A Brief History of Data Ethics

From Dataversity

In this digital age, where data is an increasingly...

The Shifting Priorities of IT Professionals in 2024 (Infographic)

From IT Pro - Microsoft Windows Information, Solutions, Tools

This infographic explores changes in the IT indust...

Reporting Services

SQL Server Reporting Services Quick Reference Guide

From MSSQL Tips

This article includes several links to key SQL Ser...

Security News and Issues

National Public Data Confirms Massive Breach

From IT Pro - Microsoft Windows Information, Solutions, Tools

Cyber incidents like this highlight the need for t...

Hacking Wireless Bicycle Shifters

From Schneier on Security

This is yet another insecure Internet-of-things st...

Software Development

Building Studio in Public: Maintaining High Performance in Our Local Development App for Enhanced UX

From SQL DBA with A Beard

In this post, we share the strategies and techniqu...

Tech News

The race to save our online lives from a digital dark age

From Technology Review Feed - Tech Review Top Stories

There is a photo of my daughter that I love. She i...

Why you’re about to see a lot more drones in the sky

From Technology Review Feed - Tech Review Top Stories

This story is from The Algorithm, our weekly newsl...

Want to understand the future of technology? Take a look at this one obscure metal.

From Technology Review Feed - Tech Review Top Stories

This article is from The Spark, MIT Technology Rev...

The Download: the future of human evolution, and touch sensing for robots

From Technology Review Feed - Tech Review Top Stories

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

Tech that measures our brainwaves is 100 years old. How will we be using it 100 years from now?

From Technology Review Feed - Tech Review Top Stories

This article first appeared in The Checkup, MIT T...

The Lighter Side

9 Travel Tech Gadgets to Elevate Your Next Adventure

From IT Pro - Microsoft Windows Information, Solutions, Tools

From compact chargers and action cameras to noise-...

CodeSOD: Maximally Zero

From Daily WTF

Today's anonymous submitter found some Java code w...

Take a Selfie Using a NY Surveillance Camera

From Schneier on Security

This site will let you take a selfie with a New York City traffic surveillance camera.

flyway

Flyway’s Repair Command Explained Simply

From Product learning – Redgate Software

The Repair command allows Flyway migrations to rec...

 
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

 

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