Fall Book Sale
We're blowing out inventory again to make room for new books. Stock up your SQL Server library with a few of our titles.
XML Argument Protocols for SQL 2005 Stored Procedures
SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.
SQL Server 2005 Integration Services - Lookup Transformation - Part 33
Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, this installment focuses on the Lookup transformation.
Integrating Database Snapshots into Integration Services
Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
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.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers