Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers. Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their full content. First, if you are not familiar with T-SQL Tuesday, it is a monthly blog party created […]
This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month’s edition. Each month, a new topic is chosen and published on the first Tuesday of […]
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with near real-time access to the data as it changes in the source systems? Suppose you have […]
With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading
The post SQL Server 2025 Standard Developer Edition appeared first on SQL Server Consulting & Remote DBA Service.
I attended the Microsoft Fabric conference for the first time last week. I wanted to provide a guide that CIOs and CEO’s could leverage to understand how they could utilize these new announcements at the 2025 Fabric Conference to obtain a competitive advantage. To be transparent, I was skeptical because Microsoft consistently changes or rebrands […]
AI analytics today allow us to break down and analyze all parts of a business. Today, we will quickly talk about using a data lake and data pipelines to help streamline data analytics. Every internal and external interaction can be scrutinized and perfected to create a well-oiled, efficient machine. Consumer data, inventory management, market trends, […]
For every company in America, there are thousands of different variables that can positively or negatively affect its finances. Today we will focus on leveraging Decomposition Trees, Anomaly Detection, Key Influencers Charts to turn your data into strategic insights. Labor costs, logistics, customer retention, partnerships and more all affect the day-to-day grind to keep a […]
Securing data access is paramount for organizations of any size. Nobody wants to be the following data security leak that goes viral. Adopting robust authentication methods that enhance security, streamline user experience, and simplify management is crucial for decision-makers. Today, I write about how you could utilize Microsoft Entra ID to improve your database security […]
Are you tired of people complaining about your database’s slow performance? Maybe you are tired of looking at the black box and hoping to find what is slowing your applications down. Hopefully, you are not just turning your server off and back on when people say performance is terrible. Regardless, I want to share a […]
Why Adopting a Modern Data Warehouse Makes Business Sense Most traditional data warehouses are ready for retirement. When they were built a decade or more ago, they were helpful as a mechanism to consolidate data, analyze it, and make business decisions. However, technology moves on, as do businesses, and in modern times, many data warehouses […]