| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Things We Are Missing I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication. Strictly on a personal level, I miss conferences. As much as I'm an introvert (and I actually am), I do enjoy meeting people. That is all, understandably, on hold. However, I'd like to step away from the personal. Like the author of the post above, I'm curious how we'll be able to tell what was lost due to the lack of in-person communications. Sure, Zoom meetings, Teams, etc., allow for communication, above and beyond Slack or email. However, study after study shows that these online meetings are less effective than direct, in-person communications. People don't learn as well remotely as they do in person. It has to do with distractions, the medium itself, and just how we, jumped up monkeys that we are, best communicate. In-person, is superior. We've just spent over a year with inferior communications within IT and development. I can't help but ask the same question as the other author. What did we miss? How will we spot what's missing? Have there been solutions, breakthroughs or bug fixes that have not been accomplished, but would have been? Are these simply delayed, or have we missed a few opportunities, permanently? What would the people who have been lost contributed? I'm sorry to say, all I have here are questions. I don't know the answer to any of those questions. Not at all. However, I do find thinking about it to be interesting. As the Covid crisis slowly begins to recede in the rearview mirror, I'm left wondering, is there a way to measure what's just not there? 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 |
A set of PowerShell automation script tasks for running database build and migrations tasks. This article describes the SQL code analysis task, which will check the syntax of the SQL code in your databases and your migration scripts for 'code smells'. |
This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment. |
The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher. |
AI/Machine Learning/Cognitive Services |
Click to learn more about author Marco Riva. In re... |
Administration of SQL Server |
Transparent Data Encryption (TDE) is one of the ea... |
Using SQL Server Replication with AlwaysOn Availab... |
Total: 1 Average: 5 Thanks to the diversity of cul... |
Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start... |
or: How I learned to stop worrying, and love all-caps domain names. I’m a complete beginner at Linux, so I should preface this post with the fact that these... |
CREATE OR ALTER PROCEDURE scheduler_px_worker__reportASBEGIN;WITH tasks AS (SELECT ot.scheduler_id, ot.session_id, ot.exec_context_idFROM sys.dm_os_tasks otJOIN sys.dm_exec_requests er ON ot.session_id = er.session_idAND ot.exec_context_id > 0)SELECT t.scheduler_id, os.parent_node_id, spid__exec_context_id = STRING_AGG(CONVERT(VARCHAR(4), t.session_id) ... |
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one. |
Azure Logic Apps can be used to automate steps lik... |
With SQL Saturdays being rebooted, and the SQLSatu... |
My blog post from February 1 explains that Redgate... |
Computing in the Cloud (Azure, Google, AWS) |
Organizations are reaping the benefits of taking a... |
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a fairly simple construct, but I... The... |
Click to learn more about author Steve Leeper. Tod... |
Database Design, Theory and Development |
Click here to learn more about Victor Dudemaine. A... |
Organizations have many choices when it comes to d... |
This month the #TSQL2SDAY invitation comes from St... |
Performance Tuning SQL Server |
Itzik Ben-Gan continues collaborating with readers... |
Introduction The Inserted Scan operator is only found in execution plans for code in triggers. It is used for queries that read data from the inserted pseudo-table. Its counterpart,... |
PowerPivot/PowerQuery/PowerBI |
Is it better to build a model as a regular star sc... |
SQL Server Security and Auditing |
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles. |
Name:Wreck flaws in TCP/IP have global implication... |
Amongst the 100+ vulnerabilities patch in this mon... |
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala. |
Fans of the Uncharted game series might recognize ... |
The spinoff will unwind, at least in part, a consolidation created five years ago in Dell’s $67 billion acquisition of VMware’s parent, EMC Corp. |
"For us, it’s super important to have a launchpa... |
Virtualization and Containers/Kubernetes |
Another one of the most popular development tools ... |
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. |
|
|