| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Virtual Events Are Here To Stay This week was the MVP Summit. As was the case for the last couple of years, the event was entirely virtual. We were shown a bunch of new and interesting things by Microsoft. We were able to talk to each other and to the engineers at Microsoft. I'm honored that I've been an MVP and able to take part in this (fingers crossed, I make the cut again this year) and I'm really appreciative to Microsoft for putting the event together. However... It was missing a lot of the things that you get with an in-person event. The hallway conversations, hugs, chances to compare notes and prepare discussion points, all that and more, are missing with a virtual event. However, again, it doesn't matter. Even as we go back to in-person events (like, for example, PASS Data Community Summit, taking place in Seattle, November 15-18, go here to register), we're going to continue to have all-virtual or partially virtual events (like PASS Summit). Why? Just as the lockdowns showed many organizations that they can do a lot of their work remotely, we've seen that virtual events open up the pool of those who can attend an event. Parents with young kids who couldn't travel, people with fewer means, contractors with deadlines, folks who are differently abled, and a million other reasons, kept people from attending in-person events. Yet, they can make all, or at least some, of a virtual event. It's this simple fact that's going to keep virtual events going, in whole or in part, into the future. Despite the fact that in-person is superior in a bunch of ways (it's hard to argue with millions of years of evolution and that impact on how humans communicate), we've opened the door to be more inclusive through virtual events. We're seeing events like PASS Summit and SQLBits embrace this new approach. They are beginning the process of making this a more interconnected world. Hybrid events are becoming the new normal, and that's a great thing. 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 |
My FlywayTeamwork PowerShell framework is designed to help get you started quickly with developing databases, using Flyway versioned migrations. It introduces a PowerShell task library, and automation, to take care of repetitive chores. It will also help you get to grips with the practicalities of using Flyway in team-based development. This article explains the basics of its design and provides a demo how to use Flyway to migrate a PostgreSQL database, while generating a high-level narrative of the changes made between versions. |
How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files. |
Administration of SQL Server |
Database Backup & Restore capabilities are cru... |
The client interface for SQLCMD = ODBC |
Introduction As part of our efforts to improve database engine supportability, we have added a new dynamic management view (DMV), sys.dm_os_out_of_memory_events. It is now available in Azure SQL Database and... |
With SQL Server 2012 End of Life approaching in July 2022, organizations need to consider options to keep SQL Server running smoothly for years to come. |
In this article we take a look at some of the features in SQL Server Management Studio that you can use to make you more productive when working with... |
Are you familiar with synonyms as they relate to SQL Server? I haven’t seen them used too much out in the wild but understand they can have benefits. Let’s... |
Not Love Or Hate I like Query Store, I do. I don�... |
A recent documentation update raises questions about the love-it-or-hate-it READ UNCOMMITTED isolation level. |
To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY. |
This article explains SQL Server Dedicated Adminis... |
Azure SQL Managed Instance |
This how-to post focuses on how-to restore across ... |
Your data is under attack more than ever before. The onslaught of cyber attacks around the world is unrelenting, and organizations of all sizes have found themselves on the... |
Career, Employment, and Certifications |
Almost five years ago, one of my local SQL Server community friends sent me a text message about an opening at Redgate, editor of Simple Talk. I applied for... |
PASS Data Community Summit 2022 registration is officially open! Now’s the time to get your pass for the world’s largest gathering of data platform professionals and take advantage of... |
Computing in the Cloud (Azure, Google, AWS) |
In 2018 I wrote about AWS Firewall Manager (Centra... |
Azure Data Explorer is a PaaS offering from Azure ... |
This blog post is about another use of KQL that wi... |
In the previous blog post we created an Azure Data... |
Cloud native is of one of those terms that caught the wave of tech press hype. The term is so hot right now that some companies are “cloud native... |
This article will help you understand the Azure storage options available in the Microsoft Azure cloud. Microsoft Azure provides various services to store data depending on their type, nature,... |
Conferences, Classes, Events, and Webinars |
Now’s the time to save your seat at the world’s largest hybrid conference for data platform professionals, taking place November 15-18! Join attendees from around the globe who are gathering in-person and online for a full week of world-class training, networking, and data-platform focused events. Register today to take advantage of discounted launch pricing, available for a limited time. |
Data masking is defined as replacing sensitive data with a realistic fictional equivalent. But do you know there are 2 key types of Data masking, and what each offer? Join SQLServerCentral Editor, Steve Jones, in this 30-minute webinar to find out more. |
As part of my journey to get better at Powershell,... |
The Azure SQL Migration extension for Azure Data Studio provides a seamless and robust migration experience to help you migrate your SQL Server databases to Azure. However, if you... |
Leverage Azure PowerShell module (Az.DataMigration... |
Data Mining / Data Analysis |
In an article about how to visualize missing data ... |
Database Design, Theory and Development |
In the digital age, the success, growth, and maximization of opportunities of an organization depend on insights gained from data. Analytics and business intelligence (ABI) tools enable organizations to... |
Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data. |
DevOps and Continuous Delivery (CI/CD) |
What’s the difference between Site Reliability E... |
GitOps can help DevOps teams automate development and deployment workflows. Here are GitOps best practices to help ensure success. |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
How to parse information from URL in Hive? Hive of... |
In this article we look at some approaches to model a document database schema and how to effectively store and access the data. |
Oracle/PostgreSQL/MySQL/other RDBMS |
Views in MySQL allow you to save a predefined SQL query. Robert Sheldon explains the benefits of views and how to create and query them. |
Performance Tuning SQL Server |
Paul White continues his series on simple paramete... |
PowerPivot/PowerQuery/PowerBI |
Working with more data than you can use in Power B... |
Want a custom message or title in your Power BI re... |
To tune down the madness of March 2022, Microsoft’s offerings... |
Over the last two years, the Future of Work has be... |
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading |
Among them is the operator of the Ghostwriter misinformation campaign, with a new browser-in-browser phishing technique, according to Google's research team. |
Ransomware is a major threat, and no business is "too small to target." So what should you do after an attack? Is negotiating with criminals ever the answer? |
Public policy proposals must consider technical, practical, and real-world security effects, and make sure we avoid unintended consequences. |
In this video, Omdia's Roy Illsley examines how fi... |
Testing and quality assurance play a significant role in preventing problems from being introduced into production environments. This article explains how testing and QA work, as well as why... |
Virtualization and Containers/Kubernetes |
Developers are increasingly using containers for building and deploying applications, but how do you make sure they are safe and properly tested for performance? Here are five best practices. |
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. |
|
|