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
 

Virtual Events Are Here To Stay

This week was the MVP Summit. As was the case for the last couple of years, the event was entirely virtual. We were shown a bunch of new and interesting things by Microsoft. We were able to talk to each other and to the engineers at Microsoft. I'm honored that I've been an MVP and able to take part in this (fingers crossed, I make the cut again this year) and I'm really appreciative to Microsoft for putting the event together.

However...

It was missing a lot of the things that you get with an in-person event. The hallway conversations, hugs, chances to compare notes and prepare discussion points, all that and more, are missing with a virtual event.

However, again, it doesn't matter. Even as we go back to in-person events (like, for example, PASS Data Community Summit, taking place in Seattle,  November 15-18, go here to register), we're going to continue to have all-virtual or partially virtual events (like PASS Summit).

Why?

Just as the lockdowns showed many organizations that they can do a lot of their work remotely, we've seen that virtual events open up the pool of those who can attend an event. Parents with young kids who couldn't travel, people with fewer means, contractors with deadlines, folks who are differently abled, and a million other reasons, kept people from attending in-person events. Yet, they can make all, or at least some, of a virtual event. It's this simple fact that's going to keep virtual events going, in whole or in part, into the future. Despite the fact that in-person is superior in a bunch of ways (it's hard to argue with millions of years of evolution and that impact on how humans communicate), we've opened the door to be more inclusive through virtual events.

We're seeing events like PASS Summit and SQLBits embrace this new approach. They are beginning the process of making this a more interconnected world. Hybrid events are becoming the new normal, and that's a great thing.

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

What is the Flyway Teamwork Framework?

My FlywayTeamwork PowerShell framework is designed to help get you started quickly with developing databases, using Flyway versioned migrations. It introduces a PowerShell task library, and automation, to take care of repetitive chores. It will also help you get to grips with the practicalities of using Flyway in team-based development. This article explains the basics of its design and provides a demo how to use Flyway to migrate a PostgreSQL database, while generating a high-level narrative of the changes made between versions.

Creating Flyway Migration Files using Redgate Schema Comparison Tools

How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files.

Administration of SQL Server

Monitor Database Restore progress at more granular level

From Azure SQL

Database Backup & Restore capabilities are cru...

SQLCMD uses OLEDB as a client interface

From SQLServer-DBA.Com

The client interface for SQLCMD = ODBC

A new way to troubleshoot out-of-memory errors in the database engine

From Azure SQL

Introduction As part of our efforts to improve database engine supportability, we have added a new dynamic management view (DMV), sys.dm_os_out_of_memory_events. It is now available in Azure SQL Database and...

Keep SQL Server Running Smoothly with SQL Server 2012 End of Life in July 2022

From MSSQL Tips

With SQL Server 2012 End of Life approaching in July 2022, organizations need to consider options to keep SQL Server running smoothly for years to come.

SQL Server Management Studio Top 10 Productivity Tips and Hidden Secrets

From MSSQL Tips

In this article we take a look at some of the features in SQL Server Management Studio that you can use to make you more productive when working with...

Synonyms in SQL Server

From Callihan Data

Are you familiar with synonyms as they relate to SQL Server? I haven’t seen them used too much out in the wild but understand they can have benefits. Let’s...

Query Store Improvements I’d Like To See

From Erik Darling Data

Not Love Or Hate I like Query Store, I do. I don�...

All you NOLOCK lovers better read this!

From SQLBlog.org

A recent documentation update raises questions about the love-it-or-hate-it READ UNCOMMITTED isolation level.

Ordering a result set in SQL Server

To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.

Azure SQL

SQL Server Dedicated Administrator Connections for Azure SQL Database

From SQLShack

This article explains SQL Server Dedicated Adminis...

Azure SQL Managed Instance

How-to restore across different SQL Managed instances when using TDE with Customer Managed Keys

From Azure SQL

This how-to post focuses on how-to restore across ...

Backup and Recovery

Move Over, Backup: It’s Time to Talk Data Resiliency

From Dataversity

Your data is under attack more than ever before. The onslaught of cyber attacks around the world is unrelenting, and organizations of all sizes have found themselves on the...

Career, Employment, and Certifications

Wanted: Simple Talk Editor

From Simple Talk

Almost five years ago, one of my local SQL Server community friends sent me a text message about an opening at Redgate, editor of Simple Talk. I applied for...

Community Interests

Get your pass for this year’s hybrid Data Community Summit

From Blog – Redgate Software

PASS Data Community Summit 2022 registration is officially open! Now’s the time to get your pass for the world’s largest gathering of data platform professionals and take advantage of...

Computing in the Cloud (Azure, Google, AWS)

New – Cloud NGFW for AWS

From AWS News Blog

In 2018 I wrote about AWS Firewall Manager (Centra...

KQL Series – quick intro to Azure Data Explorer

From SQLServerCentral Blogs

Azure Data Explorer is a PaaS offering from Azure ...

KQL Series – KQL usage with Advanced Hunting (this is huge)

From SQLServerCentral Blogs

This blog post is about another use of KQL that wi...

KQL Series – create a database in our ADX cluster

From SQLServerCentral Blogs

In the previous blog post we created an Azure Data...

Why Cloud Native is the Second Cloud Revolution

From Past News - RSS Feeds

Cloud native is of one of those terms that caught the wave of tech press hype. The term is so hot right now that some companies are “cloud native...

Getting started with Azure Storage

From SQLShack

This article will help you understand the Azure storage options available in the Microsoft Azure cloud. Microsoft Azure provides various services to store data depending on their type, nature,...

Conferences, Classes, Events, and Webinars

Registration is now open for Summit 2022

Now’s the time to save your seat at the world’s largest hybrid conference for data platform professionals, taking place November 15-18! Join attendees from around the globe who are gathering in-person and online for a full week of world-class training, networking, and data-platform focused events. Register today to take advantage of discounted launch pricing, available for a limited time.

Why you need to go beyond dynamic data masking

Data masking is defined as replacing sensitive data with a realistic fictional equivalent. But do you know there are 2 key types of Data masking, and what each offer? Join SQLServerCentral Editor, Steve Jones, in this 30-minute webinar to find out more.

DMO/SMO/Powershell

I got the Power: Remote Execution using Powershell and SQL Server

From Eitan Blumin

As part of my journey to get better at Powershell,...

Migrate SQL Server databases at scale to Azure using PowerShell / CLI

From Azure SQL

The Azure SQL Migration extension for Azure Data Studio provides a seamless and robust migration experience to help you migrate your SQL Server databases to Azure. However, if you...

Public preview: Azure SQL Migration extension with Azure PowerShell and CLI support

From Azure Updates

Leverage Azure PowerShell module (Az.DataMigration...

Data Mining / Data Analysis

Change the missing-value color by using a range attribute map

From AllAnalytics

In an article about how to visualize missing data ...

Database Design, Theory and Development

5 Best Practices to Reap the Benefits of Data Democratization

From Dataversity

In the digital age, the success, growth, and maximization of opportunities of an organization depend on insights gained from data. Analytics and business intelligence (ABI) tools enable organizations to...

The problem with averages

Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.

DevOps and Continuous Delivery (CI/CD)

Site Reliability Engineering vs. DevOps

From Simple Talk

What’s the difference between Site Reliability E...

4 GitOps Best Practices for DevOps Teams

From IT Pro - Microsoft Windows Information, Solutions, Tools

GitOps can help DevOps teams automate development and deployment workflows. Here are GitOps best practices to help ensure success.

DocumentDB/Key-Value/Graph/other NoSQL Databases

How to parse information from URL in Hive?

From Hadoop in the Real World

How to parse information from URL in Hive? Hive of...

Approaches to Model a Document Database Schema

From MSSQL Tips

In this article we look at some approaches to model a document database schema and how to effectively store and access the data.

Oracle/PostgreSQL/MySQL/other RDBMS

Working with MySQL Views

Views in MySQL allow you to save a predefined SQL query. Robert Sheldon explains the benefits of views and how to create and query them.

Performance Tuning SQL Server

Simple Parameterization and Trivial Plans — Part 2

From SQLPerformance

Paul White continues his series on simple paramete...

PowerPivot/PowerQuery/PowerBI

Try limiting rows when creating reporting for big data in Power BI

From Guy in a Cube

Working with more data than you can use in Power B...

Use this Power BI feature to display custom message or titles

From Guy in a Cube

Want a custom message or title in your Power BI re...

Everything you need to know about Power Platform – March 2022

From Petri IT Knowledgebase

To tune down the madness of March 2022, Microsoft’s offerings...

Professional Development

The Future of Work is here – and it's hybrid.

From AllAnalytics

Over the last two years, the Future of Work has be...

Talk to the duck.

From SQLStudies

Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading

Security News and Issues

Nation-State Hackers Ramp Up Ukraine War-Themed Attacks

From Dark Reading: Dark Reading News Analysis

Among them is the operator of the Ghostwriter misinformation campaign, with a new browser-in-browser phishing technique, according to Google's research team.

Ransomware: Should Companies Ever Pay Up?

From Dark Reading: Dark Reading News Analysis

Ransomware is a major threat, and no business is "too small to target." So what should you do after an attack? Is negotiating with criminals ever the answer?

More Than Ever, Security Matters

From Dark Reading: Dark Reading News Analysis

Public policy proposals must consider technical, practical, and real-world security effects, and make sure we avoid unintended consequences.

Tech News

2022 IT Operations Trends: Will IT See a Role Change?

From IT Pro - Microsoft Windows Information, Solutions, Tools

In this video, Omdia's Roy Illsley examines how fi...

Testing Software

What Are Software Testing and Quality Assurance?

From IT Pro - Microsoft Windows Information, Solutions, Tools

Testing and quality assurance play a significant role in preventing problems from being introduced into production environments. This article explains how testing and QA work, as well as why...

Virtualization and Containers/Kubernetes

How to Optimize Application Container Testing

From IT Pro - Microsoft Windows Information, Solutions, Tools

Developers are increasingly using containers for building and deploying applications, but how do you make sure they are safe and properly tested for performance? Here are five best practices.

 
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

 

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