| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| To Each Their Own I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. I prefer to hear the world as opposed to machines and constantly blasting music. I'm not a show person. I, mostly, don't care for gambling (I do find craps fascinating, but I hate losing money). I feel like Vegas is overpriced too. Food's great though, but it costs a fortune. Overall, Vegas just isn't for me, even though I tend to go there at least once a year, sometimes more. It's the job. On the other hand, I saw a lot of people, even families with kids (spring break week here in the States), having a blast. They love it. Maybe it's the shows. Maybe it is gambling. The games. The bars. Heck, the noise and lights. People love it. And that's OK. Just because I don't care for it doesn't mean I'm going to try to take it away from others. I am firmly against the idea of "wrong fun." Meaning, you can have fun in ways that I approve and enjoy. We really are individuals. I might enjoy sitting at a quiet bar, murmuring crowd in the background, while I sip a wine and read a book. Others would find that incredibly dull. Still others would find the bar distracting them from their reading. More others (I have a limitless supply) would object to the alcohol. All of that is OK, as long as we don't try to force anyone to "right fun" and away from "wrong fun." In short, to each their own. 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 |
The 'Migrate' command automates the process of applying the database schema changes that are defined in migration scripts, while Flyway tracks the version of every copy of the database. This makes it much easier to maintain consistency across different database environments, and so facilitates continuous integration, continuous deployment, and database version control practices. |
AI/Machine Learning/Cognitive Services |
Just because it's easy to get going with an AI clo... |
The new wave of data-hungry machine learning (ML) ... |
Lately it’s copilot before and after in all Micr... |
If you’ve been keeping an eye on the evolution of generative AI (GenAI) technology recently, you’re likely familiar with its core concepts: how GenAI models function, the art of... |
Administration of SQL Server |
Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source of the problem is usually the web installer/wrapper, which can fail for a variety of reasons that aren’t always made clear by the error messages. Today, I’m going to walk through one way you can approach a workstation upgrade and avoid these web installer issues altogether. I’ll focus on SQL Server 2022, but most of the information applies to any modern major version. Most of the information applies if you’re installing a brand-new instance, too. |
Your boss walks up to you one morning and says, �... |
Introduction These are my SQL Server Diagnostic In... |
Do you know the feeling when someone gives you a f... |
Learn about using filtered indexes for SQL Server ... |
Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode("overwrite").format("delta").partitionBy("Year","Month","Day").save("Tables/" + table_name) Let’s consider we load the data daily, with all the transactions from... |
I am new to SQL Server and I have heard the term u... |
Analysis Services / BI on the MS Stack |
This article describes how you can use a scatterpl... |
In certain circumstances, we need to apply product... |
Now you can retain backups for up to 10 years by d... |
Some time ago, we encountered a support case where... |
Read the 2024 recap of all the Azure SQL and SQL S... |
When updating data in SQL Server, operators run th... |
On World Backup Day, explore our curated collectio... |
As a Software Engineer, I would like to deploy my ... |
Today is April Fool’s Day. About 10 years ago, s... |
Customers in industries such as architecture, engi... |
Improve your workload’s resiliency and optimize ... |
I'm thrilled to be your host for this month's epis... |
I’m off on Thursday for Salt Lake City and a SQL... |
I’m heading to the UK in a few weeks for the Lon... |
Learn about the practical applications of sliders ... |
No breakfast cereals or comic tigers were harmed i... |
Join PowerShell expert Brien Posey as he explains ... |
Data Mining / Data Analysis |
Data is invaluable to an organization, but it can also represent a major stumbling block if an enterprise hasn’t optimized how data is used to support processes that run... |
Data Privacy, Compliance, and Governance |
The benefits of data classification and the featur... |
DevOps and Continuous Delivery (CI/CD) |
According to the Bureau of Labor Statistics, the o... |
Organizations need to also acknowledge and support... |
THE VIDEO THE SYNOPSIS In this video, we look at h... |
Here's how developers can enhance their CI/CD processes to leverage AI-powered coding tools more effectively. |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
In the previous article in this series, I demonstr... |
ETL/SSIS/Azure Data Factory/Biml |
In this article, we look at how to set up differen... |
Most people will describe a framework as the "buil... |
Chances are that if you’ve found your way to this blog, you’re somewhat familiar with ETL (Extract-Transform-Load). If you’ve ever been reading a blog post or article and saw... |
In this article, learn how to configure per pipeli... |
Oracle/PostgreSQL/MySQL/other RDBMS |
Ross Anderson unexpectedly passed away Thursday ni... |
Introduction In my previous post A Brief History o... |
Quit reminder that Devrim Gündüz of EnterpriseDB... |
Introduction Logical Replication is one of the man... |
© Caroline Albe 2024 Logging to sys... |
There is an ongoing and engaging open discussion i... |
Understand how SELECT * can be bad for database pe... |
Learn to manage roles and privileges in PostgreSQL... |
Performance Tuning SQL Server |
Facing the challenge of optimizing complex SQL Ser... |
Spring Training This May, I’ll be presenting my ... |
Dynamic SQL has many uses and one of these can hel... |
Why INSERT/EXEC Causes Weird Blocking 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 offering... |
PowerPivot/PowerQuery/PowerBI |
Exciting news has just landed in the Power BI univ... |
I was working on an imported Power BI semantic mod... |
Think you are using the same data source in Power ... |
Don't ignore Dual Mode! If you are leveraging Dire... |
There are so many choices and so little time. How ... |
One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My career has always revolved around data, but this is... |
The 24/7 on-call nature of work for many IT professionals is leading to a shift in priorities in favor of a more sustainable work-life balance, a change accentuated by... |
A federal review board demanded that the tech giant prioritize its "inadequate" cloud security posture. |
The ProtonMail people are accusing Microsoft’s new Outlook for Windows app of conducting extensive surveillance on its users. It shares data with advertisers, a lot of data: The window informs... |
It seems that the FCC might be fixing the vulnerabilities in SS7 and the Diameter protocol: On March 27 the commission asked telecommunications providers to weigh in and detail what... |
In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code. |
T-SQL and Query Languages |
String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extract detailed information from it. Those of us who have tackled these challenges fully understand how code can quickly go from simple to absurdly complex, one function at a time. This article is focused on how to write, simplify, and get the most out of string data using the least amount of code to do so. It’s a reminder that code complexity is equivalent to technical debt and that in these scenarios, less is always more. |
Tzu-Wei Fang will always remember February 3, 2022... |
A shut-down nuclear power plant in Michigan could ... |
This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. The hard lessons of Harvard’s failed geoengineering... |
On April 8, the moon will pass directly between Earth and the sun, creating a total solar eclipse across much of the United States, Mexico, and Canada. Although total... |
Virtualization and Containers/Kubernetes |
When selecting a container orchestration tool, considerations such as project size, resource constraints, and team expertise should guide the decision. |
In this last segment of the series, we’ll delve into the crucial elements of navigation and flow, exploring further the part of web accessibility that ensures users can effortlessly navigate online content. Additionally, we’ll shine a spotlight on the indispensable practice of regular testing, an ongoing commitment that goes beyond compliance, providing invaluable insights into real user experiences and fostering continuous improvement. |
Deploying database code using pipelines in various... | 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. |
|
|