| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| The Leaves Are Changing, But Why? I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors... WAIT! Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry recently. Those trees are changing color because they just don't have enough water. They're turning brown a little prematurely. After all, it's still effectively summer here in Oklahoma (101 degrees two days ago, 38.3 for the rest of the world). We make assumptions based on observations. However, sometimes, even though we're accurate in our observations, we're not so accurate in our assumptions. When it comes to technology, we really do need to focus on ensuring that we know the true root cause of issues rather than make assumptions based on incomplete data. Get a complete picture before you start making changes to systems. Otherwise, you really could create more problems than you fix. The trees are still pretty though. 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 |
How to use Flyway configuration files to minimize typing during ad-hoc development from PowerShell or DOS; you just type in the Flyway commands you need and hit "go" and the config files take care of all the tiresome connection, authentication and project details. |
AI/Machine Learning/Cognitive Services |
As artificial intelligence grows increasingly powe... |
Administration of SQL Server |
In this article we look at T-SQL code you can use ... |
Using a local service account for your SQL Server ... |
Last month I had you create a security standards d... |
Server roles for Azure SQL Database Server: Databa... |
Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on the SQL version you’re using, but... |
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works. |
Analysis Services / BI on the MS Stack |
In my video today, I continue to build out my Powe... |
Azure Databricks, Spark and Snowflake |
With rising demands from the ever-changing busines... |
Microsoft provides many ways to run SQL Server in ... |
Server roles for Azure SQL Database: Database Mana... |
Microsoft Azure offers many PAAS services for addressing the database requirements based on the nature of data and transaction workload. Azure SQL Database is one of the popular PAAS... |
Data hosted in data repositories is accessed by a variety of applications. When data repositories are migrated from one hosting platform to another or when the load on a data repository increases, typically replication is adopted as an interim or a long-term solution approach. |
Randy Bean’s book, “Fail Fast, Learn Faster”... |
We host a lot of events at Redgate, from Summits to webinars, podcasts to panel discussions. Guest speakers like Donovan Brown from Microsoft, Tony Madonna from BMW, and Chris... |
Computing in the Cloud (Azure, Google, AWS) |
What is Power Automate? Like other no-code automat... |
Conferences, Classes, Events, and Webinars |
Join Grant Fritchey and database professionals from WestJet, Fiducia Gad and Richemont to learn how effective estate monitoring enables them to manage continually evolving environments, and intensifying data demands. |
Donovan Brown and Mark Fussell, Program Managers from the Azure CTO Incubations team at Microsoft, join Steve Jones to talk all things modern Cloud Native development with Dapr. |
Introduction It is important for many development jobs to be able to look at the differences between PowerShell objects. It might be that you are checking how Windows processes... |
Introduction Slowly Changing Dimensions in Data Warehouse is an important concept that is used to enable the historic aspect of data in an analytical system. As you know, the... |
DevOps and Continuous Delivery (CI/CD) |
Communities of practice bring people together to share ideas and learn from each other about a common interest. In this article, Robert Sheldon explains and gives some advice on starting them. |
Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new features. |
Performance Tuning SQL Server |
In this article we look at how to find NOLOCK usag... |
This article will mention in which conditions the ... |
Implicit conversion occurs when SQL Server needs t... |
One Metric Week This went on a bit longer than I thought it would, but to someone who tries to blog five days a week, that’s a good thing. While this... |
PowerPivot/PowerQuery/PowerBI |
Check out how using Small Multiples in Power BI ca... |
In this article, we are going to learn about the m... |
Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate. |
It's critically important that businesses have con... |
Juniper’s case is “a perfect example of the da... |
The volume of traffic harnessed by attackers has g... |
Aaron Bertrand (@AaronBertrand) explores some comm... |
SpaceX: Amazon should fix Kuiper satellite plan in... |
Businesses around the world are signaling that i... |
A relatively cheap, simple way to give the ARM ver... |
NASA’s Perseverance rover has successfully gathered a bit of rock and soil from Mars, which marks the first time a sample has ever been recovered on the planet. What... |
"The most misleading statement today was Virgin Ga... |
In an era defined by a growing need for super-fast... |
"We're done. They're all sold." |
Virtualization and Containers/Kubernetes |
It is important to ensure that your Azure Virtual ... |
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. |
|
|