Introducing PASS Summit Charitable Organization Scholarship
To help mark Redgate’s 25th Birthday, the company has launched a new initiative to foster knowledge and skills in the data industry.
2024-08-14
To help mark Redgate’s 25th Birthday, the company has launched a new initiative to foster knowledge and skills in the data industry.
2024-08-14
The goal of this tutorial is to enable ETL developers to obtain practical knowledge to exploit SSIS in transforming and combining data through hands-on exploration to be ready for real-world challenges in managing information.
2024-08-14
When choosing to hire someone, do you want experience or freshness? A few thoughts from someone that had to go through this recently.
2024-08-12
1,411 reads
The speakers and sessions have just been announced for PASS 2024! We’re delighted to share the pre-con schedule for Monday, November 4, and Tuesday, November 5, 2024. Check out the full pre-con line up and the incredible speakers taking part and secure your spot today.
2024-08-12
Let’s see the steps needed to move a dataflow from one workspace to another. For a matter of example, let’s consider the dataflow access a lakehouse on the Dev environment. When copied to the Test environment, the new copy needs to be linked to a new dataflow in the Test environment.
2024-08-12
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
2024-08-09 (first published: 2011-01-12)
46,303 reads
This SQL script allows you to take a number and convert the number to words, and convert a currency value into words.
2024-08-09
Host Louis Davidson meets with Solutions Engineer Huxley Kendell, to chat about his experience in working in the tech industry. Listen in to this episode for discussions including LLMs and AI, Coding and Career paths, all the way to Dungeons and Dragons.
2024-08-09
In this next article, learn about the different file formats and which work well inside your Microsoft Fabric Lakehouse.
2024-08-07
2,926 reads
This is the second part of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. It covered some items to check at the hardware level and configuration items, but this section gets into more detailed hardware auditing details.
2024-08-07
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