Sample Chapter from Professional SQL Server 2005 Integration Services
Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services
to his blog a few days ago. Last...
2006-01-04
1,477 reads
Blog Posts
Simple Script to Report Tables Sizes in a SQL2K Database
Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...
2006-01-04
1,336 reads
Philosophy on Soldiering
This is taken from the book About Face:The Odyssey of an American Warrior.
The author is Col. David "Hack" Hackworth, one...
2006-01-01
1,412 reads
The Perils of Java Schools
This is great, another rant from Joel, this time on the state of CS Degrees.
I didn't grow up in the...
2005-12-30
1,601 reads
Unpatched Microsoft Windows WMF Vulnerability
If you haven't heard by now, there is an unpatched exploit in how
Windows handles WMF files. Since this handling is...
2005-12-28
1,434 reads
Last Minute Testing
I've had a new web server for a couple months and I've been slowly testing things as I can in...
2005-12-28
1,368 reads
Cute comic
My son ran across this comic and was sure I would enjoy it: http://www.qwantz.com/index.pl?comic=153
2005-12-23
1,566 reads
Aggregate queries
Be sure to read my article on SQLServerCentral on building aggregate queries: http://www.sqlservercentral.com/columnists/kKellenberger/aggregatequeries.asp
2005-12-21
1,577 reads
SQL Server Connections
I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections...
2005-12-21
1,405 reads
SQL Server 2005 Administrator's Pocket Consultant available
Saw this at the book store this evening and picked it up.
SQL Server 2005 Administrator's Pocket Consultant
I'll spend the...
2005-12-18
1,494 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...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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