Getting Data Out of an Audit Table: Answers & Discussion
In last week’s post, I gave you a trigger that populated a history table with all changes to […]
Archives de l’année : 2024
SQL Server Always On Availability group on AKS with DH2i’s ...
Did you know you can do a quickfire deployment of SQL Server Always On Availability Groups on Azure […]
Combining Silver Tables into a Model – Data Engineering with ...
Data Presentation Layer Microsoft Fabric allows the developer to create delta tables in the lake house. The bronze […]
Why Generative AI Scares the Hell Out of DBAs
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age […]
T-SQL Tuesday #174: Your Favorite Job Interview Question?
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for […]
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, […]
Read Data Stored in a Lake Database using Azure Synapse ...
The post Read Data Stored in a Lake Database using Azure Synapse Analytics appeared first on SQLServerCentral.
Using Machine Learning Pipeline Execution Activity in Azure Data Factory
Introduction The Azure Machine Learning (AML) Python SDK v2 is an updated Python SDK package. It helps to […]
Identifying Customer Buying Pattern in Power BI – Part 2
In our previous article, Identifying Customer Buying Patterns in Power BI—Part 1, we described the customer purchase product […]
SQL Server Networking troubleshooting documentation expanded
The SQL Server CSS (technical support) and Content teams have been publishing documentation on troubleshooting SQL Server networking […]
I’m Getting Antsy for SQL Server vNext.
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: […]
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column […]
SQL Server Filtered Index Essentials Guide
The post SQL Server Filtered Index Essentials Guide appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long […]