| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Friendship and Your Career PASS Data Community Summit is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up because I've been incredibly lucky in the friendships I built with people I met at Summit. I want to take a moment to talk about the importance of friendship in your career. On one level, you could say that we're all in competition for the same jobs. It's not something I believe, but there are those who do. Then, there's another idea. While, sure, there's a little competition locally, maybe a fight for a promotion or a cool project, there is way more work out there than those of us who are even remotely qualified can handle. What's more, with this constantly shifting technology landscape, even if today we're qualified, tomorrow we might not be. So, we're not in competition. In fact, the very best thing we can do for ourselves and our careers, and I'm talking pure selfishness here, is to make a few friends in the industry. Why? Because you can't learn it all. You can't. However, having a bunch of friends who also work in the industry, you've got resources for the stuff you don't know. Sure, you can post questions on the forums (I regularly haunt them, trying to help out) and you'll probably get an answer. Maybe use the #sqlhelp or #pghelp hashtags on Twitter to get a quick answer. But, a friend can give you an answer even quicker. Plus, be around for follow-up questions. Heck, even more important, they can be a shoulder to cry on, a mentor, a sounding board for ideas, all these things. Further, you can help them with all of the same. That's what friends do. As I say, I've made some incredible friendships through my years of involvement at the PASS Data Community Summit. I've also made a few at SQLSaturday, Techorama, DataMinds Connect, SQL Bits, and other events, all around the world. If you can't make it to Summit, make it to another event, even a local meetup. While there, talk to people (yeah, I know). Make some friends in this industry. It'll be good for you. It'll be good for them. It'll be good for all of us. I truly believe a rising tide lifts all boats. The more we connect with one another and share, the better off we all are. 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 |
AI/Machine Learning/Cognitive Services |
Machine learning could help develop new types of m... |
Margaret Mitchell had been working at Google for two years before she realized she needed a break. “I started having regular breakdowns,” says Mitchell, who founded and co-led the... |
Administration of SQL Server |
Learn how to use the PowerShell Invoke-SqlAssessme... |
Part of the SQL Server 2022 blog series. Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence,... |
Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs The post SQL Server Registered Servers appeared first on DallasDBAs.com. The post SQL Server Registered Servers appeared... |
Azure Databricks, Spark and Snowflake |
In this article, we look at running DDL and DML st... |
Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this... The... |
Issue: When trying to generate a snapshot, the job is failing with the error: Error 1- "The connection is broken and recovery is not possible. The connection is marked by the... |
The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM.... |
Azure SQL Managed Instance |
Today, I worked on a service request where our cus... |
Redgate started a new marketing thing and I like i... |
Anyone who has attended Summit will recount tales ... |
Connect with other members of the Azure Data Community on LinkedIn group. Share how you got started speaking by joining the effort, #NewStarNovember The organizers of New Stars of Data want... |
Computing in the Cloud (Azure, Google, AWS) |
In this article, we look at how to migrate a SQL S... |
Last week, we announced plans to launch the AWS As... |
Learn how to quickly deploy a SQL Server on Linux (standalone) on Ubuntu (Linux) using AWS Launch Wizard. |
Companies plan to increase their spending on cloud infrastructure but may be slowing down on taking a “cloud-first” approach. These are two of the conclusions outlined in the Enterprise... |
Amazon, Microsoft, and Google all reported quarterly cloud earnings, emphasizing the ability of the cloud to reduce operating costs. |
Conferences, Classes, Events, and Webinars |
We're only we couple of weeks away until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE Register now |
Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now. |
There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE. Register now. |
The PowerShell Foreach statement is useful when wo... |
Data Mining / Data Analysis |
Business users are business professionals who have... |
Liv Boeree answers our questions about the game of... |
Question: This neuroscientist and SAS Explore host is known for appearing on "Blossom," "The Big Bang Theory" and "Jeopardy." Answer: Who is Mayim Bialik, Ph.D.? Today, instead of Bialik... |
Data Privacy, Compliance, and Governance |
Data intelligence and governance is at the heart o... |
In the past, designing and developing a robust data warehouse that satisfied the need for timely and effective business intelligence (BI) was an overwhelmingly difficult task, as it required significant time,... |
Database Design, Theory and Development |
Note: In "Setting Matters Straight" posts I debunk... |
You’ve done all the work to build confidence in ... |
The security risks of low-code/no-code are real an... |
DevOps and Continuous Delivery (CI/CD) |
According to Gartner, a whopping 47% of machine l... |
Here are practical ways to improve cloud-native ap... |
Whatever development methodology you use, it is us... |
Developers will be able to scan for vulnerabilitie... |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
Amazon Neptune is a fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets. With Neptune, you can use... |
Maker Ricardo has built a custom synthesizer using... |
A tiny Compute Module 4 carrier board has emerged,... |
An enthusiast with the handle @mryeester found tha... |
There seems to be some misunderstanding about the ... |
Biren's first GPUs can challenge Nvidia's A100 GPU... |
A survey by Theta Lake found that unmonitored comm... |
We compare FreeSync versus G-Sync to find out whet... |
Oracle/PostgreSQL/MySQL/other RDBMS |
In this article, we will learn how to use the feat... |
In this article, we will learn how to work with pr... |
Read replicas are used to offload read workloads a... |
The previous instalment of this series examined ag... |
Performance Tuning SQL Server |
SQL Server Query Plans Going Further If this i... |
Azure Data Studio has introduced query plan viewer functionality within the core application – you no longer need to install an extension to view and analyze plans. In this... |
In this article, we will walk through the steps of taking a very large SQL Server table and converting it to a partitioned view to help improve management and... |
PowerPivot/PowerQuery/PowerBI |
A common question is why Power BI totals are inacc... |
A common question is why Power BI totals are inacc... |
Learn about an up and coming external tool that ma... |
Regardless of the job function, you have with Powe... |
Most struggle with getting Q&A to be effective... |
Where to deploy your Power BI Report? My Workspace? Regular Workspace? What about Apps? Adam breaks it down to help you make the right choice and understand why it... |
Product Upgrades and Releases |
Microsoft has announced a public preview of the Un... |
The following images (from FreeCell) illustrate a ... |
I spend a lot of time in the forums on various web... |
Neil Saunders has some trail cameras: The camera m... |
A more secure organization starts with stronger al... |
Ursnif, a one-time banking Trojan also known as Go... |
As more of the software stack consists of third-pa... |
When we think about cybercrime and retail it is na... |
The autonomous SOC will never be a reality because technology is simply not capable of human ingenuity. |
Presently sponsored by: Varonis. Reduce your SaaS ... |
There are no details yet, but it’s really important that you patch Open SSL 3.x when the new version comes out on Tuesday. How bad is “Critical”? According to OpenSSL,... |
Microsoft's 'Project Volterra' $599 device for dev... |
T-SQL and Query Languages |
Data can be inserted into one temp table from anot... |
Some people have shower thoughts, I have 1am thoug... |
GENERATE_SERIES function is introduced in SQ... |
In this article, we look at how to use SQL LIKE statement to find various text patterns contained within a set of text along with many different examples of... |
The US Navy is working on ways to build, deploy, a... |
I spoke with Greg Douglass, Global Lead, Technolog... |
Everything dies: people, machines, civilizations. ... |
This team uses a Raspberry Pi to power a custom de... |
IT departments have been performing heroically since the pandemic, but even more could have been done if IT decision-makers had better support, a new report finds. |
Now more than ever, business success relies on an agile cyber asset management strategy. Over the past year, inflation, supply chain delays, cybercrime, transitions to remote work, and the... |
This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. Would you eat lab-grown meat? Plenty... |
A little over 15 years ago, scientists at Kyoto Un... |
Tornadoes form in 10 seconds or less. So Howie Blu... |
When you think of rum, what comes to mind? A straw... |
Tools for Dev (SSMS, ADS, VS, etc.) |
Symptom: When using Performance Dashboard on Azu... |
Virtualization and Containers/Kubernetes |
Today I’m pleased to announce AWS Batch for Amaz... |
The mission to run any containerized application o... |
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. |
|
|