Building a Better Community (DBW 2021-01-02)

 Database Weekly for January 3, 2021 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 Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -