The Rise of NoSQL Databases
The NoSQL concept has been attracting a lot of attention in recent years, primarily due to big-name production implementations.
2010-05-21
8,007 reads
Articles
1st New England Business Intelligence Code Camp
This is a major Business Intelligence community event for Developers and IT professionals that focus on building real-world BI solutions using the Microsoft Business Intelligence Platform tools and technology on May 22nd 2010! May 22 in Waltham, MA
2010-05-20
1,422 reads
Working with Spatial Data Part III - Reporting Spatial data using Reports Builder 3.0
Part III of our spatial data series, continues building a demo spatial data app and uses Reports Builder for detailed visual mapping.
2010-05-20
2,416 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
38,777 reads
Exploring SQL Server table metadata with SSMS and TSQL
Phil shows how to start squeezing powerful magic from SSMS for doing a detailed exploration of the metadata of your routines and tables, In this third part to the series on exploring your database schema with SQL.
2010-05-19
3,433 reads
Precompiling LINQ Queries
Did you know that by precompiling LINQ queries you might actually be degrading your app’s performance if you’re not careful? Julie Lerman explains how to ensure you’re not re-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.
2010-05-18
2,242 reads
The SSIS File Sweeper
Moving files around is a task that many DBAs need to accomplish. Whether as part of an import or export process, or just for administration purposes, this new article from JD Gonzalez can help you solve this problem.
2010-05-17
8,230 reads
Handling SQL Server Errors
This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions.
2010-05-17
5,003 reads
TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
2010-05-17
2,132 reads
Generating Insert Statements
This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.
2010-05-14 (first published: 2009-07-01)
31,257 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