64-bit
I wrote an editorial on the 64-bit decision by Exchange to not release
their next version in 32 bit. Only 64....
2005-11-29
1,435 reads
Blog Posts
Update on MSSQL::OlleDB - Name Change
SQL Server MVP Erland Sommarskog has announced
a name change to MSSQL::OlleDB. It's now known as Win32::SQLServer.
This is to bring it...
2005-11-27
1,342 reads
New Version of Apex SQL Edit released
Looked over at the Apex SQL site and noticed they released a new
version of ApexSQL Edit last weekend. I went...
2005-11-26
1,509 reads
"Predicate Evaluation Order"
In writing an article for SQL Server Standard's January issue, I received a tech edit comment from Adam Machanic
about a...
2005-11-25
1,491 reads
PromptSQL - Intellisense for SQL Server
Visual Studio has spoiled me. I love the Intellisense feature that has continued to evolve with each new edition of Microsoft's...
2005-11-25
1,517 reads
Writing an article - don't be afraid to get started!
Writing at article for SQL Server Central tends to be a very rewarding
experience. Every chance I get, I encourage others...
2005-11-25
1,491 reads
New version of ADO.NET provider for MySQL is available
The following announcement came out this morning on the Annouce mailing list for MySQL:
"MySQL Connector/Net 1.0.7, a new version of...
2005-11-21
1,631 reads
Brief from David Litchfield about Administrator Logins to a Database Server
David Litchfield has put out a brief (as
he says it, "It's called a brief because there's enough meat to make...
2005-11-19
1,402 reads
Google Base
There has been some talk on Google Base on the Full Disclosure security
list. I've also seen on another blog about...
2005-11-19
1,393 reads
MySQL 5.0 Released
Catching back up on things. MySQL 5.0 went "RTM" at the end of October.
Haven't had a lot of chances to...
2005-11-19
1,367 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