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,588 reads
Articles
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,192 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
308 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,315 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
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
887 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers