| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| etaoin shrdlu No, I haven't had a stroke. I'm 100% sure this is probably something that comes up every couple of years. I've no doubt that the editorial I'm about to write has been written 20 times by others, but here we go. What the heck is etaoin shrdlu? Well, it's simple. Linotype machines (which I've operated because my uncle owned a newspaper back in the 1970s) used hot lead to set the type for newspaper printing. Because it was using hot lead to make a line of print, there was no such thing as a backspace or delete key. So if you committed the dreadful sin of a typo, you had to finish the line. It became a standard practice to just run your finger down the line of keys on the left side of the Linotype machine which spelled, yeah, you got it, etaoin on the first set of keys and shrdlu on the second. In theory, the proofreader would spot this and eliminate that line from the newspaper (literally toss the lead back into the hopper for tomorrow's edition). Yet, there are thousands of examples of this making it into the paper regardless. I do so love history. It's the stories you see. They're so fun. Anyway, back to the editorial... My question to you, dear reader, is simple. What is our equivalent of etaoin shrdlu? What artifact have we created, or are we actively creating, that the future is going to look back on and simply say, "wut"? Without a doubt we're, somewhere, somehow, running our fingers down the figurative side of our Linotype keyboard and accidently letting it out into the wild. I'd love to hear what you think it is. I have a theory or three, but I'm not sharing them at this time (it's a good idea to greedily hold on to good ideas for future editorials). What have you got? 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 |
| Join Microsoft at PASS Summit 2024 to discover the latest advancements in database technologies. Learn how Azure database solutions power apps in the AI era by enhancing performance, security, and scalability. Connect with peers, hear from Microsoft leaders, and attend expert-led sessions on database modernization and migration. Register today for expert-led sessions and networking opportunities! Use code AZURE150 to get $150 off tickets. |
| AI/Machine Learning/Cognitive Services |
| This story is from The Algorithm, our weekly newsl... |
| More than 120 bills related to regulating artifici... |
| This article is from The Spark, MIT Technology Rev... |
| Artificial Intelligence (AI) is revolutionizing industries across the globe, and the manufacturing sector is no exception. By leveraging AI, manufacturers can enhance efficiency, reduce costs, and improve product quality.... |
| Administration of SQL Server |
| I had an excellent group of people in Gothenburg S... |
| This article will explain Change Management, how D... |
| This article will explain Change Management and how DBAs are involved and can benefit from it. |
| I had an excellent group of people in Gothenburg Sweden when I taught there and I was asked: Can You See Who Forced a Plan? I didn’t know the... |
| Troubleshooting Security Cache Growth In SQL Server (USERSTORE_TOKENPERM And TokenAndPermUserStore) Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... |
| Analysis Services / BI on the MS Stack |
| The post Why CFOs Can’t Afford to Delay BI Adopt... |
| Azure Databricks, Spark and Snowflake |
| The simplest use case to explain why table cloning is helpful is this: Let’s say you have a large table, and you want to test some new process on it, but you don’t want to ruin the data for other processes, so you need a clean copy of your table (or multiple tables) to play with. Coping a large table might take time (Databricks does it very fast, but if it’s a big table it still takes time to copy the data) ,and what happens if you then need to change your code? |
| Used any type of RDBMS before? Then you might find a lot of Snowflake's objects familiar. Despite its cloud-based nature, Snowflake is in essence a relational database system. Which... |
| This week, I want to talk about something we’ve all done at least once – especially before our first cup of coffee in the morning. Yes, that’s right –... |
| Overview Amazon Web Services (AWS) has announced the discontinuation of its Amazon Quantum Ledger Database (QLDB). Their documentation has been updated to indicate that support for QLDB will end on... |
| Career, Employment, and Certifications |
| By focusing directly on skills instead of more sub... |
| SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can create specific and customized queries to extract essential data subsets, making it easier to begin exploring and comprehending the dataset. Additionally, it is important in data transformation because it offers a variety of tools for standardizing, cleaning, and preprocessing data. |
| Gain indispensable data engineering expertise thro... |
| The 2024 Gartner Magic Quadrant positions AWS as a Leader, reflecting our commitment to diverse virtual desktop solutions and operational excellence - driving innovation for remote and hybrid workforces. |
| SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can create specific and customized queries to extract essential data subsets, making it... |
| Azure Logic Apps are a cloud-based service where y... |
| The automated patching feature for SQL Server on Azure VM will be retired on September 17th, 2027. While Automated Patching is being retired, we’re excited to replace it with Azure... |
| "Stories are where memories go when they are for... |
| Computing in the Cloud (Azure, Google, AWS) |
| Cloud computing ETFs provide an easy, diversified ... |
| Conferences, Classes, Events, and Webinars |
| Get ready to meet Microsoft's experts on-site in the exhibit hall and in multiple educational sessions (including a pre-con, keynote and learning pathway). Watch a sneak peek of Microsoft's learning pathway 'Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA' |
| We all make mistakes. I certainly have. I’ll give you a recent one, actually: when we designed the database for SQL ConstantCare®, when we’re storing diagnostic data like wait... |
| Last Year Kendra and I both taught solo precons, and got to talking about how much easier it is to manage large crowds when you have a little helper... |
| I saw a post internally that asked this question: ... |
| Goldilocks and the Three Bears is an oft-invoked metaphor for the situation in which, among a range of options, the target is a zone between “too much” and “too... |
| Database Design, Theory and Development |
| Companies are dealing with more data sources than ... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
| Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems in which well-defined schemas are essential to ensuring data integrity. In MongoDB, you can add documents to a collection that contain different fields or that include the same fields but with different data types or value ranges. You can even add documents that are completely unrelated. As long as you use proper Binary JSON (BSON) formatting, just about anything goes. |
| In the previous article in this series, I introduc... |
| ETL/SSIS/Azure Data Factory/Biml |
| Back in Jun 2024, I announced I was changing the w... |
| Unfortunately, the gotchas continue, as it isn't straight forward when using yet more toolsets to access Always Encrypted data. All easily doable, as long as you make a tweak or two to the normal methods you may be using already. |
| Few data science projects are exempt from the necessity of cleaning data. Data cleaning encompasses the initial steps of preparing data. Its specific purpose is that only the relevant and useful information underlying the data is retained, be it for its posterior analysis, to use as inputs to an AI or machine learning model, and so on. Unifying or converting data types, dealing with missing values, eliminating noisy values stemming from erroneous measurements, and removing duplicates are some examples of typical processes within the data cleaning stage. |
| Explore the new metrics introduced by DAX Optimize... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| In today’s hyper-competitive business environmen... |
| A while back, I published a blogpost explaining how to use Azure LogicApps to automate scaling Microsoft Fabric F capacities under the PAYG (Pay-As-You-Go) licensing option. Some of my... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| This blog outlines why you should be coming to see... |
| Performance Tuning SQL Server |
| This week’s Query Exercise challenged you to fig... |
| Query Plan Patterns For Windowing Functions: Index... |
| Tansu is an Apache Kafka API compatible broker wit... |
| SQL makes sense when it's working on a single row,... |
| This post contains the slides and transcript from ... |
| When we introduced columnar compression for Postgr... |
| Why Solid Queue? Background jobs are used comm... |
| The SQL standard defines a set of rules so that da... |
| As businesses increasingly move toward open-source... |
| Data analysis is all about wrangling massive datas... |
| A key metric when evaluating vector similarity search algorithms is “recall” - which measures the relevancy of the returned search results. Typically better recall means better quality search results,... |
| PowerPivot/PowerQuery/PowerBI |
| Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when you’re a... The... |
| Check out this structured reference guide to just ... |
| DESCRIPTION Over the last few years, many deba... |
| Have you ever wanted to sync two slicers on a report page? Even when both slicers are coming from different dimensions? A lot of users end up setting the... |
| Product Reviews and Articles |
| This article illustrates the importance in any database development project of a 'multi-layered' approach to database access controls and security checks, based on the Principle of Least Privilege. It... |
| How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every... The... |
| Traditionally, IT departments have been viewed as ... |
| Hospitals are particularly vulnerable to ransomware attacks. Marty Momdjian, EVP and General Manager at Semperis, discussed how healthcare organizations can best handle the many difficult issues involved with ransomware.... |
| Jess Nall, a defense attorney specializing in info... |
| This tip introduces some basic text preprocessing ... |
| Wow. It seems they all exploded simultaneously, wh... |
| Despite heightened awareness, security maturity in... |
| Recognizing the value of threat modeling – a pro... |
| AI is revolutionizing cybersecurity by enhancing t... |
| Interesting social engineering attack: luring potential job applicants with fake recruiting pitches, trying to convince them to download malware. From a news article These particular attacks from North Korean state-funded... |
| Threat modeling offers significant benefits such as improved time to market, reduced defects, and reusable security patterns, and is essential for compliance and enhancing overall security strategy. |
| T-SQL and Query Languages |
| Check out this SQL Server stored procedure and fun... |
| Vidhya Arvind, Rajasekhar Ummadisetty, Joey Lynch,... |
| Find out what the impacts of tech sprawl can be an... |
| The latest iteration of Java adds incremental preview capabilities as the open source programming language continues to modernize and improve. |
| Anders sends us an example which isn't precisely a... |
| Some time ago, Roald started an internship on a AS... |
| For this week’s short post I’ve been inspired ... |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| THE VIDEO THE SYNOPSIS In this video, I show off a not-so-well-known capability in Visual Studio Code and Azure Data Studio: creating profiles. LINKS AND ADDITIONAL INFORMATION All of... |
| Virtualization and Containers/Kubernetes |
| In order to get Polyglot Notebooks to work with GitHub Codespaces, you’ll need to match the current requirements of the Polyglot Notebooks extension and its underlying .NET Interactive kernels. |
| The Repair command allows Flyway migrations to recommence on a database, following one or more validation errors. It modifies various details recorded in the schema history table, for applied migrations, to make them consistent with the data and metadata of the current set of Flyway migration files. This article explains what problems Repair can fix and how to run it safely, and a few alternative strategies. |
| 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. |
|
|
