The Scary DBA

Blog Post

XQuery For Idiots

I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...

2009-11-30

1,732 reads

Blog Post

SQL Server XQuery For Idiots

I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...

2009-11-30

1,523 reads

Blog Post

Proof

SQL Rockstar tells me that unless there are photo’s, it didn’t happen. Brad McGehee published some pictures from DevConnections. See,...

2009-11-17

609 reads

Blogs

SQL Training: Black Friday Deals Up to 75% Off

By

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

When is the perfect moment to build a data strategy in a company?

By

The post When is the perfect moment to build a data strategy in a...

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Read the latest Blogs

Forums

Migration of on-premises SQL Server to an AWS PostgreSQL database

By Abhishek

We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

By Site Owners

Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...

Visit the forum

Question of the Day

Renaming a Database

If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)  

See possible answers