Business Intelligence in SQL Server 2005, Part 1
This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.
Beauty is in the Eye of the Beholder
Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
Demo of Visual Studio Team Edition for Database Professionals
In this video by the product's Program Manager, Sachin shows you a "whistle-stop" tour of the features of Visual Studio Team Edition for Database Professionals. This is the first part in a large series all on Microsoft's new development and administration platform for SQL Server.
Data Quality
What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.
SQL Server 2005 – DML Usage on an untyped XML column
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
Using and Monitoring SQL 2005 Query Notification
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
SQL Server Spotlight on Steve Schmidt
Steve Schmidt, the backup guy for SQL Server, spent a few minutes talking about his work on SQL Server and life. A look at another very interesting member of the SQL Server development team.
Clustering SSIS
By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.
Time for Training
Keeping up with your professional development is tough. In the first part of his series, Andy Warren talked about the challenges of keeping current. This article takes a look at how you can effectively find time to grow your career.
Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Se
This article discusses: Extensibility in SQL Server 2005 Reporting Services, Creating and debugging custom report items, The ProgressTracker CRI sample.
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