Ethics and Leaders - Database Weekly (Apr 27, 2009)
This week Steve Jones discusses ethics and leadership in IT.
2009-04-24
1,005 reads
Articles
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
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
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,206 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
310 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
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers