 | | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Smile and Wave Boys I won't even try to hide it. I got a huge kick out of the penguin characters in the animated movie, Madagascar. For those who don't know, they're trying to escape the zoo, but are trying to hide that from anyone discovering it. So, they put up a front, "Smile and wave boys. Smile and wave." Still makes me giggle. I was at dinner with a few coworkers. We were moaning about a few things at work. Yes, I work for a great company that treats me far better than I deserve. I truly love my job. However, it is still a job. There are bits of it that are something of a pain. When Ryan Booz said "Just smile and wave boys" about a situation, I think I may have snorted some wine through my nose. It was a perfect response. It also reminded me of how often, in my family, we'll reference other movies as a shorthand for communicating a thought, feeling, or emotion. It gets to the point where we'll reference something in front of others, we'll all giggle, and then we have to explain: "No, no, it's from this movie. What? You've never seen it? Well in this scene...." Which also then brought to mind how we likely do the same thing when talking about technology. Those of us who are older, and have a longer history inside Microsoft SQL Server, surely remember service packs. The really old among us remember the time that there was a service pack released for SQL Server 6.5, Service Pack 5. The unfortunate among us (hi, my name is Grant), who put it too quickly into production (I was young) hurt our servers because within days, Service Pack 5a was released, because SP5 was broken. So I could tell someone when asked about an upgrade "Not as bad as SP5" and they would get it. Now, for most of you, that's a lost language. I think we need these types of touchstones, short hands, references, as a way to communicate sometimes. But we should be ever mindful that to others, it can sound like "Darmak and Jalad at Tenagra." IYKYK. 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 |
| Query Executions in Redgate Monitor captures individual query executions for long-running queries, providing deeper insight into database workload and resource usage. This helps DBAs diagnose performance issues with greater accuracy. |
| We’re excited to announce that users can opt-in/out of preview features that are under development directly in Flyway Desktop. There are currently three preview features that will be in the next major version of Flyway Desktop; a new connection dialog with options to provision databases, a full schema model view, and support for static data in PostgreSQL databases. |
| ASP.NET Core Minimal APIs are a new (as of the end of 2024) way to build web APIs in ASP.NET Core. Minimal APIs are lightweight and easy to use, if you keep the handlers minimal. In most API endpoints there is a need to tackle errors, which can introduce complications to the code. An API endpoint can return an error in many ways, such as internal server errors, bad requests, or not found errors. In this article, I will show you the usual way of tackling errors in ASP.NET Core, and how it can be improved using the Result pattern. |
| AI/Machine Learning/Cognitive Services |
| Amid surging demand for data centers, leaders at C... |
| Mollick proclaims "the meme Turing Test has been p... |
| Reading McKinsey's article How Banks Can Superchar... |
| GenAI is replacing citizen development. Here's why... |
| Administration of SQL Server |
| Just what happens when you hit SQL Server’s parameter limit of 2100? Rightly or wrongly, Louis Davidson decided to find out. Spoiler alert: it’s even worse than he imagined. |
| This is a post in the SQL Interview series. These ... |
| I live for questions and this was an interesting o... |
| In the previous post, I talked about how you could... |
| One of the most popular courses that we used to ru... |
| This is a post in the SQL Interview series. These ... |
| I have to say that I’m so happy with all the res... |
| Maybe I’ve forgotten the name and the address of... |
| This was an interesting thing I saw in a Question ... |
| Monday morning: you’re back at work, but your SQ... |
| This is a post in the SQL Interview series. These ... |
| Azure Databricks, Spark and Snowflake |
| I’m doing a little series on some of the nice fe... |
| For businesses everywhere, 2024 was a wake-up call... |
| Thanks to everyone who joined us for the fifth ann... |
| An IT pro asks for advice on troubleshooting synch... |
| EightKB is back! The biggest online SQL Server int... |
| We're happy to announce that the Call for Papers a... |
| When Covid took out the PASS organization, I had s... |
| Computing in the Cloud (Azure, Google, AWS) |
| Open source AI is accelerating cloud-native innova... |
| Data Mining / Data Analysis |
| Find out more about the importance and processes i... |
| DevOps and Continuous Delivery (CI/CD) |
| Reading Time: 8 minutesIn this post I want to sh... |
| I thought I didn’t care about linting, and latel... |
| How do developers use Studio, our free and open so... |
| If you're a data analyst drowning in Excel, you kn... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| I care about the performance of RavenDB. Enough t... |
| A very common task in creating a database is to st... |
| Performance Tuning SQL Server |
| All About SQL Server Stored Procedures: Local Vari... |
| Don’t Panic! It’s a vague but common complaint... |
| Artificial Intelligence is one of those conundru... |
| I was recently looking into some workloads that ge... |
| PostgreSQL Person of the Week Interview with Emma ... |
| Fujitsu has participated in the PostgreSQL communi... |
| PostgreSQL is the foundation for thousands and tho... |
| Citus is in a small class of the most advanced Pos... |
| Introduction regexp_matches() and ... |
| Someone recently asked on the Postgres mailing lis... |
| Dave Stokes runs two commands: PostgreSQL is equiv... |
| PowerPivot/PowerQuery/PowerBI |
| After years of meaning to learn how to use Excel S... |
| As baby boomers retire, IT teams face a critical k... |
| Discover the top five challenges that disrupt soft... |
| Friction is a force that surrounds everyone all of... |
| When I'm about to lead an in-person workshop, I us... |
| tj-actions/changed-files corrupted to run credenti... |
| Really interesting research: “How WEIRD is Usabl... |
| As cyberattacks grow more sophisticated, organizat... |
| This is serious: A sophisticated cascading supply ... |
| Most apps fail to reach $1,000/month revenue withi... |
| T-SQL and Query Languages |
| I showed how identity columns are a special type o... |
| A bacterial energy storage system is modified to m... |
| HP has previously paid millions for bricking print... |
| A parrot called the budgerigar controls its vocali... |
| At a conference dedicated to energy technology tha... |
| Europe is on the cusp of a new dawn in commercial ... |
| Apple is looking to right the ship after key Siri ... |
| The Information report claims notable losses for A... |
| "I’ve terminated 11 major contracts in less than... |
| Before you apply pending SQL migration scripts, Fl... |
  | 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. |
|
|
