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
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers