Iteration and Conditional Activities in Azure Data Factory
Learn about the different iterator activities in Azure Data Factory.
2024-08-23 (first published: 2021-10-22)
8,958 reads
Learn about the different iterator activities in Azure Data Factory.
2024-08-23 (first published: 2021-10-22)
8,958 reads
Not many data professionals get a personal Learning and Development (L&D) budget that we can use at our discretion. This is something I encourage you to negotiate when you are considering a job or at your annual review. We all need to learn and a budget signifies your boss cares about you.
2024-08-23
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
2024-08-23
In this next installment, John performs the research you might do if your management asked you to examine Fabric.
2024-08-21
3,327 reads
This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.
2024-08-21
Lean how to implement linear regression in SQL Server by running Python code on your data in SQL Server using Machine Learning Services.
2024-08-19
3,336 reads
This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.
2024-08-19
Learn how you can recover a database that is in suspect mode.
2024-08-16
5,571 reads
What are the challenges to implementing a successful test data management strategy? In our recent webinar ‘Harnessing the Power of Test Data Management: Strategies for Success’, Redgate’s Steve Jones was joined by Hamish Watson (DevOps Consultant) and Daniel Watkins (Director/Principal Consultant) to talk all things TDM and how to implement it efficiently and effectively. Here are 10 key tips and takeaways from their conversation in a short blog post.
2024-08-16
I’m not the first person to write about cleaning up unused or redundant indexes.
2024-08-16
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers