XML Workshop V - Reading Values from XML Columns
Continuing on with his series on XML in SQL Server 2005, Jacob Sebastian brings us more examples on how to delve into the values of XML data.
Developer Spotlight: Greg Low
Builder AU interviewed Greg via e-mail before the start of Tech.Ed 06 to talk about beta software, free databases, and the future of database development.
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 5
Part 5 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to create databases.
Accessing .NET assemblies with SSIS
SQL Server Integration Services has changed the ETL process dramatically with many new capabilities. It's extensibility is unmatched, allowing you to build workflows that were not possible in DTS. Dinesh Priyankara brings us a useful new technique for referencing your .NET assemblies from within SSIS to take advantage of code reuse.
How to Insert Values into an Identity Column in SQL Server
Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It's actually very easy to do.
How to link different data sources together
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
An Auditing Solution with XML And XSL
Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.
Raffle Winners and a Thank You
Here are the winners of our raffle and we should be sending out prizes soon. A thanks as well from Katie's father to all of you.
Accessing and Updating Data in ASP.NET 2.0: Data Source Control Basics
This article explores the concepts and advantages of data source controls, and compares their usage in ASP.NET 2.0 to data access techniques in ASP.NET 1.x.
Close These Loopholes in Your Database Testing
Alex Kuznetsov starts off a series of three articles on 'Unit Testing' your database development work. He begins by describing five simple rules that make all the difference.
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Inspection And Auditing | FARE Labs Pvt. Ltd.
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers