Stairway to XML: Level 4 - Querying XML Data
You can extract a subset of data from an XML instance by using the query() method, and you can use the value() method to retrieve individual element and attribute values from an XML instance.
Tablix Tutorial – Level 4 in the Stairway to Reporting Services
This article shows how to group information, adjust for dynamic column and row groups, and generally use the tablix in Reporting Services.
The Basics of SSRS - Level 2 in the Stairway to Reporting Services
In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.
The Basics of SSRS - Level 2 in the Stairway to Reporting Services
In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.
Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services
Part four of this stairway series examines the process of updating the data in an existing table in a load. MVP Andy Leonard talks about the way in which packages can handle changes in a repeatable fashion.
Using SQL Server Dynamic Online Catalog to Explore Keys and Relationships: Stairway to Exploring Database Metadata Level 4
This level introduces keys, constraints, and relationships.
Using SQL Server Dynamic Online Catalog to Solve Problems: Stairway to Exploring Database Metadata Level 2
In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.
What is SSIS? Level 1 of the Stairway to Integration Services
Learn about the very basics of what Integration Services is and how it's used in SQL Server.
What is StreamInsight and why does it matter?
An introduction to SQL Server StreamInsight and Complex Event Processing with a focus on Business Intelligence.
Creating CRUD Stored Procedures in SQL
Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
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...
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