| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Non-Stop Learning There was a recent discussion in the forums here at SQL Server Central regarding the difficulties presented by the constantly shifting technology landscape. The core question was, how on earth do you master stuff? Especially, how do you master things when they're both new and constantly changing? Honestly, you don't. I mean, you can, but it's likely to be a full time thing. Take Azure SQL Data Warehouse, uh, I mean, Azure Synapse. Under the covers, at the core, it's just SQL Server. Yet, it really is so much more. And, as you can see from my little joke (very little) with the name, it's constantly changing. You could take the time & trouble to master it, except, you'll also need to spend a considerable portion of your time learning how to do data loads in order to get the data in correctly. That likely means you're going to have to learn some coding language like PowerShell or Python in order to support it. While you're off learning Python, Synapse is changing, so you're going to playing this constant game of catch up. Also changing will be the data loading tools, your scripting language, the Azure interface, etc. and, oh my, etc.. Now, I'm old. In theory, I'm going to retire in just seven years. Might happen. Might not. I'll worry about it as I get closer. However, I know one thing is true. If I want to keep the job I have, the career I've built, I cannot sit on the knowledge I've currently accumulated. I have to continue to learn, non-stop. I think that's true of many of us who consider ourselves technologists. For so many of us, there are two constants; Everything is changing and the learning is non-stop. 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 |
Calling data professionals! We want to know how you are monitoring your servers, instances and databases. By taking the 2021 State of Database Monitoring survey, you’ll help us better understand how the community monitor and manage their estates, and the challenges they face. You’ll get exclusive early access to the 2021 State of Database Monitoring report, plus, one lucky winner will receive a $500 Amazon gift card in our prize draw. |
How to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway. |
AI/Machine Learning/Cognitive Services |
Click here to learn more about Anas Baig. Accordin... |
Administration of SQL Server |
One of the challenges with managing a production d... |
Someone recently asked me which queries are ad hoc... |
Paul Randal is a SQL Server legend with loads of i... |
Total: 1 Average: 5To insert data into a table hav... |
Short post today. Simple query that will tell you ... |
Database systems have powerful features built righ... |
Under the covers, Azure SQL Database is just good ... |
Azure Synapse (SQL Data Warehouse and Data Lake) |
Hi folks, as some of you may be aware it was the M... |
Computing in the Cloud (Azure, Google, AWS) |
Radically rethink application experience for users... |
When it comes to the costs of cloud computing, adm... |
Conferences, Classes, Events, and Webinars |
Learn all aspects of migrating, using, and managing Azure SQL Managed Instance live from Microsoft Principal Architect Bob Ward. |
See how Redgate Deploy lets your teams achieve continuous delivery of database changes so you can accelerate software development and deliver more value to your customers. |
I attended part of the recent PowerShell + DevOps ... |
Data Mining / Data Analysis |
My father-in-law used to write down the numbers dr... |
Break down silos, uncover problems, support mental... |
Click to learn more about author Kartik Patel. Wh... |
Database Design, Theory and Development |
Even now in 2021, as companies have evolved their ... |
Edge computing storage plans need to account for b... |
Okay, now that IBM has revealed its 2nm chip desig... |
Edge computing systems automate package identifica... |
Performance Tuning SQL Server |
Paul Randal starts a new series exploring the reas... |
You’ve probably heard about extended events righ... |
The question comes up when looking at an execution... |
The following question came up when working on my ... |
Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues. |
PowerPivot/PowerQuery/PowerBI |
We have usually said that if you use a native quer... |
SQL Server Security and Auditing |
Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security. |
An 81-page report details how ransomware has evolv... |
There’s new research that demonstrates security ... |
Uploading personal photos to the internet can feel... |
Faulty API let anyone grab users’ private data, ... |
Exposed systems paved way for researchers to acces... |
Portfolio services updates for Meetings, Rooms, Ch... |
When setting up or upgrading a home office in whic... |
Click to learn more about author Chris Lynch. As t... |
Given that it's meant to be the basis for a lunar ... |
Five workers were arrested for washing and reusing... |
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. |
|
|