| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| You Never Know I'm writing this sitting at the PASS Data Community Summit. It's been a fantastic event. I gave a community session on Azure DevOps. I was able to help Redgate launch a new product. I've received a bunch of hugs from VERY dear old friends. I've met a ton of people. It's been great. Allow me to take a moment to tell you how I got here. In 2005, I attended my very first PASS Summit. I went to sessions. I went back to my hotel. I went to one, exactly one, party where I just happened to talk to a couple of volunteers who helped run the event. After speaking with them a bit, my life changed. I started volunteering. I wrote articles. I wrote a book. I presented sessions. I become an MVP. And I got the best damned job I ever had. All from a single conversation. You never know. You simply don't know what it's going to be, but it's going to be something. So, a couple of lessons here. You have to put yourself in the situation where you can have that critical conversation. Please, look for and take advantage of those opportunities. Also, you simply don't know how you're going to affect others. You may think you're just hanging out and drinking with a new acquaintance, but you might be changing someone's life trajectory. You never know. 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 |
Is MongoDB in use within your organization? The Flyway development team are adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey. |
The aim of this article is simply to demonstrate that you can use two DACPAC files, representing the source and target versions of a SQL Server database, to create a migration file that can then be used in Flyway. |
AI/Machine Learning/Cognitive Services |
In San Francisco last week, everyone’s favorite ... |
Cloud computing has become the backbone of countless industries, helping organizations use the power of analytics, machine learning and AI for insights and innovation. However, the rapid expansion of... |
Over the last year, generative AI has captivated the public imagination. Many of us have become newly acquainted with the concept of an approaching Singularity coined by John von... |
The transformational promise of artificial intelligence (AI) and machine learning (ML) for enterprises has fueled enormous excitement and massive investment by data executives. One estimate predicts that AI’s contribution... |
Microsoft has just started rolling out a new Windo... |
Katie King has interviewed subjects from many walks of business life for her books: academics, venture capitalists, executives from high-profile brands and telecommunications companies. Among them, one that made... |
Administration of SQL Server |
I suspect many people assume this is the case, but... |
We’re excited to announce a major new capability... |
On November 29, 2023, at 11 AM Eastern Standard Ti... |
This blog post will explore three underused features that can significantly enhance your SQL Server experience. Let us discuss 3 Underutilized Features. First appeared on SQL SERVER – Exploring 3... |
Potentially leading to less efficient implementations or missed opportunities for optimization. In this blog post, we'll explore three such Overutilized features. First appeared on SQL SERVER – Exploring 3 Overutilized... |
The 10th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to... |
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query... The... |
We are excited to announce the public preview (in ... |
Build new and highly scalable applications on Azur... |
Now you can retain backups for up to 10 years by d... |
To protect database powering the application from ... |
Update November, 16 2023 — I added a link to the... |
If you are ready to learn more about Generative AI while having fun and building cool stuff, check out PartyRock.aws . You can experiment, learn all about prompt engineering,... |
We are launching three new voices for Polly. Powered by a new long-form engine, the voices are natural and expressive, with appropriate pauses, emphasis, and tone. New Voices The... |
I can’t believe it’s been 15 years since Amazon CloudFront was launched! When Amazon S3 became available in 2006, developers loved the flexibility and started to build a new... |
Together with cloud giants AWS, Microsoft, Google Cloud, and Oracle Cloud, the FinOps Foundation, a Linux Foundation project focused on cloud financial management, has created a universal cloud billing... |
Azure Ultra Disk Storage now provides maximum thro... |
We were excited to get back in front of customers ... |
Red Hat Enterprise Linux (RHEL) 9.3, the latest version of RHEL 9 from Red Hat is now generally available on Azure Virtual Machines (VMs). Availability of RHEL 9.3 for... |
With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and... The... |
I arrived early to get my seat at the media table.... |
Morning from the PASS Data Summit! I will be live ... |
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! Carly Miechen – Redgate Events Welcome to day 2. Let the... |
Morning from the PASS Data Summit! I will be live blogging the event again today, so check back for announcements and releases throughout the keynote. Today, we will dive... The... |
The bulk of today's boot camps fail to provide the breadth of tech knowledge needed to excel in elite IT positions. |
The WIT panel spoke on an excellent topic today: needing, and finding, allies at work. Afterward and for the first […] The post Women in Tech: Finding Allies #PASSDataSummit appeared... The... |
Last but not least, the Community Keynote. Hang on to your hats, this is going to be an interesting ride! President/Founder of SQL Skills – Kimberly Tripp Surprised people... |
Computing in the Cloud (Azure, Google, AWS) |
AGI, or artificial general intelligence, is one of the hottest topics in tech today. It’s also one of the most controversial. A big part of the problem is that... |
If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. But... |
The cloud, fundamentally a tool for cost and resource efficiency, has long enabled companies and countries to organize around digital-first principles. It is an established capability that improves the... |
Conferences, Classes, Events, and Webinars |
Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November to learn: How test data management can benefit you in your role How you can reap benefits including accelerated data provisioning, and improved quality and speed of application releases Top takeaways from the exciting launch at PASS Data Community Summit 2023 How Redgate have worked to simplify the challenges of managing and getting your hands on quality (yet compliant) test data |
Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November to learn: How test data management can benefit you in your role How you can reap benefits including accelerated data provisioning, and improved quality and speed of application releases Top takeaways from the exciting launch at PASS Data Community Summit 2023 How Redgate have worked to simplify the challenges of managing and getting your hands on quality (yet compliant) test data |
Data Mining / Data Analysis |
More than spreadsheets and formulas, data analytic... |
From Service to Software, and Back Again At SAS, he’s known as “DJ Mobelizer” or “The DJ”, but the man behind the music at SAS events, is none other... |
Database Design, Theory and Development |
Since its introduction to the marketplace in 2000, the consistency, availability, and partition theorem, or CAP theorem, has been a guiding principle in database management. Computer scientist Eric Brewer presented... |
DevOps and Continuous Delivery (CI/CD) |
MLOps is the practice of applying DevOps principles to machine learning. Learn more about MLOps and how it can help you streamline your ML workflow. The post What is MLOps?... |
I spoke with Sean Knapp, CEO of Ascend.io, about the issues and challenges involved with automating data pipelines. Among other key points, he noted that “Companies that don’t have... |
Sometimes query tuning involves taking a different approach to a problem. And given that other tuning options might be creating index(es) or redesigning tables – both of which are much more permanent changes to an environment – rewriting a query can often be just right. |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Reading Time: 6 minutes In this post I want to share my thoughts about the Microsoft Fabric journey to becoming Generally Available (GA). Which was announced by Microsoft... |
We look deeper at Data Activator in Microsoft Fabr... |
Matt Gordon gives us the lowdown: At their Microsoft Build conference in May 2023, Microsoft announced the company’s new unified analytics solution, Microsoft Fabric. As… |
Oracle/PostgreSQL/MySQL/other RDBMS |
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs various techniques to ensure concurrent access to the database while maintaining data consistency using atomicity and isolation of ACID (stands for Atomicity, Consistency, Isolation and Durability properties. |
Performance Tuning SQL Server |
How Multi-Statement Table Valued Functions Cause Performance Problems In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... |
PowerPivot/PowerQuery/PowerBI |
Discover the new DAX Query View introduced in Power BI Desktop November 2023. Spoiler: it is a good feature! |
In part 1 of this series, we examined our data bef... |
Rackspace's 2022 ransomware attack costs only cont... |
Organizations in "essential" sectors have until Oc... |
To prevent cyberattacks, organizations must implement strong security measures, adapt to new challenges, and promote digital literacy. |
Vehicles are required to meet basic safety standar... |
T-SQL and Query Languages |
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases. |
Here's how organizations can reduce legal risks du... |
Introduction The second post in this series, Gaming the Electric Grid – PV Solar will cover my experiences with residential grid-tied PV solar systems as a homeowner over the... |
This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. We’ve covered the dream of fusion... |
Accessibility should not be an afterthought In a world that thrives on connectivity and progress, the concept of accessibility has emerged as a fundamental bridge that connects diverse individuals... |
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 here.... |
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. |
|
|