| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| The Fake Speakers In the last few weeks, I've seen a few posts on social media from event organizers. The theme has been "we won't make up AI speakers", which I thought was some sort of joke about AI being used to write, and perhaps, deliver a presentation. After all, we're a long way from Max Headroom, and with all the AI stuff happening, maybe an AI actor could present something to an audience. It wasn't a joke and the conference in question has been cancelled. Apparently, the organizer said he generated a fake woman's profile with AI after a woman dropped out. He says this was a placeholder, which is possible, but it's not something I'd do at an event. I'd just note there is a hole in the speaker schedule and I was looking for someone else. There are also claims that previous conferences included fake profiles or profiles of women who dropped out or declined to speak. A number of tech speakers and execs dropped out of the conference after this news. There are quite a few people who look at the list of speakers and if there is not enough diversity, they may decide not to attend. There are even corporate policies at some companies that note that they don't support events that haven't made efforts to include a diverse set of speakers. I get that someone might struggle to get a diverse set of speakers (or employees), and despite their efforts, they end up with a homogenous group of people. I've seen this happen, and I know that timing, travel, topic, etc. sometimes mean that a session could end up with all men (or all women). It's unfortunate, but it happens. I also know that plenty of people don't want to disclose that they are considered someone of "diversity," which makes it hard for organizers to plan their schedule. However, I don't get putting fake profiles up on a site. Those aren't placeholders, those are deceitful actions that want to generate some publicity or hide the fact someone chose not to participate. It's the same when a speaker withdraws, though I know that updating the website with a cancellation sometimes doesn't take precedence. Speaking is a burden, it costs money, and at many events, I've seen speakers cancel for various reasons, including the need for them to be at work instead. Especially at more general events, like some of the DevOps conferences that choose managers to speak, I'm somewhat shocked at all the cancellations written on boards outside of conference rooms. The age of digital everything, with the added capabilities of AI, mean that I find myself trusting lots of "data" less and less. The images, videos, and especially text can, and often is, manipulated by someone for their own purposes. I'm not surprised at all the outrage and conspiracy views of the world when any sort of information can be faked. As someone who's tried hard to ensure data quality, as do most data professionals, it's disturbing to see the trend. I'm equally disturbed by the constant calls of fake news, not because facts are in dispute, but because someone doesn't like facts. There is fake news, there is bias and slant, and there is a difference of opinion, but I hope that most data professionals do their best to ensure the data they have is correct. After that, I hope people using that data do so honorably, without trying to deceive others by making something up. Steve Jones - SSC Editor 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. |
AI/Machine Learning/Cognitive Services |
AI is a widely discussed topic, an... |
THE VIDEO THE SYNOPSIS In this video, I answer a viewer question about what Azure ML provides for people who are already familiar with each step of the machine... |
Generative AI has been the biggest technology story of 2023. Almost everybody’s played with ChatGPT, Stable Diffusion, GitHub Copilot, or Midjourney. A few have even tried out Bard or... |
A framework to identify the causal impact of succe... |
Administration of SQL Server |
Have you ever been reviewing SQL Server waits and ... |
I know I can use extended events (xevents) in Azur... |
SQL Server 2022 RTM has completed one year after SQL Server GA release last November. Per the Modern Servicing Model Announcing the Modern Servicing Model for SQL Server -... |
I discuss reasons you might think a data change was successful when it wasn't - or vice-versa. |
Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device https://******... |
Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device https://******... The... |
Azure Databricks, Spark and Snowflake |
Global sorting is one the most important operations on data, and it is not only used to define how you can see the query result in UI but more... |
We really need to monitor so that we know what is going on, and more importantly, what is going on before our customers and bosses do. From this, we can then take actions, (preferably proactively) effectively swooping in and saving the day, albeit silently to our customers if we get it right. |
We have a client asking us what the login rate per second is that I can achieve on a S0, S1, S2, and S3 database. It's a complicated question... |
Career, Employment, and Certifications |
To retain top tech talent, organizations must look beyond financial compensation to provide growth opportunities and wellbeing. |
I have curated the list of activities of a DBA or one can say Job Description of a DBA. DBA needs to adapt and keep learning new technologies The... The... |
I am pleased to announce that IBM and AWS have come together to offer Amazon Relational Database Service (Amazon RDS) for Db2, a fully managed Db2 database engine running... |
Computing in the Cloud (Azure, Google, AWS) |
Hybrid cloud solutions are indispensable in achieving a balance between data security, scalability, and innovation for banking, fintech, artificial intelligence (AI), and machine learning (ML) industries. These sectors encounter... |
Conferences, Classes, Events, and Webinars |
For this month’s #PGSQLPhriday 014 blogging even... |
It’s more than a week post PASS Data Community Summit and I’m finally getting around to sharing my thoughts. Personally, I had a blast. I was part of a... |
Learn two methods – an easy way and a hard way �... |
Data Privacy, Compliance, and Governance |
Within corporations, the theme of governance has been one of the most important themes for decades. Scholars have discussed and debated how corporations can be governed in order to... |
ETL/SSIS/Azure Data Factory/Biml |
No matter the ETL tool used, there are some basic patterns to follow when transferring data between systems. There are many data tools and platforms, but the basic patterns... |
Once the domain of external, bus-powered hard drives, these days the market for external storage has been almost completely consumed by portable SSDs. Rapid technological advancements in NAND flash... |
A lot of DAX performance problems relate to the use of strict and eager evaluation with the IF or SWITCH functions. It’s an incredibly complex, “it depends”, black-box type... |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
In my time working with Advancing Analytics, I’ve continued to use it with Databricks lakehouses and have even developed our own solution accelerator with Tabular Editor to get people up and running with Power BI semantic models on the lakehouse fast. |
Sorry to disappoint you. In this post, we won't te... |
Reading Time: 4 minutes In this post I want to co... |
Not sure about Notebooks or PySpark in Microsoft F... |
In the many conversations I had over the past year... |
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power BI allowed us to include source control on a SDLC process for... |
In this blog post I am going to show you an easy way to clean your data (which is often fixing data issues or mis-spelt data) using the new... |
In the previous blog post, I explained Microsoft Fabric capacities, shedding light on diverse capacity options and how they influence data projects. |
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an interesting advance, but it was disappointing because it was only available in... |
This is week 1 where I try to take Magic the Gathering draft data to learn Microsoft Fabric. Check out week 0 for some reasoning why. So, before I... |
Reading Time: 8 minutes In this post I want to cover spreading your SQL Server wings with Microsoft Fabric Data Warehouses. As part of a series of posts... |
Oracle/PostgreSQL/MySQL/other RDBMS |
Authentication is the process of verifying the identity of a user or system attempting to access a database. In the realm of PostgreSQL, authentication serves as the first line of defense, ensuring that only authorized individuals or applications gain entry. As the gateway to sensitive data, robust authentication is imperative, safeguarding against unauthorized access and fortifying the foundation of data protection. In this blog, we delve into the significance of authentication in PostgreSQL, unraveling its critical role in securing valuable information. |
Performance Tuning SQL Server |
Optimizing SQL Server Query Plans With Row Count S... |
A question from a client got me thinking. Relational databases (at least the ones I know and love) can’t really index for queries that use LIKE queries for a substring of a column value. If you want to search for strings beginning with a given string, a regular rowstore index will have you covered. If you’re looking for entire words or sentences, a full text index might be a good call. But because of the very way indexes work, you’ll never get great performance searching for just arbitrary parts of a string. |
Optimizing Complex SQL Server Queries By Using Batch Mode Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training.... |
After last week’s post I got to thinking that although we’ve looked at how to implement window functions, we haven’t peeked under the hood to see how they are executed. Then... |
Optimizing SQL Server Query Plans With Table Spools In Them Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my... |
In this article, I demonstrate the issue of creating two SQL Server indexes to enhance performance, but the query optimizer only chooses one which doesn't help with performance. |
Optimizing Common Table Expression Queries In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m... |
PowerPivot/PowerQuery/PowerBI |
Learn how to create an area chart in Power BI to understand the intensity of a change and cumulative total values over time along with the different available formatting... |
This post is the third part of a blog series on the AI features of Power BI. Part 1 described three generally available AI features in Power BI: forecasting,... |
Product Reviews and Articles |
If you can convert a SQL file to HTML, then you ca... |
A user on the SQL Community Slack was asking about what the $surroundtext$ variable. This post looks at how this can be used in snippets. This is part of... The... |
Product Upgrades and Releases |
The new Amazon S3 Express One Zone storage class i... |
Azure NetApp Files now supports smaller 2 TiB capacity pool sizes, lowered from 4 TiB, when used with volumes using standard network features. |
I am happy to announce the general availability of Amazon Neptune Analytics, a new analytics database engine that makes it faster for data scientists and application developers to quickly... |
Today, we are announcing the general availability of vector search for Amazon DocumentDB (with MongoDB compatibility), a new built-in capability that lets you store, index, and search millions of... |
Today we are announcing the general availability of the vector engine for Amazon OpenSearch Serverless with new features. In July 2023, we introduced the preview release of the vector... |
Performing automatic game day testing of all your critical resources is an important step in determining that you are prepared to respond to ransomware or any data loss event.... |
OpenCV provides a comprehensive set of tools and algorithms for image processing, allowing you to easily manipulate and enhance images. First appeared on Python – Image Processing with OpenCV |
Off-the-shelf solutions for interactive data app development such as Microsoft Power BI are great – they allow users to easily develop data apps using a GUI. However, Power BI’s... |
If you’re familiar with linear regression in R, you’ve probably encountered the traditional lm() function. While this is a powerful tool, it might not be the best choice when dealing with outliers or influential observations |
If you’ve ever found yourself grappling with noisy data and yearning for a smoother representation, LOESS regression might be the enchanting solution you’re seeking. In this blog post, we’ll unravel the mysteries of LOESS regression using the power of R, and walk through a practical example using the iconic mtcars dataset. |
Uselessness is such a long useless word! In statistics, R-squared is a statistical measure, that determines the proportion of variance in dependent variable that can be explained by the... |
While I've very rarely been jealous of Oracle, 23c added something I really want in SQL Server. |
Today I have uploaded SQL Server Quickie #46 to Yo... |
They’re not that good: Security researchers Jesse D’Aguanno and Timo Teräs write that, with varying degrees of reverse-engineering and using some external hardware, they were able to fool the Goodix... |
by Aditya Mavlankar, Zhi Li, Lukáš Krasula and Christos BampisHigh dynamic range (HDR) video brings a wider range of luminance and a wider gamut of colors, paving the way for... |
I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw... The... |
T-SQL and Query Languages |
We revisited window functions last week for T-SQL Tuesday. As we’re in that area there’s another example I thought was worth exploring. Can we group data whilst applying window functions in the same query? |
Fortune cookies contain uplifting messages that bring a smile after a good meal. Did you know they likely originated in America, not China? First appeared on SQL SERVER – T-SQL... |
GitHub needs to convince non-developers that its p... |
Engineering leaders previously withdrew from DevTernity before the conference was canceled after the event organizer was accused of faking panelists to boost diversity. |
As data grows and databases become larger and more complicated, data subsetting provides a method of working with a smaller, lighter copy of a database to make development and testing faster and easier. In this article, James Hemson poses the questions; what exactly is data subsetting, how and why are developers using it – or not using it, and what’s prompting conversations about it? |
Each time you use AI to generate an image, write a... |
As I’ve aged, I find myself struggling to read m... |
nighthawk – n. a recurring thought that only see... |
Tools for Dev (SSMS, ADS, VS, etc.) |
A couple of months ago we released a new version o... |
Today, we’re announcing the general availability of artificial intelligence (AI)-powered code remediation and infrastructure as code (IaC) support for Amazon CodeWhisperer, an AI-powered productivity tool for the IDE and... |
Virtualization and Containers/Kubernetes |
There’s a compelling rationale for SQL Server no... |
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. |
|
|