| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Play To Your Strengths I really enjoy playing with radios [ed: we know, you won't shut up about it]. Something as simple as checking in to a local net (basically saying hi to a bunch of people on the radio) is fun. However, there's so much more to it. In the last few weeks I've been testing a new digital mode (M17), texting over the radio (andFlMsg), and sending lots of emails on the radio (Winlink). I've also been experimenting with mesh networks (LoRa). Fact is, after 35+ years in IT, constantly learning new stuff, I kind of can't stop learning new stuff. I can't decide if it's a problem or a reward [ed: it's a problem for us because you can't keep quiet about it]. I do sometimes wish I'd taken a different turn though. I have some friends who have chosen to climb the corporate ladder rather than just stay technologists. Sometimes, not often at all, I get a little jealous when I see the great things they've accomplished. But, I long ago realized that I'm good at figuring out coding problems, data problems, problems on machines, but horrible at figuring out people problems. Overall, I'm pretty gleeful to just be a technologist [ed: a noisy one]. My thoughts for today are simple. Play to your strengths. Sure, work on your weaknesses, but play to your strengths. You'll do better and be happier. At least, that's been my experience. What do you think? 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 |
| Phil Factor demonstrates why we occasionally need to 'baseline' a database, when automating database deployments with Flyway, and a simple way of reducing the number of migration files that are required for a build. |
| Robert Sheldon helps you get started with Flyway Desktop by walking you through the process of creating a Flyway Desktop project for an existing database. It covers the basics of building a schema model, generating and running migration scripts, and saving changes to source control. |
| This article will demonstrate how to automate a hybrid database change management system that uses Entity Framework Code First for development and Flyway for deployments. We automatically convert C# migrations, produced by EF, to the Flyway format and then use Flyway command line to deploy the migrations and save the 'object-level state' of each new database version, so we can track exactly which objects changed, and how, between versions. |
| AI/Machine Learning/Cognitive Services |
| Humans are considered the weakest link in the ente... |
| The latest IBM Global AI Adoption Index suggests t... |
| In the past year or so, generative AI has received more media attention than any other type of technology. Up until this point, data science has been at the... |
| Administration of SQL Server |
| Learn how to use dynamic data masking in SQL Serve... |
| Introduction These are my SQL Server Diagnostic In... |
| This article covers all the steps to install SQL S... |
| In this tip, we walk through the steps of how to b... |
| Introduction On January 10, 2024, Microsoft releas... |
| The 11th cumulative update release for SQL Server ... |
| In scenarios where direct Linked Server connection... |
| I don’t think I’ve ever had a great impression... |
| In the dynamic world of database management, we en... |
| In certain service requests, our customers encount... |
| In an era where data management transcends individ... |
| Check out this episode to learn the newest information on security for Azure SQL and SQL Server! Watch on Data Exposed View/share our latest episodes on Microsoft Learn and YouTube! |
| Azure SQL Managed Instance |
| We worked on a service request that our customer e... |
| Today we are announcing that Amazon Elastic Contai... |
| Computing in the Cloud (Azure, Google, AWS) |
| The business landscape has undergone a transformat... |
| Here's how businesses can use the cloud to achieve a competitive advantage amid uncertainty. |
| PowerShell users can enhance their scripting skills by learning these techniques for creating and modifying text files. |
| Data Mining / Data Analysis |
| An unobserved category is one that does not appear... |
| Where can you meet an iconic Silicon Valley report... |
| In a previous article, I presented some of the mos... |
| Electrolyte drinks (think Gatorade and Powerade) h... |
| As data science professionals, we are often viewed as people who draw conclusions based only on data and minimize other factors. This perception usually becomes contentious when the insights and... |
| Database Design, Theory and Development |
| Hello! I’m Mark Horseman, and welcome to The Coo... |
| I was worried about some of my data, so I wanted t... |
| The digital age in which we live demands consisten... |
| One of the most frequent operations we make in RavenDB is getting a page pointer. That is the basis of pretty much everything that you can think of inside... |
| DevOps and Continuous Delivery (CI/CD) |
| ITPro Today's most read stories about DevOps explo... |
| This article describes how we implemented lightwei... |
| Azure Load Testing now supports creating load test... |
| ETL/SSIS/Azure Data Factory/Biml |
| THE VIDEO THE SYNOPSIS In this video, we bang our ... |
| As part of the final segment of Intel’s "Intel C... |
| Welcome back to the fourth installment of our blog... |
| The Internet of Things (IoT) has rapidly redefined... |
| Until coming across this piece of code, I often us... |
| DESCRIPTION DAX Optimizer is a tool that perfo... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| In my last post titled Fabric: Load Data from a CS... |
| I was working on a blog post to determine which co... |
| A while ago I had a little blog post series about�... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| Protecting and controlling access to your data against unauthorized person(s) is crucial in any organization. Unauthorized entry or modification of your data can lead to severe and sometimes irreversible damage. |
| Performance Tuning SQL Server |
| This is part twenty-seven of the plansplaining ser... |
| Giveaway I’ve been doing a lot of work on all of... |
| Make Things Fast Our very lofty goal as query tuners is to make the time from request to result shorter. Sometimes that requires a bit of sacrifice on the... |
| PowerPivot/PowerQuery/PowerBI |
| A few years ago a new pair of Profiler events was ... |
| A couple of weeks ago, I encountered a DAX questio... |
| How making and sharing mistakes can supercharge yo... |
| This month’s invitation from Reitse asks us to... |
| This is the 8th year now that we’ve been running... |
| So what did I learn? I think a better question is,... |
| It’s T-SQL Tuesday again! In fact, it’s the fi... |
| Steven Sanderson groups by month and year: Taming ... |
| Organizations of all types and sizes are turning to the cloud for their application and data storage requirements. The cloud makes it possible for them to deploy their workloads more quickly and to scale them up and down as requirements change. |
| Identity and Access Management (IAM), is a crucial... |
| Canada is partnering with SecurityScorecard to strengthen critical infrastructure cybersecurity. |
| One of jOOQ’s key features so far has always bee... |
| Software optimization refers to the process of improving the performance, efficiency, and resource utilization of a software application. It involves making changes to the code, algorithms, or system configurations... |
| Here are the best strategies for reducing performance debt in software development, and when to implement them for maximum effectiveness. |
| T-SQL and Query Languages |
| I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example. |
| Sometimes you have to abandon the game plan. A foo... |
| This story first appeared in China Report, MIT Tec... |
| Former contract workers at the language app say they were cut as the company uses more AI tools to create lessons. |
| In 2024, expect a retreat from cloud-native and outsourced development, as well as fewer developer jobs but more software security problems. |
| Tech layoffs may be back with Amazon, Twitch, Unity, and Duolingo job cuts. |
| This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. Enhanced geothermal systems: 10 Breakthrough Technologies 2024... |
| New law journal article: Smart Device Manufacturer Liability and Redress for Third-Party Cyberattack Victims Abstract: Smart devices are used to facilitate cyberattacks against both their users and third parties. While users... |
| With Azure Load Testing, you can now measure respo... |
| 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. |
|
|
