2016-08-17
90 reads
Articles
Simple T-SQL Code Comparison With PowerShell
Tim Smith shows how you can use PowerShell to automate a simple comparison of objects such as stored procedures, views, and fucntions.
2016-08-17
3,933 reads
SQL Server 2016: built-in JSON Use case scenarios
There's built-in JSON support starting with SQL Server 2016. Does that mean we should all ditch XML and start using JSON? It depends mostly on the target of your data output processing.
2016-08-16
5,290 reads
Crossing the Site Domain with JavaScript
Browsers try to prevent a range of malicious attacks by preventing content being accessed by a web page from a different domain to the one that the page was fetched from. If you have a legitimate need to do this, it is a bad idea to disable this method of defence: Instead, there are more legitimate and safer ways of performing cross-domain JavaScript calls such as JSONP or Cross-Origin Resource Sharing, as Dino explains.
2016-08-16
2,961 reads
Free eBook: SQL Server Hardware
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
2016-08-16 (first published: 2013-07-24)
58,113 reads
Bash for ETL pre-processing
People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today
2016-08-15
6,519 reads
Paying Attention to Estimates
Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
2016-08-15
3,092 reads
Biml Academy 2 - Importing, Staging, and Loading Data
Next week are 5 more lessons on working iwth Bilm. Each day, Aug 15-19, at 1:00pm EDT.
2016-08-12
3,417 reads
SQL Server Stored Procedure to Compress Non Partitioned Tables
My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I
2016-08-12
2,979 reads
Executing Multiple Threads to Create a Load
Learn a few techniques for executing multiple sets of queries at once.
2016-08-11
6,429 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