Ownership chaining in SQL Server 2005
Ownership chains have unique permissions' issues in SQL Server 2005. Contributor Serdar Yegulalp explains the access levels of ownership chains, and the benefits of "EXECUTE AS."
SQL Server Spotlight on Craig Freedman
Our look at the SQL Server development team continues with Craig Freedman, query tuning expert working on partitioning features. Read a little about a talented software engineer that has been developing database software for over a decade.
The Big Three
Come to the PASS Summit this year and see three of the big influences on SQL Server: Steve Ballmer, Paul Flessner, and Dave Campbell. They're all giving keynotes. And did I mention SQLServerCentral.com is giving away an XBOX 360? Read more about it.
File Watcher Task
The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.
Deploying Scripts To Multiple Instances
Most DBAs manage multiple SQL servers, each handling different needs for your business. Even with the diverse uses for different servers, there is often the need to deploy the same scripts to all servers for various purposes. Author Joe Doherty brings us his scripts and technique for executing a script across multiple servers.
Using SQL Server 2005 Database Snapshots
In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.
Upload multiple files to VarBinary column in SQL Server 2005
This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.
Using Transactions in SSIS
In SSIS demostration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.
Database Snapshots
In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005.
Using the For Each ADO Enumerator
In this video, you'll learn how to use the For Each ADO enumerator in SSIS to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client dynamically.
Blogs
T-SQL Tuesday #193 - Notes to Self
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Forums
What is the PRODUCT
Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers