| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Be Prepared I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people. It also inspired me to do another check on our emergency supplies and equipment. No, we don't have some secret bunker to which we're going to retreat when the zombiepocalypse finally hits. But history has shown that it's not crazy to have a few extra bits set aside. Food & water of course, some kind of shelter, flashlight, some batteries for that and maybe a spare phone charger, first aid of course, all worth having on hand. Also, put it all in one place so you can find it quickly. It's not a bad idea to introduce yourself to the neighbors so you can check on them, and they can check on you in an emergency. Finally, if you add equipment to your stash, water purifier or a fire starter, or, like me, a radio or two, be sure you've practiced using that equipment so you know how. When bad things happen, you're the first person on the spot, so, may as well be as ready as you can be. The last few years have shown, a little preparation is a good thing. The Scout Motto is pretty simple but says it all: Be Prepared. 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. |
AI/Machine Learning/Cognitive Services |
This story originally appeared in The Algorithm, o... |
Find out the similarities and differences that exist between neural networks and deep learning and their role in modern AI. The post Neural Networks vs. Deep Learning appeared first on... |
The emergence of large language models (LLMs) has ushered in a new era of generative AI tools with unprecedented capabilities. These powerful models, such as ChatGPT and others, possess... |
Increased integration of AI into software applications and cloud environments will make monitoring and observability even more difficult. Here's why. |
Administration of SQL Server |
Providing a comprehensive understanding of their r... |
I was working on a query this week that reminded m... |
In this article, we look at different approaches f... |
Understanding how to retrieve column names from a ... |
I had a client that was struggling with some encry... |
Background In SQL Server/Azure SQL, database-level... |
The article is published here on the Azure SQL Blo... |
In my last couple of blog posts (here and here) I ... |
Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. In this blog post, we will explore key tasks and areas... |
Let us see a script that will help check if a Column Exists in a Table. One of the common tasks that developers deal with when working on database-related projects First... |
This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth. First appeared on SQL SERVER – Techniques for Retrieving... |
Analysis Services / BI on the MS Stack |
I have a client who was upgrading some servers fro... |
In this article, we look at how to query multiple ... |
Azure SQL Managed Instance |
In the previous installment of this mini-series, we covered basic scenarios involving private endpoints. If you aren’t familiar with private endpoints and Private Link in general, it might be... |
HashiCorp has changed the licensing of its widely ... |
In a few days, I will board a plane towards the so... |
As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts... |
Computing in the Cloud (Azure, Google, AWS) |
The more mature your cloud strategy, the more complex cloud cost management becomes. Here's how to manage mature cloud strategies cost-effectively. |
In today’s world, a single-environment approach to IT is no longer supporting the needs of modern businesses. According to my company’s fifth annual Enterprise Cloud Index (ECI), organizations today, and moving... |
This video tutorial explains how you can use Power... |
Introduction You know that feeling when you have y... |
The PowerShell Get-MessageTrace command can help O... |
Data Mining / Data Analysis |
I've written many articles about bootstrapping in ... |
SAS SVP Kimberly May announces the launch of the n... |
The Wharton School of Management reports that only... |
Database Design, Theory and Development |
Follow the journey of Mirazon, a managed service p... |
In the age of abundant information, companies face... |
Poor data quality is one of the most challenging h... |
DevOps and Continuous Delivery (CI/CD) |
This article will demonstrate how to automate a hy... |
Agile development has grown in popularity in recent years due to its success in delivering software on time and on budget. If you’re looking for a way to make... |
Looking beyond the racetrack, NASCAR has users and employees who are always on the move and need access to IT operations. |
ETL/SSIS/Azure Data Factory/Biml |
A collection of facts from which inferences can be... |
I regularly help customers migrate SSIS to Azure-SSIS integration runtimes, a nifty component of Azure Data Factory. I was recently stumped by an error activating TaskFactory (Task Factory for... |
I spoke with an expert panel about the advantages of data mesh, which is a decentralized data architecture that organizes data by specific business domain. Among other advantages, data... |
Imagine if you asked a large language model to write a fantasy story about a girl who wanders into a magical forest and meets a pirate with the same... |
Video by: Reid HavensLearn how to leverage model t... |
THE VIDEO THE SYNOPSIS In this video, we walk thro... |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Answer: No But, lets prepare for it in terms of th... |
It has been quiet for a few weeks due to summer br... |
I have been working as a no-code data engineer: Fo... |
IntroductionOne integral part of modern Continuous... |
Sometimes you need python libraries that aren't pr... |
Oracle/PostgreSQL/MySQL/other RDBMS |
Load balancing is a critical component of high availability clusters that optimises performance, scalability, and fault tolerance. |
While there are many features within PostgreSQL th... |
Not quite two years ago I had the privilege to giv... |
Performance Tuning SQL Server |
In this article, we look at how SQL Server may not... |
I was looking into reducing the allocation in a particular part of our code, and I ran into what was basically the following code (boiled down to the essentials): As... |
Away Days It’s August, and that means one thing: Family Vacation. I’m taking this month off from regular blogging, and posting some of my paid beginner training content for... |
PowerPivot/PowerQuery/PowerBI |
Set up activity-based timeout for Power BI in the ... |
Following on in my series, in this blog post I am ... |
Reading Time: 8 minutes In this post I to share m... |
As you make more measures in your Power BI Dataset, it can get hard to find the one you need. Sure you can use search... But you can also... |
Fabric content is all over the place by now. In Fabric, as a SaaS platform, most (if not all) services have interconnectivity. In a few clicks you connect your... |
Robotic process automation software is automating ... |
There is a relatively simple and quickly learned t... |
Here's how to best work with AI matching systems o... |
Asked to picture an entrepreneur, most people will... |
This is today’s edition of The Download, our w... |
These best practices will smooth the integration of IT consultants with existing IT teams by building a culture of trust and respect. |
This guide explains VPN installation and configura... |
This guide offers explanations and examples for important Linux commands. You will learn each command’s capabilities and practical use cases. |
The carmaker also reported it's taken legal action... |
The world of online misdeeds is an eerie biome, cr... |
The Defense Department must modernize user activit... |
Spin.AI's risk assessment of some 300,000 browser ... |
Risk-aware leaders can be a cybersecurity advantag... |
T-SQL and Query Languages |
SQL Server’s T-SQL query language has a plethora... |
Moving quickly and carefully in two layers of glov... |
Venice, Italy, is suffering from a combination of ... |
Inspired by a technology developed thousands of ye... |
From “The Troubled Hunt for the Ultimate Cell”... |
Somewhere above you right now, a plane is broadcas... |
By day, Evan Kramer, SM ’22, works on his PhD in... |
Virtualization and Containers/Kubernetes |
At its VMware Explore conference, the company intr... |
Probes are tiny processes which run inside contain... |
This email has been sent to {email}. 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. |
|
|