ARMED - Azure ARM VS Code extension
I have been working with ARM templates for a little while and have found it really annoying to test functions...
2017-12-06
14 reads
Blog Posts
Azure data centers and Regions: How to pick a best azure region.
Azure data centers and Regions:
Azure data centers are located worldwide and a team/division MCIO (Microsoft Cloud Infrastructure and Operations) manages all the data centers...
2017-12-06 (first published: 2017-11-24)
1,735 reads
Back To (Security) Basics
Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...
2017-12-06 (first published: 2017-11-27)
1,580 reads
Join Me Online Next Week for SQL in the City
It’s one week to SQL in the City 2017, once again streamed. I’ll be traveling this weekend to the Redgate...
2017-12-06
1,045 reads
Making Sense of Data Migration Assistant Assessments with Power BI
The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a...
2017-12-06
966 reads
Webinar: Understanding SQL Injection and Its Consequences
On Thursday, December 14, at 3 PM Eastern, I will be giving a presentation on SQL injection. Registration is required...
2017-12-06
472 reads
Biml for a Task Factory Dynamics CRM Source Component
I recently worked on a project where a client wanted to use Biml to create SSIS packages to stage data...
2017-12-05 (first published: 2017-11-22)
1,257 reads
Design, Deploy, and Optimize SQL Server on VMware
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-12-05
657 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...
2017-12-05
3,059 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...
2017-12-05
60 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers