Sending SSIS Errors to the Windows Event Log
In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...
2010-02-01
4,763 reads
Blog Posts
Some BI Related Official Microsoft Related SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
295 reads
Some BI Related Official Microsoft SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
757 reads
Some Selected Official Microsoft SQL Server Blogs
Here is a list of a some of the official Microsoft SQL Server blogs that I have stumbled across. Some...
2010-02-01
333 reads
SQL Saturday #34 Wrap-up
Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...
2010-02-01
582 reads
Stored Procedure to Sequentially Run SQL Agent Jobs
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
2,517 reads
Teaching Two SQL Server 2008 Classes at University of Denver, University College in Spring Quarter
I’ll be teaching two SQL Server 2008 classes this spring at University of Denver, University College. The first one, which...
2010-02-01
778 reads
The Powershell V1 to V2 Conversion
This post is about my experience converting the CodePlex project, SQL Server Powershell Extensions (SQLPSX) Powershell V1 function libraries into PowerShell V2 Advanced...
2010-02-01
2,076 reads
Why You Should Volunteer for a Code Camp / SQL Saturday
This past weekend I was at the Columbia Code Camp, which was a rousing success with 6 tracks, a number...
2010-02-01
1,101 reads
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there...
2010-01-31
11,959 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers