Lt. Uhura, Ways to Prevent Ransomware and More

Database Weekly for June 12, 2021 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 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -