SQL Server 2005 – DML Usage on an untyped XML column
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
2006-09-18
1,895 reads
Additional Articles
Using and Monitoring SQL 2005 Query Notification
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
2006-09-15
2,087 reads
Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Se
This article discusses: Extensibility in SQL Server 2005 Reporting Services, Creating and debugging custom report items, The ProgressTracker CRI sample.
2006-09-13
2,458 reads
Speak Like a T-SQL Developer
In this video by Kathi Kellenberger, she starts beginners interested in T-SQL programming the teminology and some of the basiics of T-SQL. She also covers the what the various editions of SQL Server mean and the tools that you will use.
2006-09-12
3,036 reads
SQL Server 2005 Integration Services - Message Queue Task - Part 32
After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, part 32 of this series focuses on individual components that have more specialized, but very useful characteristics, starting by discussing the Message Queue Control Flow task, and following with coverage of a number of Data Flow transformations.
2006-09-11
1,581 reads
Copying Database Backups to an Alternative Location
Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.
2006-09-08
4,926 reads
SQL Server 2005 Common Table Expressions
A CTE is a "temporary result set" that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement that was previously only available through use of functions, temp tables, cursors, and so on.
2006-09-07
2,652 reads
Improving Data Security by Using SQL Server 2005
Microsoft IT developed strategies to reduce the duplication of sensitive data and improve the security of personally identifiable information in the Microsoft IT LOB application space. These strategies are based on the new security features and functionalities that Microsoft® SQL Server™ 2005 includes.
2006-09-05
2,039 reads
Top 10 Enhancements in SQL 2005 Notification Services
In this article, we examine some of the best new features and characteristics available in the 2005 version.
2006-09-04
1,994 reads
Save and Retrieve Datasheet Layout with the Windows Registry
Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.
2006-09-01
2,257 reads
Blogs
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...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers