Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-11
974 reads
Articles
Newsletter Changes for Yahoo Mail
We have recently made a few changes in our newsletter sending process and been working with Yahoo to ensure delivery. If you are just receiving this newsletter to a Yahoo account, welcome.
2010-02-10
507 reads
Time Bomb Coding
Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.
2010-02-10
18,112 reads
Find Efficiencies or Add Horsepower?
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
2010-02-10
794 reads
Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS
Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.
2010-02-10
1,883 reads
Professional Microsoft SQL Server 2008 Integration Services - Sample Chapter
Get a feel for this book from
2010-02-09
2,115 reads
Introducing SQL Server 2008 and 2008 R2 Integration Services
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.
2010-02-09
3,387 reads
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-09
3,564 reads
A guide to recover a database out from Suspect mode
This is a guide to bring back a database back from Suspect status. This covers common causes and the steps to resolve the situation.
2010-02-08
18,995 reads
PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage
Upcoming webcasts in February on the 9th and 10th of the month.
2010-02-08 (first published: 2010-02-04)
1,950 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