In this presentation, Brian Knight shows you how to use canned SSIS components to detect data changes in a source table and only load new or conditionally update changed records. He shows you two methods: one using the OLE DB command and another using a set based operation and demostrates you the performance differences between the two.
In this presentation Brian shows you some of the new features in SQL Server 2005 SP2. Then, he demos briefly how to install SP2 and some of the small quirks around the installation.
New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.
We published a very interesting article about data warehousing in the SQL Server Standard awhile back. However the article was abridged and the author, a very respected data warehousing professional asked that we publish the entire thing here. So we bring you Harsh Bhaiya's very popular ETL treatise.
If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes.
Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables
Among the most common tasks that have not yet been discussed in this series is the Send Mail task, which will be the topic of this article.
With a new name, new capabilities, and a new focus, the product formerly called SQL Server Mobile Edition expands its reach to small-footprint desktop applicationsand it's free!
In response to an editorial on eliminating tape in favor of disk backups, new author Tim OPry brings us a look at his environment and the process by which they eliminated the need for tape in their backup scheme while maintaining a well thought out disaster plan.
It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Comments posted to this topic are about the item Fun with JSON II
Comments posted to this topic are about the item Changing Data Types
Comments posted to this topic are about the item Answering Questions On Dropped Columns
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers