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
 

Define All The Steps Up Front

After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined the process, on either side, all the way through.

See, we keep finding out there's one more thing to do. "What do you mean you don't have a Title 5 inspection of your septic system? You have to have a Title 5 inspection before you can sell." On and on like that. One thing after another that we didn't hear about up front so we could easily take care of it. Instead, it's always a scramble to arrange for one more person to swing by one of the houses to do something.

How well are your own processes defined? Just how many flaming hoops do you make your developers hop through before they can deploy code changes to production? How many hidden little gotchas do you know about in your systems and their processes but no one else has a clue? Frankly, IT is hard. From the start of developing anything, to maintenance on old, well established systems, the full spectrum of IT is difficult. As much as humanly possible, document that stuff. Make things as clear as possible. Communicate to all your peers everything that they need to know. All sorts of hidden processes, secret tricks, and anything that adds to the difficult of IT should absolutely be eliminated.

All the things we do in IT are hard enough on their own. Don't add to the difficulty by hiding stuff.

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

3 ways MSPs can offer more value

In the Global State of the MSP Report from Datto, cloud and cybersecurity were identified as two key areas for growth. In this blog we cover three wants Managed Service Providers can offer more value in this areas.

Managing, Editing and Comparing SQL Code Analysis Settings

If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed.

Using Data Scanning to Identify and Classify Sensitive Columns

SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.

.NET Related Articles

.NET Community: Where and how can we find help

From Simple Talk

I was developing some personal .NET projects when ...

AI/Machine Learning/Cognitive Services

Getting the green light for a machine learning project

From AllAnalytics

How do you convince decision makers in your enterprise to give a machine learning (ML) project the green light? You might be super excited about machine learning – as...

Using AI and Data Analytics to Monetize Data: 4 Techniques

From Past News - RSS Feeds

The economic value of data for companies is challe...

Disability rights advocates are worried about discrimination in AI hiring tools

From Technology Review Feed - Tech Review Top Stories

Your ability to land your next job could depend on...

Administration of SQL Server

How To Use Powershell to Configure Multiple Databases for Log Shipping

Bulk operations to set up log shipping

Are you wasting half the capacity of IDENTITY?

From Steve Stedman

When creating a table you can specify IDENTITY wit...

Filtering Extended Events Using Actions

From Grant Fritchey

Did you know, you can use Actions to Filter Extend...

How to Change Server Level Collation of Running SQL Server Instance

From SQL Server – {coding}Sight

In my previous article I have explained the basics...

Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.

From SQLStudies

Hypothesis: If I have Dynamic Data Masking enabled...

Collecting SQL Server performance monitor data

From Simple Talk

SQL Server provides information for troubleshootin...

VARCHAR and NVARCHAR Data Types in SQL Server

From SQL Server – {coding}Sight

Relational databases represent an organization’s...

SQL Server System Databases Maintenance

From SQL Server – {coding}Sight

In the process of installing, SQL Server creates s...

Starting SQL: Basic Index Design Patterns

From Erik Darling Data

Starting SQL: Basic Index Design Patterns If you want to check out my more advanced training, follow this link to get 90% off.

SQL Server High Availability and Disaster Recovery Plan

Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.

Azure DevOps

Using Azure Test Plans for Data Platform deployments

From Kevin Chant

Reading Time: 7 minutes In this post I want to co...

Azure Synapse (SQL Data Warehouse and Data Lake)

How to query private blob storage with SQL and Azure Synapse

From Simple Talk

Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.… The post How to query private blob...

Community Interests

Top Reasons to Attend Data Community Summit 2020

There are lots of reasons to attend the PASS Data Community Summit 2020. Itzik Ben Gan lays out several of them for you in this new video.

SQLSaturday Orlando 2021

From SQLServerCentral Blogs

We’ve opened up registration and the call for sp...

Computing in the Cloud (Azure, Google, AWS)

Contrary View: Cloud Computing Can ‘at Least Double’ Infrastructure Bill

From IT Pro - Microsoft Windows Information, Solutions, Tools

Two Andreessen Horowitz analysts take on the indus...

Conferences, Classes, Events, and Webinars

Getting more control over database deployments with Flyway

Join Flyway expert Carlos Robles in this session to explore and discuss the new features of Flyway v7 which make it one of best database version control and migration tools in the market.

The role of Automation in your DevOps driven Digital Transformation

Discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck.

DMO/SMO/Powershell

Fun With PowerShell String Formatting

From Arcane Code

Introduction In last Monday’s blog post, Fun Wit...

Data Mining / Data Analysis

Understanding your data: A series on the importance of Exploratory Data Analysis

From AllAnalytics

Following on from my introductory blog series, Dat...

Ways to Contrast Data

From Sherpa of Data

As you have probably determined, with blog posts l...

DevOps and Continuous Delivery (CI/CD)

IntegrationOps: The Final Frontier of IT Democratization

From Dataversity

Click to learn more about author Romi Stein. We now know the story of how, over the past decade, the CIO role has transformed to be that of a...

Reimagining Workflow with Intelligent Automation

From IT Pro - Microsoft Windows Information, Solutions, Tools

Transforming your business with intelligent automa...

How to encourage DBAs to embrace DevOps, rather than fear change

From Blog – Redgate Software

How do we help Database Administrators (DBAs) embrace DevOps in a way that can be really productive and part of a rich DevOps team that delivers value to customers...

ETL/SSIS/Azure Data Factory/Biml

SSIS Catalog Browser v0.9.9.0 is Available

From AndyLeonard.blog()

I am excited to announce the latest release of SSI...

Oracle

Typical uses of Oracle sequences

Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical uses of Oracle sequences.

Performance Tuning SQL Server

Tread Carefully With Index Hints

A cautionary tail about the use of index hints.

PowerPivot/PowerQuery/PowerBI

A Developer’s Guide to Creating Bad Power BI Projects – Part 1

From Paul Turley's SQL Server BI Blog

It occurred to me that we have put so much effort ...

Professional Development

Your Work Email Address is Your Work's Email Address

From Troy Hunt's Blog

Presently sponsored by: Guarantee peace of mind from credential stuffing attacks. Learn how at Arkose Labs’ webinar with Troy July 27 at 10 am PT. Save your seat! When the...

Channeling the Chaos of COVID-19 into Building More Agile Organizations

From Dataversity

Click to learn more about author Steele Arbeeny. If the COVID-19 pandemic taught us anything, it’s that you can never be too prepared for change – fast-moving, come-out-of-nowhere change that transforms...

Python

Winning At Pong via Reinforcement Learning

A little Python and some learning code

R Language

Create a Data Analysis Pipeline with Apache Kafka and RStudio

 

Intro to R with Power BI

From Guy in a Cube

You enjoyed the intro to Python video, now let's l...

Reporting Services

Using your own RDL as a SSRS Template

From Steve Stedman

This is very useful if you are creating many repor...

Security News and Issues

Nasty Printer Driver Vulnerability

From Schneier on Security

From SentinelLabs, a critical vulnerability in HP printer drivers: Researchers have released technical details on a high-severity privilege-escalation flaw in HP printer drivers (also used by Samsung and Xerox), which...

Saudi Aramco confirms data leak after $50 million cyber ransom demand

From Ars Technica

World’s largest oil producer says some company files were compromised.

Moving Your Organization's SecOps Beyond the Pandemic

From IT Pro - Microsoft Windows Information, Solutions, Tools

Enterprise security teams have had a rough year. W...

Insurers Are Rethinking How They Cover Hacks With Cyberattacks on the Rise

From IT Pro - Microsoft Windows Information, Solutions, Tools

Wrestling with higher costs and more risk, insurer...

Two-for-Tuesday vulnerabilities send Windows and Linux users scrambling

From Ars Technica

Both OSes have flaws that allow attackers with a t...

Biden to Convene Private Sector Leaders on Cybersecurity Threats

From IT Pro - Microsoft Windows Information, Solutions, Tools

The August 25 meeting will convene industry leaders late next month to discuss strategies for confronting the growing threat of cyberattacks.

Home and office routers come under attack by China state hackers, France warns

From Ars Technica

Compromised routers give the hackers anonymity in ongoing large-scale attacks.

Software Development

Benefits of Digital Transformation: 5 Tools for Software Development

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's how software developers have come to reap some of the benefits of digital transformation.

Communal Computing’s Many Problems

From O'Reilly Radar - Insight

In the first article of this series, we discussed ...

4 Software Programming Challenges for Today’s Developers

From IT Pro - Microsoft Windows Information, Solutions, Tools

Despite advances in tools, platforms and languages...

Audacity’s new owner is in another fight with the open source community

From Ars Technica

Muse Group's intentions appear to be good—but th...

T-SQL

THROW Statement Usage

From Callihan Data

When it comes to error handling or troubleshooting a long stored procedure, RAISERROR is an easy statement to use that gets the job done. Way back in SQL Server...

TSQL Basics Part 18: TWO INNER JOINS

From Steve Stedman

This is part 18 of a 19 part series on TSQL Basics...

Using Aggregates in Calculations with Other Columns Functions–#SQLNewBlogger

From SQLServerCentral Blogs

Another post for me that is simple and hopefully s...

SQL Server ROUND() Function: What It’s For and Why Should You Care?

From SQL Server – {coding}Sight

SQL is a programming language used to create, read, update, and delete databases. It has one of the most popular functions for rounding numbers, which can be very useful...

Tech News

Judges reject Viasat’s plea to stop SpaceX Starlink satellite launches

From Ars Technica

Viasat fears SpaceX competition, sought freeze on launches and environmental review.

Genealogists say Leonardo da Vinci has 14 living relatives

From Ars Technica

The Renaissance artist and scientist's youngest li...

Cities are scrambling to prevent flooding

From Technology Review Feed - Tech Review Top Stories

US cities are working to shore up their flood defe...

Blue Origin takes its first passengers to space

From Technology Review Feed - Tech Review Top Stories

This time, there was a blastoff.   Blue Origin f...

Lyft ditches Google Maps for Here, partners with Argo AI

From Ars Technica

Argo and Ford will deploy driverless cars on Lyft'...

Event Horizon Telescope captures birth of black hole jet in Centaurus A

From Ars Technica

Images narrow down possible theoretical explanations for how black hole jets form.

Despite Tuesday’s flight, Jeff Bezos is running out of time to save Blue Origin

From Ars Technica

“What we know about Jeff Bezos is that he doesn?...

Virtualization and Containers/Kubernetes

Don’t Do This With Your VM, Physical or NAS Backups: Worst Practices Gallery

From IT Pro - Microsoft Windows Information, Solutions, Tools

Date: Tuesday, August 24, 2021 Time: 02:00 PM Ea...

Intro to AKS – Azure Kubernetes Service

From SQLServerCentral Blogs

What is Azure Kubernetes Service? Probably makes s...

 
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

 

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