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
 

Live On Stage AND On Your Screen

I've just finished up teaching at an in-person event, the first in fifteen months. It was the SQL Server and Azure SQL Conference (formerly known as SQLIntersection). The event organizers did a great job making it into a hybrid event, where  we presented both in-person and virtually, so that people could choose if they wanted to attend in-person or join online. I have to say, it worked better than I thought it would. It took a little adjustment to remember that there were two different audiences to speak to, but overall, a wonderful experience.

The most interesting aspect of the event were the discussions. Yeah, you could say that about almost any in-person event. However, a lot of the discussions we had were around how to make the virtual side of the events work even better for people. After all, we've spent decades fine tuning in-person events. Yet the virtual event, as a primary mechanism, is still developing. A lot has improved since the lockdowns started, but there's still more to learn.

I think the interesting thing about this is the easy assumption we all made. Yes, we're probably going to go back to some, or maybe even a lot, of in-person events. Yet, we're probably also going to have hybrid, or all-virtual events continuing into the future. There were just too many people who have benefited from this move to virtual events. We're not now going to cut them off. So a bunch of us talked about ways to improve the virtual experience and ways to make the experience more valuable to those people who are likely to stay virtual into the future. Honestly, I think it makes for an exciting time as we expand how we engage and interact with people more and more.

What do you think are ways that virtual events can improve?

And, don't forget, the PASS Data Community Summit call for speakers is open just a few more days. Also, register to attend this virtual event. We're hoping to make it a pretty special experience for all involved, maybe even using your idea.

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

How DevOps can enable the evolving insurance landscape

The insurance landscape is evolving, and customer demands are far from where they used to be, with some of the biggest changes happening in the last year. James Boother from COEO covers how database DevOps can enable the evolving insurance landscape.

Who is responsible for building tests?

When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, you'll pretty quickly come to the question: who is responsible for building tests?

Administration of SQL Server

SQL FLOAT: 3 Points that Will Help you to Avoid Weird Math Errors

From SQL Server – {coding}Sight

Total: 1 Average: 5 Have you ever thought that SQL...

Dynamic SQL Execution in SQL Server

From SQL Server – {coding}Sight

Total: 1 Average: 5 Dynamic SQL is a statement con...

Get a List of Tables That Are Compressed

From Steve Stedman

Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression enabled: Tested on SQL...

The Stored Procedure to Get the Instance Settings

From SQL Server – {coding}Sight

Total: 1 Average: 5 SQL Server instances house databases containing the data for the backend stack of a business model, or configuration data for particular applications. Regardless of the...

Using SQL Compare for One Procedure

From SQLServerCentral Blogs

A customer recently was concerned about the time to run SQL Compare for a large database. They were synching with the command line, but at times they want to... The...

Azure DevOps

T-SQL Tuesday 139 – Using Azure DevOps in a hybrid data world

From Kevin Chant

Reading Time: 4 minutes My T-SQL Tuesday contribu...

Azure SQL Database

Azure SQL Database – Cancel Scale Up Request

From SQLServerCentral Blogs

You have an Azure SQL Database, it could be a sing...

Azure SQL Database – Secondary Database and Tiers

From SQLServerCentral Blogs

On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe.... The...

Career Growth and Certifications

Ever feel like an imposter? Learn about confident humility with Adam Grant

From AllAnalytics

Organizational psychologist Adam Grant studies how...

Community Interests

Introducing the PASS Data Community Summit Program

From Blog – Redgate Software

Many of you know that Redgate purchased some of th...

Three Years at Microsoft

From DBAKevlar

Three years ago today, I walked into Microsoft HQ in Redmond, WA and started my journey with onboarding.  After a Tags:  Anniversary, Microsoft Del.icio.us Facebook TweetThis Digg ...

Computing in the Cloud (Azure, Google, AWS)

How Essential Are Azure Policies

From Simple Talk

Policies in Azure are like Wally. They are there, ...

Cloud Regions: How to Make the Smartest Choice

From IT Pro - Microsoft Windows Information, Solutions, Tools

When choosing from among different cloud regions, ...

Data Mining / Data Analysis

Your Office Data Should Work as Hard as Your Employees

From Dataversity

Click to learn more about author Zach Dunn. Before...

Clinical trials are better, faster, cheaper with big data

From Technology Review Feed - Tech Review Top Stories

Clinical trials have never been more in the public...

DevOps and Continuous Delivery (CI/CD)

Why DevOps isn’t a level playing field for financial services and insurance

From Blog – Redgate Software

Redgate recently published the 2021 State of Datab...

The DevSecOps Model: What You Need To Know

From IT Pro - Microsoft Windows Information, Solutions, Tools

This report explains what the DevSecOps model is, ...

How to Set up a CI/CD Pipeline

From IT Pro - Microsoft Windows Information, Solutions, Tools

These guidelines will help you put a pipeline toge...

Performance Tuning SQL Server

T-SQL Tuesday #139 – Execution plans in a hybrid world

From SQL Server Fast

Another month has passed. Another T-SQL Tuesday ar...

Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs

From SQLPerformance.com

Itzik resumes his series on table expression funda...

Query Store Hints

From Erin Stellato

Query Store Hints provide the ability to add a hint to a statement even if you do not have direct code access. The post Query Store Hints appeared first on...

A Silent Bug With Clustered Column Store Indexes And Computed Columns

From Erik Darling Data

Oh Boy This bug has been reported to the proper authorities, and this blog post is not to dunk on the Summer Intern responsible for column store indexes, but...

PowerPivot/PowerQuery/PowerBI

Do’s and Don’t with cascading slicers in Power BI

From Guy in a Cube

Trying to get your slicers to filter right in Powe...

Tracing your DAX queries in Power BI

From Guy in a Cube

Learn how you can trace your DAX queries when tryi...

Introduction to generic Power BI themes

From Simple Talk

Formatting Power BI visuals can be tedious. In thi...

Security News and Issues

How Can You Prevent Ransomware?

From Past News - RSS Feeds

Ransomware has been front page news for several we...

Three Best Practices to Neutralize Ransomware Attacks

From Dataversity

Click to learn more about author Ken Steinhardt. T...

Mystery malware steals 26M passwords from millions of PCs. Are you affected?

From Ars Technica

Massive trove can be used for ransomware, espionag...

T-SQL

CROSS vs OUTER APPLY

From SQLServerCentral Blogs

I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER ... Continue reading The post CROSS vs OUTER APPLY appeared...

Tech News

Woman in Motion tells story of how Star Trek’s Uhura changed NASA forever

From Ars Technica

"If they let me in the door, I will open it so wid...

What Is Fastly and Why a Slew of Websites Went Offline

From IT Pro - Microsoft Windows Information, Solutions, Tools

Fastly’s so-called “edge computing” model pu...

The next Venus missions will tell us about habitable worlds elsewhere

From Technology Review Feed - Tech Review Top Stories

When the DAVINCI+ and VERITAS missions to Venus we...

EA source code stolen by hacker claiming to sell it online

From Ars Technica

More organizations feel the pain as the ransomware scourge grows more pernicious.

 
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

 

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