| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| The Impact of Small Changes A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be a host each month, reveal a topic one week ahead of time, and then on the first Friday of each month, we look to see who contributed blog posts from within the community. It's been a blast to see this little project reach more people each month. For September, I asked people to write about the features they're most excited about for the upcoming release of PostgreSQL 16. While I didn't put any constraints on the features people could write about, I suggested that they try to identify some features that hadn't gotten a lot of attention yet. Although there were only a few submissions this month (September and October are busy in the PostgreSQL community), one thing stuck out to me from everything that people wrote about. Some of the smallest, and seemingly insignificant changes, are the most exciting to a lot of people. At Redgate, we talk often about the concept of "shifting left", working to bring database development automation as early in pipeline as possible. And for many of these little features that people got excited about, it's often because it solves a small, but consistently annoying need for many people. It's almost as if the tasks that took just a little bit longer in previous versions of PostgreSQL are now more easily accessible and developers can "shift left" and be more productive directly within the database. What does that look like in your world right now? Are there tasks at work that you can automate in a new way to free up more of your time for something more productive? Is there a feature of the database platform you use that has always been a little bit confusing to you, but may result in large productivity gains if you spent a little extra time figuring it out? Can you call a lunch-and-learn meeting at work sometime this month and pass on that cool trick you just learned at the conference you went to? What I continually see, much like in the responses to PostgreSQL 16 features, is that the mundane improvements often have the largest impact. Take a look around you and see what small change you can make this week that might have an outsized impact in the future. Ryan Booz 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 |
| If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes! |
| AI/Machine Learning/Cognitive Services |
| In the past year, kids, teachers, and parents have had a crash course in artificial intelligence, thanks to the wildly popular AI chatbot ChatGPT. In a knee-jerk reaction, some... |
| AI language models are not humans, and yet we evaluate them as if they were, using tests like the bar exam or the United States Medical Licensing Examination. The... |
| THE VIDEO THE SYNOPSIS In this video, we briefly cover the core principles of DevOps and DataOps, then learn how we can apply those ideas to machine learning projects.... |
| I spoke with Nima Negahban, CEO of Kinetica, about... |
| Administration of SQL Server |
| Compliance audits ensure that organizations adhere to regulatory guidelines, industry standards, and internal policies. As SQL Server DBAs, you can be prepared for most audits if you already check... |
| Yet another kind of orphan users in SQL Server Or YAOU for short. (This silly acronym, I just made it up so don’t try... The post Yet another kind of orphan... |
| Etienne Lopes begins a new series: “As part of High Availability architecture, each single database, elastic pool database, and managed instance in the Premium and Business… |
| Azure SQL Managed Instance |
| Support for restoring database backups from Amazon S3 to Azure SQL Managed Instance (MI) is now Generally Available (GA)! This feature offers users a flexible way of restoring backups and... |
| Career, Employment, and Certifications |
| Is your company hiring for a database position as of September 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some... |
| Landing a Data Science role is one thing, but joining an organization where you can truly thrive is quite another. As a Data Science talent strategy leader, I can share... |
| Brent Ozar shares some thoughts: Note that 11:34, the decision was made to shut down infrastructure without Microsoft failing your databases over elsewhere. If you were an… |
| Hey there, I’m Mala. I’ve been in the data game for a good 25 years, first as a DBA and then as a Data Engineer, mainly working with Microsoft... The... |
| Conferences, Classes, Events, and Webinars |
| Your DevOps learning journey starts here. Join Redgate's Roadshow as it goes from coast to coast, wrapping up in Seattle at the PASS conference. Sign up today. |
| The Federal sector has traditionally been slower in adopting advanced software development practices like Agile and DevOps, but organizations like the DoD and DISA are now raising the game to a new level with DevSecOps. |
| Rathish Kumar says more than “JSON and Parquet”: In the world of software, we often work with different types of data like lists, tables, and… |
| Database Design, Theory and Development |
| In coming up with a strategy for managing test data, first you need to understand what the many test requirements are likely to be for the particular database you are developing. Next, you need to create all the different categories of test data required to suite test requirements and, finally, work out how to manage it in a way that allows a test-driven approach to development. |
| In the previous parts of these MySQL optimization series, we’ve told you how queries work on a high level, then dived deeper into the power of SELECT and INSERT statements. In this blog, I will cover some of the ways to optimize modifying your data too. |
| Quotable SQL Server is pretty good at a lot of things, but there’s no great way to debug logic or performance issues in longer stored procedures. Whenever I’m writing... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| Enabling or disabling staging on a Dataflows Gen2 query can have a big impact on performance |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, you’ve come to the right place. And while using Docker on its... |
| Performance Tuning SQL Server |
| A Reintroduction To sp_PressureDetector Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount... |
| PowerPivot/PowerQuery/PowerBI |
| Kurt Buhler and Stepan Resl give you a card: When a user arrives at your report, they should be able to answer their most important… |
| Currency conversion is a common requirement, such ... |
| SQL Server Security and Auditing |
| Ben Johnston configures row-level security in SQL Server: Implementing RLS is as much a business endeavour as technical. Without a business case to implement RLS,… |
| The sophisticated attacks, tracked as DB#JAMMER, r... |
| The previous section in this series was an introduction to Row Level Security (RLS) and some use cases. This section focuses on basic setup of RLS, methods for implementing... |
| Vercel implemented Cron Jobs using Amazon EventBridge Scheduler, enabling their customers to create, manage, and run scheduled tasks at scale. The adoption of this feature was rapid, reaching over... |
| T-SQL and Query Languages |
| Have you ever heard of the READPAST query hint? I would say it’s kind of a sibling to NOLOCK. With NOLOCK, you’ll get data back faster but risk dirty... |
| One of the leading companies offering alternatives to lithium batteries for the grid just got a nearly $400 million loan from the US Department of Energy. Eos Energy makes... |
| 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. |
|
|
