SQL Server Data Mining Programmability
Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.
2009-04-24
2,532 reads
Articles
Creating a Publication - SQL School Video
This SQL School video looks at how you add a publication to a replication scenario.
2009-04-23
3,583 reads
Displaying a Pop-up message in SSRS 2005
Validates user parameter and displays a pop-up message to the user and handles users response.
2009-04-23
16,165 reads
SQL Lunch with the Baton Rouge Area SQL Users Group
Every other Monday is a lunch for the SQL Server group in Baton Rouge. If you live nearby, or are in the area, plan on attending.
2009-04-23
305 reads
Auditing in SQL Server 2008
This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.
2009-04-23
2,372 reads
Key column of a dimension in SSAS
When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...
2009-04-23
2,629 reads
Using The File System Task in SQL Server 2008 Integration Services
This article examines the File System Task which can perform numerous operations on files and directories such as create, move, delete, and also to set the attributes of files and folders.
2009-04-23
2,718 reads
SCOME - Setting Up Your Remote Servers - Part 2
Continuing with his series on how to centrally monitor your SQL Servers, Drew Salem looks at how to set up remote servers.
2009-04-22
6,310 reads
Getting the SSIS package store to work with a SQL Server named instance
We have a named SQL instance and I am able to connect to the instance, but when I try to view the SSIS packages stored in the MSDB database I get an error. This does not happen with our default instances. Is there an additional setting that must be changed to get this to work?
2009-04-22
2,714 reads
Interfaces
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
2009-04-22
704 reads
Blogs
macOS Tahoe breaks SQL Server on Docker containers on Apple silicon
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
From Firefighting to Future‑Building: SQL Server 2025 and the New DataOps Mindset
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
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
Forums
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Question of the Day
Who am I?
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