| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Volunteer For Something I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some time on the HF rig (High Frequency), made a simplex contact in Maryland, and failed to make any contacts in fldigi or JS8Call. Finally I checked into a local NTS net on one of the UHF radios (Ultra High Frequency), just for practice. In short, I played radio. However, I'm also practicing using all these different forms because I'm a volunteer for the local ARES group. I'm looking at joining a couple of other organizations in the area (new town, new volunteer opportunities). Why? Because the world needs volunteers. There's just so much that needs doing. Yeah, I'm volunteering with an emergency service (not my first one either), but there are preservation societies for various historic... stuff, food kitchens, Scouting, charitable organizations, churches, Scouts, synagogues, Freemasons, and did I mention Scouts. All of these organizations do vital work for your community. And, I happen to know, worldwide, these organizations are suffering from a severe shortage of volunteers. People just don't engage in these organizations anymore (also, Covid added to the problem, because of course it did). It's a shame. We are going to lose organizations that truly matter. The thing is, volunteering does a whole bunch of stuff. Yeah, you're helping do some worthy cause, which is reason number one. However, you also get to meet people, make friends and contacts. You get to move, even if it's just going to a meeting. Volunteering is also a great help for your emotional well being. In short, absolutely support the worthy cause, whatever it might be, but also improve your own life at the same time. So, please, get out there and volunteer. You are needed. Yes. You. 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 |
Database migration is an essential part of the development process. It includes many challenges: from writing the migration scripts to making them runnable and avoiding loss of data. In this webinar we’ll look at common DB migration challenges and how to overcome them. |
AI/Machine Learning/Cognitive Services |
Introduction This article is the newest addition t... |
Administration of SQL Server |
This article covers the different SQL queries to change the column type. We are going to learn how we can change the data type of the columns of the... |
An application owner wanted to record the usage of... |
Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup. |
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover.... The... |
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection. |
This article uses Azure policies to check complian... |
Azure Synapse (SQL Data Warehouse and Data Lake) |
Azure Synapse Analytics is continually focused on delivering a highly performant and scalable platform for supporting Spark Workload. We are focused on improving the query performance for the typical workload patterns that we see with our customers. By combining the latest open-source updates in Apache Spark with our team’s focus on performance updates we have made significant performance gains in standard TPC-DS benchmarking tests. |
This article talks about the table distribution st... |
I gotta admit, some of you are really hard to convince. I’ve been saying for years that given a large enough database size (or a really small RTO storage based snapshots should be Plan A for recovering the database in the event of a disaster. Yes, you will have a Plan B, likely native backups. And Plan C. Maybe you’ll run out of letters because you’re so paranoid. |
In this article we will look at how to perform SQL... |
Steve Stedman So years ago, when my kids were grow... |
I spoke with four industry experts about the growing challenges in data governance, spotlighting which issues need to be resolved for better data management. The experts: Kelly Symons, Senior... |
Since day one, Microsoft has been right beside you... |
Computing in the Cloud (Azure, Google, AWS) |
New research reveals that organizations are not ch... |
In this article, we are going to learn how to trigger Function Apps from Queue Storage in Azure. Function Apps has been one of the most popular cloud services... |
Long-time readers of this blog know that I firmly believe in the power of education to improve lives. AWS Training and Certification equips people and organizations around the world... |
Last year before re:Invent, we introduced the public preview of AWS Distro for OpenTelemetry, a secure distribution of the OpenTelemetry project supported by AWS. OpenTelemetry provides tools, APIs, and... |
Looking for the next Microsoft Learn modules to complete? Bob Ward, Buck Woody, and Anna Hoffman give you a run-down of Microsoft Learn, the learning paths they've launched, and... |
Conferences, Classes, Events, and Webinars |
Join Matt Schmelzer, Data Systems and Automation - IT, and Jonathan Holck, IT Associate, from Artisan Partners in discussion with Microsoft MVP Grant Fritchey to learn how they implemented a successful infrastructure and what tools they need to support their growing estate. |
BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges. |
When I first think about automation, I generally think in the following way: in order to automate a script, we want to ensure that the script itself can be run via a command line interface (CLI) and with almost no user interaction (except for input and output parameters). Now, how do we apply this to Jupyter Notebooks so that we can automate SQL notebooks or PowerShell Notebooks? |
Introduction Over the last few posts I’ve been c... |
In this article, I’ll show you how to use Window... |
In my last post I talked about invoke-sqlcmd. It?... |
Data Mining / Data Analysis |
Over one billion dollars have been spent in the US... |
The field of probability and statistics is full of... |
Data warehousing has become a hot topic for most o... |
Click to learn more about author Ammar Ali. We have seen an unprecedented increase in modern data warehouse solutions among enterprises in recent years. Experts believe that this trend... |
DevOps and Continuous Delivery (CI/CD) |
The 2021 Accelerate State of DevOps report from Go... |
Every year, the Accelerate State of DevOps Report ... |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
Date: Wednesday, October 13, 2021 Time: 01:00 PM ... |
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work. |
Performance Tuning SQL Server |
Learn about performance of Adaptive Query Executio... |
Meet Wall There are, unfortunately, some times wh... |
If you’re wanting to test out your query tuning ... |
PowerPivot/PowerQuery/PowerBI |
I recently got a request asking if it was possible... |
Calculation Groups in Power BI can be amazing! Pat... |
Not a coder? Don't understand DAX syntax? DAX can ... |
Did you know that the PowerPoint Presenter Coach c... |
Andy Leonard makes a point: I recently blogged abo... |
Companies are starting to finalize their long-term... |
“Bias is not inhuman. To have bias is absolutely human,” says Banu Raghuraman. If data enthusiasts are going to break the cycle of bias, however, “we have to be... |
Click to learn more about author Balaji Ganesan. S... |
Scraped WHOIS data of NON-Epik customers also expo... |
Today’s accelerated pace of digital transformati... |
"Hard to say" who is responsible for platform-wide... |
According to Gartner, the worldwide public cloud s... |
New Azure-based OMIGOD vulnerability is easy to ex... |
Multifactor authentication is a well-known method ... |
A zero-day exploit—a way to launch a cyberattack... |
Back by popular demand – 50% off our recently re... |
In this article we look at various ways to create ... |
In this article we look at what a SQL Full Join is... |
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques |
Material costs are rising too, and the shortage wi... |
It's going to be at least mildly irritating to upg... |
Devices using only wireless charging would be exem... |
It comes with a long list of recommendations for a... |
Tools for Dev (SSMS, ADS, VS, etc.) |
Data Masker for SQL Server is a great tool ensurin... |
Virtualization and Containers/Kubernetes |
Among the reasons why Kubernetes is so challenging... |
Among the reasons why Kubernetes has been so widel... |
I find myself doing more and more work with contai... |
When storage is built into and run as containers, ... |
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. |
|
|