| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Outside Interests I'm a little excited because tomorrow I'm going to my first maker's faire. I'll be volunteering with our local radio club (100 year old, W5IAS, oldest radio club in Oklahoma). In addition, I'll be showing off a few controller chips & Raspberry Pis that I use with my radios for APRS, satellite tracking, and digital radio modes, among other things. I'll let people try to make digital contacts with my radios too. I'm also looking forward to seeing what else is on display at the maker's faire. Should be a good time overall. "Oh no," I hear you thinking, "Grant's talking radio again. Can anyone shut him off?" Short answer, no. But, bear with me a minute. My wife is, as near as I can tell, allergic to radios. She's never going to get her license and doesn't care about the darned things at all. Instead, she loves taking art classes. We have a couple of bowls and some mugs she made at pottery class in use in the house. She loves going to the German-American club here in Tulsa to continue getting better at speaking German. We both go to trivia night sometimes at a couple of local bars. In short, in addition to our jobs, we have outside interests. More geeky goodness in my case, art and language in hers (yeah, I know, I married up). Those outside interests do a lot for our mental, emotional, and even physical, health. In addition to engaging the brain so that it remains pliable, we meet with people on a social level. Actual humans, interacting. Plus, I even get outside sometimes to hike around & play Parks on the Air with the radio. All this contributes to better all-round health. Look, you're not getting younger. If you don't have some outside interests, I strongly recommend you find them. It'll help with your emotional and mental well being. Plus, finding the right interest for you, it's just fun. Better health and fun means not only a longer life, but a more fulfilling one. So get on out there & do something (even if it's not radios). 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 |
| Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. The article describes various ways to get the current Flyway schema version from Flyway, and how to get it using SQL, in SQL Server, MySQL, PostgreSQL and SQLite. |
| AI/Machine Learning/Cognitive Services |
| When Chad Syverson loads the US Bureau of Labor St... |
| Looking for an Appy Pie review? Discover what we l... |
| Open-source AI is everywhere right now. The proble... |
| As a lifelong disabled person who constantly copes... |
| Administration of SQL Server |
| Check out this CPU monitoring solution for SQL Ser... |
| This continues my series on auditing SQL Server. T... |
| What if I told you that setting a limit with "max ... |
| Keeping an Always On Availability Group healthy is... |
| Hey what’s up? It’s been a while. If you defin... |
| Like XML, JSON is an open standard storage format ... |
| Learn about three different ways to access and rea... |
| Azure Databricks, Spark and Snowflake |
| In our last post, we talked about some of my favor... |
| This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC capabilities. The examples will be using healthcare type data, but the basic tenets apply in most use cases. |
| A customer was having some trouble getting started... |
| While shrinking a database is typically not advise... |
| My personal experience Dockerizing a Ruby on Rails... |
| AWS CodeBuild now supports macOS, simplifying CI/C... |
| The new AWS Asia Pacific (Malaysia) Region bolster... |
| Here are the resources from my talks today. Best P... |
| Syracuse is having their first SQL Saturday on Sep... |
| Conferences, Classes, Events, and Webinars |
| Now, more than ever, it is essential to have proactive, compliant, and automated monitoring of database estates. Join us in London on September 26th where our experts will demonstrate how Redgate Monitor can improve your estate and proactively detect issues before they impact your business. With morning and afternoon sessions, join for a morning of a technical deep-dive or afternoon of understanding strategic business value when implementing a robust monitoring solution. |
| Data Mining / Data Analysis |
| Honestly, a slow report makes people angry, but a ... |
| If you're a data analyst, you already know that SQ... |
| Going forward, insurance will be based on data and... |
| DESCRIPTION With all the activities and announ... |
| Database Design, Theory and Development |
| Every IT and data team in Financial Services is al... |
| RavenDB has a hidden feature, enabled by default a... |
| Whether pursuing digital transformation, exploring... |
| DevOps and Continuous Delivery (CI/CD) |
| This is my own contribution to the T-SQL Tuesday I... |
| I was privileged to host yet another T-SQL Tuesday... |
| Platform engineering is the latest buzzword in IT ... |
| Research from ESG identifies DevSecOps gaps that o... |
| This article demonstrates how to use the rgclone C... |
| In today’s rapidly evolving business landscape, ... |
| Grafana Labs is powering forward as it tackles the... |
| Qualcomm this morning is taking the wraps off of a... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| Power Query is a powerful tool within the Microsof... |
| Both the Microsoft Fabric lakehouse and warehouse ... |
| Performance Tuning SQL Server |
| Yeah, stupid long title. It’s a question I put t... |
| This article explores how raising the Cost Thresho... |
| A Little About Computed Columns, Filtered Indexes,... |
| There are four major components to being a good be... |
| The PostgreSQL Development Conference 2024 was hel... |
| Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only as a means to increase performance on large tables. While it’s certainly useful for this, it’s also an invaluable tool for solving common data maintenance problems. In this article, we’ll examine the feature from this perspective. |
| Revenue dropped 10% year-over-year, and Cisco's br... |
| The automaker has been developing in-car software... |
| UPDATED Aug. 17, 2024 — As COVID-19 drove everyo... |
| Navigating the evolving tech job market demands th... |
| In this digital age, where data is an increasingly... |
| This infographic explores changes in the IT indust... |
| This article includes several links to key SQL Ser... |
| Cyber incidents like this highlight the need for t... |
| This is yet another insecure Internet-of-things st... |
| In this post, we share the strategies and techniqu... |
| There is a photo of my daughter that I love. She i... |
| This story is from The Algorithm, our weekly newsl... |
| This article is from The Spark, MIT Technology Rev... |
| This is today’s edition of The Download, our w... |
| This article first appeared in The Checkup, MIT T... |
| From compact chargers and action cameras to noise-... |
| Today's anonymous submitter found some Java code w... |
| This site will let you take a selfie with a New York City traffic surveillance camera. |
| The Repair command allows Flyway migrations to rec... |
| 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. |
|
|
