In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is ...
2009-04-27
8,030 reads
Follow a detailed walkthrough of using the Web Service Task to connect to a web service and return an XML result.
2009-04-27
2,488 reads
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-26
877 reads
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-26
604 reads
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-26
644 reads
Longtime author and SQL Server guru David Poole takes a look at a classic book about Data Warehousing.
2009-04-24
2,327 reads
Monitoring your servers centrally requires a good reporting system. Drew Salem continues with his SCOME journey to tame servers with the building of a job report in this article.
2009-04-24
7,525 reads
I happen to notice this in a class recently that I had the rare student - one that could take notes that seemed to have value to them the next day. If you watch people take notes, I think they fall into one of these categories: The Highlighter. They have...
2009-04-24
1,989 reads
This week Steve Jones discusses ethics and leadership in IT.
2009-04-24
1,005 reads
This week Steve Jones discusses ethics and leadership in IT.
2009-04-24
766 reads
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
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...
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)
END See possible answers