| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| 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 |
| Recorded on August 10, 2023 The AI Economy Speaker... |
| The startup says new versions of Claude will be tw... |
| Microsoft is making a high-stakes bet on AI. But w... |
| Aided by the democratization of generative AI, the... |
| Administration of SQL Server |
| In the realm of database management, particularly ... |
| This tip explores a better, more direct, and more ... |
| Introduction These are my SQL Server Diagnostic In... |
| Next in the SQL Server 2022 hidden gems series you... |
| I will be giving another Microsoft SQL Server-base... |
| bit Obscene Episode 2: SQL Server Agent Jobs Going... |
| (2024-Mar-08) Software installation typically inv... |
| Whether or not it’s a cloud offering that makes sense for you, Azure SQL Database is often the staging ground for new features that will eventually make it to all flavors of SQL Server. Earlier this year, Microsoft announced this magical-sounding feature, “optimized locking.” Instead of locking individual rows and pages for the life of the transaction, a single lock is held at the transaction level, and row and lock pages are taken and released as needed. |
| Career, Employment, and Certifications |
| Making a difference involves taking meaningful act... |
| This has been a busy week – we introduced a new ... |
| You told us one of the primary reasons to adopt Am... |
| March 7, 2024: Post updated to change GB to GiB. M... |
| AWS' Sébastien Stormacq said removing data transf... |
| For a monitoring project I’m currently working o... |
| From April 24 – 25, 2024 I will run a brand-new ... |
| This blog post was created on March 6th, 2024. Whe... |
| Computing in the Cloud (Azure, Google, AWS) |
| With the demise of the #SQLHelp hashtag (well it s... |
| The popularity of cloud computing continues to gro... |
| Businesses should adopt measures to automate their... |
| To revitalize shared services, organizations are s... |
| There's just too many applications and too much da... |
| Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values. |
| To effectively address the complexities of telemet... |
| We got an interesting question in the RavenDB Disc... |
| And another new SQL Down Under show is published! ... |
| Database Design, Theory and Development |
| The concept of data lineage has been around for many years, but it has become increasingly important in recent years due to the growth of big data and the increasing complexity of data processing systems. In today’s data-driven world, organizations are collecting and storing more data than ever before. This data is important for making informed business decisions, fueling innovation, and enabling organizations to better understand their customers and markets. |
| DevOps and Continuous Delivery (CI/CD) |
| THE VIDEO THE SYNOPSIS In this video, we take a lo... |
| I had a customer ask about undoing changes made by... |
| Redgate Test Data Manager will prepare, manage and... |
| David J. Berg, Romain Cledat, Kayla Seeley, Shasha... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| Andy Leonard shares a tip: The more I work with Mi... |
| The more I work with Microsoft Fabric Data Factory... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| At PGConf India 2024, I delivered a lightning talk... |
| The adoption of PostgreSQL is growing each year. M... |
| Invitation from Ryan Booz Many of the PostgreS... |
| 1. Overview In my previous blog, I discussed h... |
| I recently joined Michael and Nikolay as a guest o... |
| QGIS, the Quantum Geographic Information System, i... |
| I haven’t had a MySQL post for awhile, so it’s... |
| PostgreSQL is a powerful Open-Source database mana... |
| Welcome to PG Down Under! I've worked with data mo... |
| er sideUsing AI, it’s possible to find similar t... |
| This post will look at two relatively new programs... |
| Aggregation is a widely used way to summarize the content of a database. It is usually expressed with GROUP BY clause or just using aggregate functions (like COUNT or SUM). When the database engine executes a query with aggregations, it produces individual rows need to compute the required output and then performs the aggregation as (almost) last step. We discuss in this article how to re-write a query manually so that the order of operations will be different and when it can be beneficial. |
| Performance Tuning SQL Server |
| I’ve been working on a project where I have to d... |
| How To Tell If Lazy Table Spools Are Slowing Your ... |
| Both TOP (1) and MAX can be used to identify t... |
| SQL Server Index Design: Getting Key Column Order ... |
| PowerPivot/PowerQuery/PowerBI |
| Learn different approaches to format your DAX meas... |
| TRY_CAST() Arithmetic Overflow Error – How? It i... |
| It's been a long time coming but Visual Calculatio... |
| Navigating the Database Landscape is the headline ... |
| This is very off topic, but I’ve been a fan of R... |
| Hey there, pull up a chair, and let’s have a rea... |
| When I first starting writing this blog, I thought... |
| Disparities for women in tech for persist, despite... |
| This is today’s edition of The Download, our w... |
| Consumer Reports has analyzed a bunch of popular I... |
| It’s time for software developers to reconsider ... |
| Back in 2018, we started making Have I Been Pwned ... |
| T-SQL and Query Languages |
| In this article, we look at how to manipulate stri... |
| I’ve dealt with many interval packing tasks in the past and used different techniques to handle those. But they all had something in common that kept the complexity level at bay—they were all what you can think of as one-dimensional interval packing tasks. During a T-SQL class, while discussing packing challenges, Paul Wilcox from Johns Hopkins inquired whether I dealt with two-dimensional packing tasks, and if I had any references to resources for addressing those. In this article I present Paul’s two-dimensional packing challenge and my solution. |
| Infrastructure software providers are poised to le... |
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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. |
|
|
