| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Learning New Technology Is Challenging On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit major snags getting these chips to communicate with my computer. I was setting up a old laptop with Linux to see if that works better when I hit a breakthrough. I finally was able to see the controller through software. Now I just have to figure out how to get a bootloader on the darned thing and I think I'll be off and running. The issue is, the documentation out there on these STM32 chips is... poor (trying to be kind). It's not that things are not well documented, they are. However, they're documented by people with a large amount of existing knowledge of electronics, mostly for people with an equally large amount of knowledge of electronics. Yeah, I've been working with computers for over 30 years, and playing on game systems since the original Pong, but I'm not an electronics expert, at all, in any sense. In fact, I'm still struggling with a lot of the basics. Something to think about when you're setting your training, whether in-house, inter-team, or external, is who your audience is. If you're teaching something introductory, you may need to assume zero knowledge on the part of the people you're trying to teach. And if they have to have other knowledge first, you're going to need to find that or make it so you can provide it. The last thing you want to do is leave people in a lurch where they want to learn what you are teaching, but just can't. Granted, some topics really do require a ton of prior knowledge and sometimes, people just won't be able to learn without that prior knowledge. Now, to see if I can get that bootloader on the controller. Fingers crossed! 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 |
| Sometimes we want to check whether it is possible to run a Flyway migration without error, but not actually make the changes. We might just need to 'sanity test' the performance of a migration on the Staging server, for example. By using a placeholder 'switch' to trigger a SQL Exception, we can get Flyway to roll-back its transaction, and therefore the migration, on demand. |
| AI/Machine Learning/Cognitive Services |
| To receive The Algorithm in your inbox every Monda... |
| DeepMind has used its board-game playing AI AlphaZ... |
| The last five years have seen large innovations th... |
| Deep learning has become something of a catchphras... |
| I Was There When is an oral history project that�... |
| A new AI system can create natural-sounding speech and music after being prompted with a few seconds of audio. AudioLM, developed by Google researchers, generates audio that fits the... |
| Administration of SQL Server |
| Scary Scalar Functions series overview Part One: P... |
| Good day reader. This post is coming to you from... |
| Can you name each of the system databases in SQL S... |
| Adding trace flags sql server startup |
| Learn how to consume multiple API calls to load da... |
| Learn how to build time series data models in SQL ... |
| This article explores different SQL Commands (func... |
| Analysis Services / BI on the MS Stack |
| How does the VertiPaq storage engine communicate w... |
| Shape your query plans without changing the code. |
| Our customer, using, for example, SQL SERVER Manag... |
| You know Azure SQL Database has the features you n... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
| This comprehensive five-part explainer introduces ... |
| As threat actors' sophistication has grown dramati... |
| I was reminded this week that I needed to get regi... |
| The infosec conference named after the UK's callin... |
| Computing in the Cloud (Azure, Google, AWS) |
| This post is part of our Week in Review series. Ch... |
| Azure Firewall Basic provides cost-effective, ente... |
| Should your organization deploy a cloud-based disa... |
| Much has been said about the mass migration toward... |
| The Azure Command-Line Interface (CLI) is a cross-... |
| We recently released v19.2 of SqlPackage, a v161-p... |
| Conferences, Classes, Events, and Webinars |
| PASS Data Community Summit 2022 takes place from 15-18 November online and in-person in Seattle. Register today to unlock access to over 300 world-class sessions and speakers. Join thousands of liked-minded data professionals at the year's largest hybrid data platform conference and get inspired by other experts facing the same challenges you are. |
| Don't miss the fantastic all-day sessions happening at PASS Data Community Summit... |
| It has been announced that Kimberly Tripp will deliver... |
| The Prompt In July, Brent Ozar (blog | twitter) as... |
| SQL Server professionals may be reluctant to st... |
| Are you running the latest version of PowerShell? ... |
| Words: 567 Time to read: ~ 3 minutes Skip This for... |
| Data Mining / Data Analysis |
| Have you ever typed your credit card into an onlin... |
| Data Privacy, Compliance, and Governance |
| The rise of data lakes and adjacent patterns such ... |
| The UK's new culture secretary decries "red tape,"... |
| Database Design, Theory and Development |
| Servers constitute the pillar of companies, especi... |
| DevOps and Continuous Delivery (CI/CD) |
| Reading Time: 4 minutes In this post I want to co... |
| In a few weeks at the PASS Data Community Summit, ... |
| This article covers the essential roles DevOps pla... |
| This series of articles describes a path you can t... |
| IT operations teams play a leading role in helping... |
| New features include the ability to establish even... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| In this article, we will learn how to query the da... |
| In the previous article in this series, I introduc... |
| As a part of my own journey of learning within Pos... |
| Performance Tuning SQL Server |
| When writing T-SQL, a lot of developers use either... |
| Recently I was looking through DBA.StackExchange w... |
| A HADR_SYNC_COMMIT wait occurs when the session is... |
| Willfully While I do enjoy answering questions ab... |
| PowerPivot/PowerQuery/PowerBI |
| Power BI is not only a solution for small datasets... |
| We thought everyone knew about this Power Query ca... |
| In this post I just wanted to show the ability to ... |
| Workplace norms have gone through a revolution, an... |
| Is your company hiring for a database position as ... |
| Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement. |
| SQL Server Security and Auditing |
| Using the SQL Server user roles and permissions qu... |
| What you have access to is not just what you have ... |
| Microsoft cybersecurity executive John Hewie expla... |
| The malware-as-a-service group Eternity is selling... |
| This is the first of two articles to describe the ... |
| The trend, spotted by Consumer Reports, could mean... |
| Today, the processing of mountain-high stacks of alarms is considered "security." That system is failing customers and the cybersecurity workforce. |
| T-SQL and Query Languages |
| In this article, we look at how to calculate the r... |
| In this article, we look at various aspects of cre... |
| Before data can be read from of a SQL Server datab... |
| I’ve been doing a lot of work with SQL Server 20... |
| Apologies for the late invitation. A minor snafu h... |
| I have just completed a course in our SQL Queries ... |
| Almost six months since an official update from Ra... |
| As a lightweight operating system, the entire Ubun... |
| All laptops sold in Europe will have to support US... |
| Welcome back! Hope you are not stuck in highway tr... |
| Maker and developer Balthazar Rouberol is using a ... |
| Power beaming has long been a dream of engineers a... |
| AMD pre-announced that it would miss its revenue t... |
| I spoke with Anil Cheriyan, CTO, Executive VP, Str... |
| Last week, we were thrilled to host Advancing Acad... |
| Microsoft discusses the implications of toggling o... |
| This Week in IT, Intel Unison promises to bring an... |
| 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. |
|
|
