Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
Editorial
 

Building a Better Community

The demise of the PASS organization is just a few weeks away, and if you want to watch or save any content, be sure you get moving. The sites go dark on 15 Jan 2021, so time is short. I found I could right click and save a number of the PASS Pro videos, as I'd like to see what content was produced by some of my friends and fellow community members.

As we look forward, I am hopeful and excited that the community will continue to come together and find ways to grow and share with each other. Already DataSaturdays are up and events coming. Even if my bid for SQLSaturday.com falls short, I'm not remotely worried. We will continue to grow and run events that help the SQLFamily share, grow, and bond. The excitement and growth of the community across the last two decades was facilitated by PASS, but I think it's really the people in the community that have done the work of building an amazing movement, especially around SQL Saturday.

I saw this past week a number of posts that look to the future. I liked Brent's question of what you might want in a community. Most of the respondents note that content is the number one goal, which I agree with. When Andy, Brian, and I started SQL Saturday, we did so with the idea that many people don't have the time or resources to go to the Summit (or SQL Bits, SQL Intersection, etc.). We wanted to provide a way that most people could get the conference experience and get inspired and excited. It worked better than we ever imagined, and I'm confident that many people will find ways to do so in the future. Already, with events like GroupBy, New Stars of Data, Data Relay and DataGrillen, there is plenty of enthusiasm in the community.

We are having discussions about how to replicate some of the success with Data Saturdays already. There is guidance for speakers and user groups. If you are a part of any of those, ensure that you are preparing for things to change in a few weeks. Look to the future, and find a way to help your community grow in 2021.

Steve Jones - SSC Editor

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.
AI/Machine Learning/Cognitive Services

Why AI is so power-hungry

It takes a lot of energy for machines to be traine...

You can’t unsee Tedlexa, the Internet of Things/AI bear of your nightmares

From the archives: Teddy Ruxpin + Arduino + Raspberry Pi + Alexa = What could go wrong?

Administration

Time to Set Service Dependencies for SQL Server, it’s Easy

In this article, I share one easy script that coul...

Fundamentals of Managing Datafiles in SQL Server

Total: 1 Average: 5Introduction Datafiles are phys...

TSQL Query to find the user the SQL services run as

Occasionally I need to look up what user the SQL S...

Easy Monitoring: Application Timeouts in SQL Server with XEvents

Application timeouts can be surprising little prob...

Storage savings with Table Compression

 

Simple Method to Add A Network in SQL Configuration Manager

In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server. The post Simple Method to Add A... The...

Install and Configure SQL Server 2019 on Windows Server 2016

Total: 1 Average: 5 SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5. To learn about the new features presented in...

Here is an Easy Fix for SQL Service Startup Issues When Using an MSA

Running into startup issues with your services could be a nightmare on some days. Couple those issues with an MSA and you may be balding before long. The post Here... The...

Analysis Services / BI on the MS Stack

Your Quick Introduction to Extended Events in Analysis Services

XEvents is a power tool in SQL Server. While it ma...

Azure Databricks, Spark and Snowflake

Advent of 2020, Day 31 – Azure Databricks documentation, learning materials and additional resources

Series of Azure Databricks posts: Dec 01: What is...

Advent of 2020, Day 28 – Infrastructure as Code and how to automate, script and deploy Azure Databricks with Powershell

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating...

Azure Synapse (SQL Data Warehouse and Data Lake)

Getting started with Spark Pools in Azure Synapse

In my latest video blog I discuss getting started on the newly Generally Available Spark Pools as a part of Azure Synapse, another great option for Data Engineering/Preparation, Data...

Career Growth and Certifications

Start-IncreasingPushback

Words: 498 Time to read: ~3 minutes Table of Conte...

Community Interests and PASS

Things that a User Group needs to do before PASS Goes Dark

If you are a SQL Saturday, User Group or Virtual G...

Should There Be A Successor to PASS?

PASS was a big influence on a lot of us and did a ...

As an Attendee, What’s Important to You In a New Data Community?

With PASS shutting down, it’s time to think about what the community builds in its place. There are a lot of efforts going towards building replacements for PASS, including...

Splitting up the Mission of PASS

Following up on Should There Be A Successor to PA...

FAQs about the dissolution of PASS

In my prior post, I talked about how all signs poi...

DMO/SMO/Powershell

Experiments With Go Arrays and Slices

Simplicity Over Syntactic Sugar As I’ve been lea...

Database Design, Theory and Development

Database Design and Guaranteed Correctness Part 2

Note: This is a re-write of an earlier post (which...

DevOps and Continuous Delivery (CI/CD)

Azure DevOps, Git, and SSIS

After a couple false starts, I was able to live-st...

Challenges to Database DevOps: Dealing With Drift

Sometimes, people start their DevOps journey by ge...

HA/DR/Always On/Clustering

Firewall Ports You Need to Open for Availability Groups

This article has demonstrated a meaningful and eff...

Performance Tuning SQL Server

Is It Time To Remove Costs From Query Plans?

Guest Star There’s a lot of confusion about wha...

An Empirical Look at Key Lookups

I’m going to presume you’re familiar with what...

PowerPivot/PowerQuery/PowerBI

DirectQuery for Power BI dataset: How does it work?

In my previous article and video, I explained why ...

Creating an HTML URL from a PowerShell String–#SQLNewBlogger

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

Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings

With the DirectQuery to Power BI or Azure analysis...

Inlining KQL Query Fragments Using Value.NativeQuery() In Power Query

If the title wasn’t enough to warn you, this post is only going to be of interest to M ultra-geeks and people using Power BI with Azure Data Explorer...

SQL Server Security and Auditing

How to Easily Grant Permissions to all Databases

This article demonstrates one method to grant READ...

Tech News

The biggest technology failures of 2020

This was a year we needed technology to save us. A...

 
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

 

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