The Ultimate SQL Server JSON Cheat Sheet
This post is a reference of my examples for processing JSON data in SQL Server. For more detailed explanations of these functions, please see my post series on JSON...
2017-03-07
125 reads
Bert Wagner
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons
This is the fourth article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON,...
2017-02-21
14 reads
How SQL 2016's JSON Functionality Will Make You Want To Use JSON
This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...
2017-02-14
38 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 3: Updating, Adding, and Deleting…
This is the third article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON...
2017-02-07
23 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON
This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.
Part...
2017-01-31
12 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Overview Part 1: Parsing JSON
As a developer my favorite new feature of SQL Server 2016 is JSON support.
I love JSON in SQL because I already love JSON everywhere outside of SQL: it uses...
2017-01-24
19 reads
Present Like Nobody's Watching
Last week I presented my session High Performance SSRS at the inaugural GroupBy Conference. It was an incredibly fun experience getting to present a topic I'm excited about as...
2017-01-17
6 reads
The Most Lacking Feature In SSRS (7 years and no fix?)
This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...
2017-01-10
5 reads
Epic Life Quests
It is easy to get caught up in the daily details of life and not take the time to reflect on longer term goals and accomplishments.
Inspired by Brent Ozar...
2017-01-03
9 reads
XmlReader vs XmlDocument Performance
Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...
2016-11-24
12 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers