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
 

The Leaves Are Changing, But Why?

I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors...

WAIT!

Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry recently. Those trees are changing color because they just don't have enough water. They're turning brown a little prematurely. After all, it's still effectively summer here in Oklahoma (101 degrees two days ago, 38.3 for the rest of the world).

We make assumptions based on observations. However, sometimes, even though we're accurate in our observations, we're not so accurate in our assumptions. When it comes to technology, we really do need to focus on ensuring that we know the true root cause of issues rather than make assumptions based on incomplete data. Get a complete picture before you start making changes to systems. Otherwise, you really could create more problems than you fix.

The trees are still pretty though.

Grant Fritchey

Join the debate, and respond to the editorial on the forums

 
pass-pro-educational-series
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

Flyway Without the Typing

How to use Flyway configuration files to minimize typing during ad-hoc development from PowerShell or DOS; you just type in the Flyway commands you need and hit "go" and the config files take care of all the tiresome connection, authentication and project details.

AI/Machine Learning/Cognitive Services

How AI Will Change IT Jobs

From IT Pro - Microsoft Windows Information, Solutions, Tools

As artificial intelligence grows increasingly powe...

Administration of SQL Server

Download and Analyze Stooq Historical Stock Price and Volume Data in SQL Server

From MSSQL Tips

In this article we look at T-SQL code you can use ...

Set up access to network shares from SQL Server

From Sunday morning T

Using a local service account for your SQL Server ...

SQL Homework – September 2021 – How good is your recovery plan?

From SQLStudies

Last month I had you create a security standards d...

Server roles for Azure SQL Database Server: Database Management without admin-access

From Azure SQL

Server roles for Azure SQL Database Server: Databa...

How to Read and Interpret SQL Errors

From SQL Server – {coding}Sight

Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on the SQL version you’re using, but...

SQL Server identity column

The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.

Analysis Services / BI on the MS Stack

Overlaying Trends from Different Dates

From Excelerator BI

In my video today, I continue to build out my Powe...

Azure Databricks, Spark and Snowflake

Announcing Azure SQL Migration extension for Azure Data Studio - public preview

From Azure SQL

With rising demands from the ever-changing busines...

Azure SQL Database

The Azure SQL portfolio

From Simple Talk

Microsoft provides many ways to run SQL Server in ...

Server roles for Azure SQL Database: Database Management without admin-access

From Azure SQL

Server roles for Azure SQL Database: Database Mana...

Azure SQL Elastic Pool – Understanding and Creating

From SQL Server – {coding}Sight

Microsoft Azure offers many PAAS services for addressing the database requirements based on the nature of data and transaction workload. Azure SQL Database is one of the popular PAAS...

Creating Replicas in Azure Database for PostgreSQL

Data hosted in data repositories is accessed by a variety of applications. When data repositories are migrated from one hosting platform to another or when the load on a data repository increases, typically replication is adopted as an interim or a long-term solution approach.

Big Data

Fail Fast, Learn Faster: The Story of Big Data

From Past News - RSS Feeds

Randy Bean’s book, “Fail Fast, Learn Faster”...

Community Interests

Our favorite community events beyond Redgate

From Blog – Redgate Software

We host a lot of events at Redgate, from Summits to webinars, podcasts to panel discussions. Guest speakers like Donovan Brown from Microsoft, Tony Madonna from BMW, and Chris...

Computing in the Cloud (Azure, Google, AWS)

What is Power Automate? Codeless Automation for the Cloud

From IT Pro - Microsoft Windows Information, Solutions, Tools

What is Power Automate? Like other no-code automat...

Conferences, Classes, Events, and Webinars

Panel discussion: monitoring for your growing estate

Join Grant Fritchey and database professionals from WestJet, Fiducia Gad and Richemont to learn how effective estate monitoring enables them to manage continually evolving environments, and intensifying data demands.

Discover Cloud Native development with Dapr

Donovan Brown and Mark Fussell, Program Managers from the Azure CTO Incubations team at Microsoft, join Steve Jones to talk all things modern Cloud Native development with Dapr.

DMO/SMO/Powershell

Diff-Objects: a PowerShell utility Cmdlet for Discovering Object differences

From Simple Talk

Introduction It is important for many development jobs to be able to look at the differences between PowerShell objects. It might be that you are checking how Windows processes...

Data Warehousing

Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses

From SQLShack

Introduction Slowly Changing Dimensions in Data Warehouse is an important concept that is used to enable the historic aspect of data in an analytical system. As you know, the...

DevOps and Continuous Delivery (CI/CD)

Sharing knowledge in communities of practice

Communities of practice bring people together to share ideas and learn from each other about a common interest. In this article, Robert Sheldon explains and gives some advice on starting them.

Oracle

Oracle sequences – 12c features including “identity”

Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new features.

Performance Tuning SQL Server

Find Problematic SQL NOLOCK Patterns in SQL Server DML Statements - Part 4

From MSSQL Tips

In this article we look at how to find NOLOCK usag...

SQL Query recompilations and query performance effects

From SQLShack

This article will mention in which conditions the ...

Handling Implicit Conversion

From Callihan Data

Implicit conversion occurs when SQL Server needs t...

SARGability Week: Wrap Up

From Erik Darling Data

One Metric Week This went on a bit longer than I thought it would, but to someone who tries to blog five days a week, that’s a good thing. While this...

PowerPivot/PowerQuery/PowerBI

CRUSHING requirements with Small Multiples in Power BI

From Guy in a Cube

Check out how using Small Multiples in Power BI ca...

Popular Power BI Interview Questions

From SQLShack

In this article, we are going to learn about the m...

Schedule, Export and Email Power BI Reports using Power Automate

From MSSQL Tips

Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate.

Security News and Issues

The State of Cloud Security

From IT Pro - Microsoft Windows Information, Solutions, Tools

It's critically important that businesses have con...

Juniper Breach Mystery Starts to Clear With New Details on Hackers and U.S. Role

From IT Pro - Microsoft Windows Information, Solutions, Tools

Juniper’s case is “a perfect example of the da...

DDoS Attacks Hitting Victims in High-Bandwidth 'Bursts'

From IT Pro - Microsoft Windows Information, Solutions, Tools

The volume of traffic harnessed by attackers has g...

T-SQL

Split strings the right way – or the next best way

From SQLPerformance

Aaron Bertrand (@AaronBertrand) explores some comm...

Tech News

Amazon asked FCC to reject Starlink plan because it can’t compete, SpaceX says

From Ars Technica

SpaceX: Amazon should fix Kuiper satellite plan in...

‘Forever Changed’: CEOs Are Dooming Business Travel — Maybe for Good

From IT Pro - Microsoft Windows Information, Solutions, Tools

Businesses around the world are signaling that i...

New script makes it easy(ish) to put Windows 10 or 11 on a Raspberry Pi

From Ars Technica

A relatively cheap, simple way to give the ARM ver...

NASA’s Perseverance rover finally scooped up a piece of Mars

From Technology Review Feed - Tech Review Top Stories

NASA’s Perseverance rover has successfully gathered a bit of rock and soil from Mars, which marks the first time a sample has ever been recovered on the planet. What...

The FAA grounds Virgin Galactic’s spaceship after flight deviation

From Ars Technica

"The most misleading statement today was Virgin Ga...

Edge Data Centers Gaining in Popularity

From IT Pro - Microsoft Windows Information, Solutions, Tools

In an era defined by a growing need for super-fast...

Rocket Report: Alpha launches and then blows up, ULA to stop selling Atlas V

From Ars Technica

"We're done. They're all sold."

Virtualization and Containers/Kubernetes

Azure SQL VM: Using PerfInsights to Evaluate Resource Health and Troubleshoot (Ep. 5) | Data Exposed

From Azure SQL

It is important to ensure that your Azure Virtual ...

 
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

 

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