Remote sessions at Data Céilí
At Data Céilí 2020 we want to be as green as possible and one idea we’ve had is to run a Green Track that will host remote sessions from...
2020-01-08
12 reads
Blog Posts
Running Powershell Scripts – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When you install Windows, by default, the execution...
2020-01-08
145 reads
The curious case of the sqlcmd password
In August last year I posted about a command line parser problem I ran into with AzCopy, which I eventually resolved by writing a batch file and escaping a...
2020-01-08
30 reads
Azure Synapse Analytics & Power BI concurrency
As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products. A common question I...
2020-01-07 (first published: 2019-12-27)
783 reads
Call for Speakers for Orlando Code Camp 2020 is Open
Code Camp will be March 28th, 2020 at Seminole State College. The fifteenth consecutive year! They are definitely interested in developer/end user SQL content and would like at least...
2020-01-07
39 reads
Easy Audit Index Changes
When looking for an easy method to audit Index changes, one of the first technologies to try really should be Extended Events (xevents).
Related Posts:
Implicit Conversion Insights with XE June...
2020-01-07 (first published: 2019-12-27)
414 reads
Re-Inventing Humanity
Are we Human or Robots ? AI & ML shall definitely change the world some day in future. One thing is also sure, very soon we’ll also become machines...
2020-01-07
15 reads
SQLpassion Online Training about SQL Server on VMware – Best Practices
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-01-07
116 reads
SQLpassion Online Training about SQL Server on VMware – Best Practices
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-01-07
9 reads
Using Python And NetworkX To Build A Twitter Follower Recommendation Engine
Watch this week's video on YouTube
This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on Twitter...
2020-01-07
11 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