| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Keep Sharing I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I think are going to help him the most. My immediate response is "What the heck do I know about it. I'm still barely learning." His response, my reward, "Well, you know, an expert is a person who is one page ahead of you in a book." Yeah, I taught him that. My editorial today then is, keep sharing. You really never know when the stuff you put out there is going bear fruit. Just because it seems like people aren't listening, they may well be. You are providing help, guidance, insight, as you share. Whether it's in formal settings like a presentation at a conference, answering questions on the forums here at SQL Server Central, taking part in the #sqlhelp or #pghelp hash tags, or just chatting with some colleagues, your sharing is influencing people. Please, keep it up. If you feel like you don't have anything to share, well, I'm here to tell you that you do. It may not be as much as the next person. It may not be some huge, powerful insight that changes the course of nations. It could be as little as sharing some positivity when someone is having a rough day. You can, and do, influence those around you all the time, whether you know it or not. So, as much as you can, try to direct it and make that influence a positive, helpful, force. As they say, every little bit helps. Share, keep sharing, start sharing. And thank 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 |
This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like SQL Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users. |
AI/Machine Learning/Cognitive Services |
Whether you think next-generation AI heralds an ex... |
Disinformation generated by AI may be more convincing than disinformation written by humans, a new study suggests. The research found that people were 3% less likely to spot false... |
As organizations transition to data-driven business models, they must store, protect, and most importantly analyze their data. AI, automation, cloud, and as-a-service models all must frictionlessly interweave to achieve universal... |
ChatGPT, the conversational chatbot released by OpenAI in November, garnered 100 million users in just two months, making it the fastest-growing consumer app in Internet history. But the technology that underpins... |
Generative AI is a form of artificial intelligence that is designed to generate content, including text, images, video and music. It uses large language models and algorithms to analyze... |
The authors say that ChatGPT's use of their text i... |
Virtual kidnapping is just one of many new artific... |
Administration of SQL Server |
Continuing from the previous entry in this series ... |
As a business owner or IT professional, you know t... |
I’ve had to type a few non-English characters lately, and this blog talks about how to do this. Another post for me that is simple and hopefully serves as... The... |
In a recent service request, a customer asked if there was a way to identify when QDS fails to capture a query due to various reasons, such as high... |
This month marks the anniversary of Database Health Monitor, that I started building in 2011. To celebrate I am offering 25% off the licensing fee for the annual subscription... |
Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post.... The... |
Analysis Services / BI on the MS Stack |
This month we have a new video course and whitepaper for SQLBI+ subscribers: Inside Calculation Groups is available! This course is a deep dive into calculation groups in DAX.... |
Azure Databricks, Spark and Snowflake |
One of the many things that the business team asks... |
Updates include Snowpark Container Services, which... |
In today's technologically advanced world, data pl... |
The error message "Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization" indicates that there was a failure in validating the server name... |
This morning, I have been working on a support case where our client was not able to see certain queries when querying the Query Data Store. We have observed that... |
Career, Employment, and Certifications |
One of the things that makes you a well-rounded pe... |
I know it's a cliche, but there's a reason the phr... |
Despite the hype surrounding generative AI, specia... |
More than 950,000 job postings for tech positions ... |
Being a CTO requires not only technical expertise but also business acumen and leadership skills. By following these tips, you can succeed in this role and contribute significant value... |
It’s now summer in the northern hemisphere, and ... |
In today’s business landscape, companies strive ... |
Easily manage public-facing and private-facing tra... |
I redid my static site’s contact form with a free option from my host, Netlify. Here’s why I changed my static site host and how I got a Netlify contact... |
Computing in the Cloud (Azure, Google, AWS) |
The shift to public cloud, private cloud, and SaaS... |
Conferences, Classes, Events, and Webinars |
Want to hear someone else’s experience of learning PostgreSQL from scratch? Then look no further. Grant Fritchey, Microsoft Data Platform MVP, started working with SQL Server in 1995 but more recently has needed to support and understand PostgreSQL. In this webinar, he will go on a deeper dive into the PostgreSQL database and will share top tips from his own learning journey. Join us on July 25th |
In this blog post, I’d like to give you a few ex... |
Data Mining / Data Analysis |
Amidst the ever-evolving retail industry landscape... |
Fun With KQL - Union Modifiers |
In the first of this two-part blog series, we disc... |
With SAS® Viya® and Snowpark Container Services ... |
Discover the best text analysis tools to help you ... |
Given a set of N points in k-dimensional space, ca... |
I was recently asked to be on the jury for the As... |
By now, you know that each color of the rainbow �... |
Database Design, Theory and Development |
As I have mentioned in a prior blog post, I have b... |
We are going to be making some changes to our RavenDB 6.0 docker image, you can already access them using the nightly builds: docker pull ravendb/ravendb-nightly:6.0-ubuntu-latest The purpose of those changes... |
DevOps and Continuous Delivery (CI/CD) |
This is documented, somewhat, but I wanted to put ... |
Infrastructure as code lets organizations manage c... |
ETL/SSIS/Azure Data Factory/Biml |
Part of one of my consulting gigs is helping a client lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). While developing some test pipelines... |
In this detailed article about academic plagiarism... |
Olivier Simard-Hanley is using a couple of Raspber... |
Arduino's latest boards retain the same Uno form f... |
Thanks to the power of OpenAI, Clippy will now be ... |
We review the 14TB Seagate IronWolf Pro, an HDD bu... |
Three weeks after its "quantum computer turned US-... |
The Asus ROG Ally game console comes with a tiny M.2-2230 SSD featuring a 512 GB capacity, which can be a bit tight for modern games. But enthusiasts from... |
Depending on availability, fixed wireless access could deliver the bandwidth IT managers need to connect far-flung workers and remote sites. |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Frequently, I am approached by curious individuals... |
People have been asking "What about SQL Server?" w... |
Oracle/PostgreSQL/MySQL/other RDBMS |
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE. These commands are used to insert new data into tables, update existing data, and delete data from tables, respectively. |
Performance Tuning SQL Server |
I recently presented a session on the Query Store ... |
SQL Server 2022introduces an enhanced Cardinality ... |
We will particularly focus on Persistence and Perc... |
Statistics objects are important for allowing the ... |
Thread pool waits management plays a vital role in maximizing the utilization of threads and ensuring the smooth execution of tasks. First appeared on SQL SERVER – Thread Pool Waits:... |
How I Use sp_BlitzCache To Find Poor Performing SQL Server Queries To Tune Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... |
PowerPivot/PowerQuery/PowerBI |
With the Microsoft Fabric announcement, There are ... |
Dynamic M parameters in Power Query isn't anything... |
Tired of the usual text data labels that only have... |
Steven Sanderson shows off a function in R: As a p... |
On its face, we have a simple requirement: Genera... |
Java’s package private visibility is an underrated feature. When you omit any visibility modifier in Java, then the default (for most objects) is package private, i.e. the object is... |
SQL Server Security and Auditing |
Implementing identity and access management proces... |
Extradited from Spain, PlugWalkJoe has been senten... |
Don’t do it: Recently, the manager of the Harvar... |
In a move to embarrass the city, hacking group kno... |
Misconfiguration exposed the physical addresses of... |
As cloud adoption grows, organizations need to ret... |
A new version of the double-extortion group's malw... |
LockBit ransomware group demands $70 million for not disclosing allegedly sensitive TSMC data. |
T-SQL and Query Languages |
Did you know you can include a SELECT statement wi... |
THE VIDEO THE SYNOPSIS In this video, we will lear... |
CEO says SEC penalties related to the 2020 SolarWi... |
Patches stuck to the skin can be an appealing alte... |
“It only takes a few hours on this campus to lea... |
Floating is the new flying, at least according to ... |
The $7.5 million in new funds from the Cybersecuri... |
Sboger is using a Raspberry Pi Pico W to remotely ... |
The idea of a widespread internet outage caused by a solar superstorm has captured imaginations and sparked misinformation, but concern isn't totally unfounded. |
This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. I briefly became a vegetarian around... |
Preliminary investigations indicate that the Chine... |
This article first appeared in The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, and read articles like this first, sign up... |
New report offers valuable resource to help organi... |
What is the main challenge we’re faced with when attempting to program computers? We are focused on writing the code that will behave as expected, and will be well structured. It turns out that holding both expectations in our head at the same time tends to produce a lot of confusion. |
Kevin McAleer has programmed a Tamagotchi-like pro... |
You can find great FDM or Resin 3D Printers for un... |
Voron Design conquered the last “Death Racer” ... |
Damaniel2 is using a Raspberry Pi to drive a custo... |
Libraries have become a popular co-working space in the hybrid era. |
As part of the Steam Summer sale, Valve is selling... |
Virtualization and Containers/Kubernetes |
In the world of IT not so very long ago, there was... |
The Docker Desktop development tool is getting new features that will help bridge the gap between local and cloud development. |
Kubernetes is a vast distributed platform that utilizes services to communicate internally and externally. Understanding different types of services and how they work is the beginning of knowing how... | This email has been sent to newsletter@newslettercollector.com. 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. |
|
|